private void UOW_BeforeCommitTransaction(object sender, DevExpress.Xpo.SessionManipulationEventArgs e)
{
// Get NewId
int id = 0;
object obj = Classes.Managers.DataManager.GetNewId("TblEmp", "EmpId");
if (obj == null)
{
MsgDlg.ShowAlert(Properties.Settings.Default.msg_SavingFailed, MsgDlg.MessageType.Error, (Form)Parent.Parent.Parent);
return;
}
id = Convert.ToInt32(obj);
// Assgin NewId to New Rows
DevExpress.Xpo.Helpers.ObjectSet Rows = (DevExpress.Xpo.Helpers.ObjectSet)e.Session.GetObjectsToSave();
foreach (DevExpress.Xpo.Metadata.XPDataTableObject item in Rows)
{
if (item.GetMemberValue("EmpId") == null)
{
item.SetMemberValue("EmpId", id);
id++;
}
item.SetMemberValue("dateIn", Classes.Managers.DataManager.GetServerDatetime);
item.SetMemberValue("UserIn", Classes.Managers.UserManager.defaultInstance.User.UserId);
}
}
private void sessionCat_BeforeCommitTransaction(object sender, DevExpress.Xpo.SessionManipulationEventArgs e)
{
DevExpress.Xpo.Helpers.ObjectSet Rows = (DevExpress.Xpo.Helpers.ObjectSet)e.Session.GetObjectsToSave();
foreach (DevExpress.Xpo.Metadata.XPDataTableObject item in Rows)
{
item.SetMemberValue("UserIn", Classes.Managers.UserManager.defaultInstance.User.UserId);
item.SetMemberValue("dateIn", Classes.Managers.DataManager.GetServerDatetime);
}
}
private void sessionData_BeforeCommitTransaction(object sender, DevExpress.Xpo.SessionManipulationEventArgs e)
{
DevExpress.Xpo.Helpers.ObjectSet obj = (DevExpress.Xpo.Helpers.ObjectSet)e.Session.GetObjectsToSave(true);
foreach (DevExpress.Xpo.Metadata.XPDataTableObject item in obj)
{
if (item.IsDeleted)
{
continue;
}
//if (item.GetMemberValue("LabelId").ToString() == "-1")
// item.SetMemberValue("LabelId", Classes.Managers.DataManager.adpQry.GetNewId_TBLLabel());
item.SetMemberValue("userin", Classes.Managers.UserManager.UserInfo.UserID);
item.SetMemberValue("datein", Classes.Managers.DataManager.GetServerDatetime);
}
}
