public static void EZLog(DataRow drOld, DataRow dr, string tblN, string ASSEMBLY_NAME, string formName, object userID)
{
string keysValue = string.Empty;
string keysName = string.Empty;
string strEmployeeID = string.Empty;
if (dr.Table.Columns.Contains("EmployeeID"))
{
strEmployeeID = drOld["EmployeeID"].ToString();
}
string columnName = string.Empty;
try
{
if (tblN.Equals(string.Empty))
{
keysValue = "";
}
else
{
keysValue = GetKeyValue(drOld, tblN);
}
switch (dr.RowState)
{
case DataRowState.Deleted:
//log delete data
keysName = GetKeyName(tblN);
EZLog("Delete", keysName, keysValue, "", tblN, ASSEMBLY_NAME, formName, userID, strEmployeeID);
break;
case DataRowState.Added:
keysName = GetKeyName(tblN);
EZLog("Add new", keysName, "", keysValue, tblN, ASSEMBLY_NAME, formName, userID, strEmployeeID);
break;
case DataRowState.Modified:
for (int i = 0; i < dr.Table.Columns.Count; i++)
{
if (!(dr[i].ToString().Equals(drOld[i].ToString())))
{
//Log modified
columnName = UIMessage.Get_Message(dr.Table.Columns[i].Caption);
keysName = String.Format("({0} , {1})", keysValue, columnName);
EZLog("Modified", keysName, drOld[i].ToString(), dr[i].ToString(), tblN, ASSEMBLY_NAME, formName, userID, strEmployeeID);
}
}
break;
default:
//log delete data
keysName = GetKeyName(tblN);
EZLog("Delete", keysName, keysValue, "", tblN, ASSEMBLY_NAME, formName, userID, strEmployeeID);
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
private static void SetValidationToControl(ref Control ctr, DataRow dr)
{
try
{
if (ctr is DevExpress.XtraEditors.LookUpEdit)
{
DevExpress.XtraEditors.LookUpEdit led = ctr as DevExpress.XtraEditors.LookUpEdit;
AddDataSource(ref led, UIMessage.DBEngine.execReturnDataTable(dr[CommonConst.Validation].ToString(), CommonConst.A_LoginID, UIMessage.userID));
}
else
{
//Devexpress valiation rules
string[] strSpl = dr[CommonConst.Validation].ToString().Split(':');
if (strSpl[0].Contains("ConditionValidationRule"))
{
ConditionValidationRule cvr = new ConditionValidationRule();
switch (strSpl[1])
{
case "IsNotBlank":
cvr.ConditionOperator = ConditionOperator.IsNotBlank;
cvr.ErrorText = UIMessage.Get_Message(dr[CommonConst.ValidationMessID].ToString());
break;
case "Between":
cvr.ConditionOperator = ConditionOperator.Between;
cvr.Value1 = Convert.ToInt64(strSpl[2]);
cvr.Value2 = Convert.ToInt64(strSpl[3]);
cvr.ErrorText = string.Format(UIMessage.Get_Message(dr[CommonConst.ValidationMessID].ToString()), cvr.Value1, cvr.Value2);
break;
case "Contains":
cvr.ConditionOperator = ConditionOperator.Contains;
cvr.Value1 = Convert.ToInt64(strSpl[2]);
cvr.ErrorText = string.Format(UIMessage.Get_Message(dr[CommonConst.ValidationMessID].ToString()), cvr.Value1);
break;
case "NotAnyOf":
cvr.ConditionOperator = ConditionOperator.NotAnyOf;
cvr.Value1 = Convert.ToInt64(strSpl[2]);
cvr.ErrorText = string.Format(UIMessage.Get_Message(dr[CommonConst.ValidationMessID].ToString()), cvr.Value1);
break;
}
cvr.ErrorType = ErrorType.Default;
dxValidationProvider1.SetValidationRule(ctr, cvr);
dxValidationProvider1.ValidationMode = ValidationMode.Auto;
}
}
}
catch (Exception ex)
{
Helper.LogError(ex, ex.Message, "SetValidationToControl");
}
}
private void EZLog(DataRow drOld, DataRow dr, string tblN)
{
string keysValue = string.Empty;
string keysName = string.Empty;
string columnName = string.Empty;
string strEmployeeID = string.Empty;
try
{
keysValue = GetKeyValue(drOld, tblN);
if (dr.Table.Columns.Contains(CommonConst.EmployeeID))
{
strEmployeeID = dr[CommonConst.EmployeeID].ToString();
}
switch (dr.RowState)
{
case DataRowState.Deleted:
//log delete data
keysName = GetKeyName(tblN);
EZLog("Delete", keysName, keysValue, "", tblN, strEmployeeID);
break;
case DataRowState.Added:
keysName = GetKeyName(tblN);
EZLog("Add new", keysName, "", keysValue, tblN, strEmployeeID);
break;
case DataRowState.Modified:
for (int i = 0; i < dr.Table.Columns.Count; i++)
{
if (!(dr[i].ToString().Equals(drOld[i].ToString())))
{
//Log modified
columnName = UIMessage.Get_Message(dr.Table.Columns[i].Caption);
keysName = String.Format("({0} , {1})", keysValue, columnName);
EZLog("Modified", keysName, drOld[i].ToString(), dr[i].ToString(), tblN, strEmployeeID);
}
}
break;
default:
//log delete data
keysName = GetKeyName(tblN);
EZLog("Delete", keysName, keysValue, "", tblN, strEmployeeID);
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void LoadControlsLayOut(ref System.Windows.Forms.SplitContainer ctrs, string formName)
{
int height = 0;
const int width = 250;
const int heightBox = 32;
Control ctlParent = ctrs.Panel1;
try
{
string ControlName = string.Empty;
DataTable dt = UIMessage.DBEngine.execReturnDataTable(string.Format("select * from tblFormLayout where FormName = '{0}' and (IsLayout is null or IsLayout =0)", formName));
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ControlName = dr["ControlName"].ToString();
if (ctlParent.Controls.Find(ControlName, true).Length <= 0)
{
DevExpress.XtraEditors.LabelControl lbl = new DevExpress.XtraEditors.LabelControl()
{
Name = string.Format("lbl{0}", ControlName), Text = UIMessage.Get_Message(string.Format("lbl{0}", ControlName)), Location = new Point(10, height)
};
ctlParent.Controls.Add(lbl);
switch (dr["SystemType"].ToString())
{
case "ComboBox":
DevExpress.XtraEditors.LookUpEdit led = new DevExpress.XtraEditors.LookUpEdit()
{
Name = string.Format("cbx{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(led);
break;
case "Datetime":
case "Date":
if (!ControlName.ToLower().Contains("time"))
{
DevExpress.XtraEditors.DateEdit dtp = new DevExpress.XtraEditors.DateEdit()
{
Name = string.Format("dtp{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(dtp);
}
else
{
DevExpress.XtraEditors.TimeEdit tid = new DevExpress.XtraEditors.TimeEdit()
{
Name = string.Format("tid{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(tid);
}
break;
case "Time":
DevExpress.XtraEditors.TimeEdit tid1 = new DevExpress.XtraEditors.TimeEdit()
{
Name = string.Format("tid{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(tid1);
break;
case "CheckEdit":
DevExpress.XtraEditors.CheckEdit ckb = new DevExpress.XtraEditors.CheckEdit()
{
Name = string.Format("ckb{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(ckb);
break;
case "PictureEdit":
DevExpress.XtraEditors.PictureEdit pic = new DevExpress.XtraEditors.PictureEdit()
{
Name = string.Format("ckb{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(pic);
break;
default:
DevExpress.XtraEditors.TextEdit txt = new DevExpress.XtraEditors.TextEdit()
{
Name = string.Format("txt{0}", ControlName), Location = new Point(130, height), Width = width, Height = heightBox
};
ctlParent.Controls.Add(txt);
break;
}
height += 25;
}
}
}
}
catch (Exception ex)
{
Helper.LogError(ex, ex.Message, "LoadControlsLayOut()");
}
LoadDesignedControls(ctrs, formName);
}
