//writing the note in the notepad
public void writeToNotepad(string strTxt)
{
StreamWriter strWriter = File.AppendText(@"c:\Hello.txt");
strWriter.Write(strTxt + "\n");
strWriter.Close();
}
//Db information
public void saveData(string strUserName, string dtTime, string strDesc)
{
//dtTime = DateTime.Now.ToString() ;
SqlConnection con = new SqlConnection("server=madan;uid=sa;pwd=madan@123;database=mydb");
string sqlStr = "insert into allevents values('" + strUserName + "','" + dtTime + "','" + strDesc + "')";
SqlCommand cmd = new SqlCommand(sqlStr, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
}
/// <summary>
/// An item is being added.
/// </summary>
public override void ItemAdding(SPItemEventProperties properties)
{
writeToNotepad("Item Adding :" + properties.ListItem.Title + " Adding time " + DateTime.Now.ToString());
saveData("Madan", DateTime.Now.ToString(), "Item adding");
//saveData("Madan", DateTime.Now.ToString(), "Iteam Adding");
}
/// <summary>
/// An item is being updated.
/// </summary>
public override void ItemUpdating(SPItemEventProperties properties)
{
writeToNotepad("Item Updating :" + properties.ListItem.Title + " Updating time " + DateTime.Now.ToString());
saveData("Madan", DateTime.Now.ToString(), "Item Updating");
}
/// <summary>
/// An item is being deleted.
/// </summary>
public override void ItemDeleting(SPItemEventProperties properties)
{
properties.Cancel = true;
properties.ErrorMessage = "Evening batch you dont have the delete permissions..";
}
/// <summary>
/// An item is being checked in.
/// </summary>
public override void ItemCheckingIn(SPItemEventProperties properties)
{
base.ItemCheckingIn(properties);
}
/// <summary>
/// An item is being checked out.
/// </summary>
public override void ItemCheckingOut(SPItemEventProperties properties)
{
base.ItemCheckingOut(properties);
}
/// <summary>
/// A file is being moved.
/// </summary>
public override void ItemFileMoving(SPItemEventProperties properties)
{
base.ItemFileMoving(properties);
}
public override void ItemDeleted(SPItemEventProperties properties)
{
base.ItemDeleted(properties);
}
