public void Delete()
{
if (txtLoginName.Text == "" || txtPassword.Text == "")
{
return;
}
if (dtLoginInfo.Rows[0][AdminRight] != DBNull.Value && Convert.ToBoolean(dtLoginInfo.Rows[0][AdminRight]) == true)
{
Methods.ShowMessage("CANNOT_DELETE_ADMIN", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (Methods.ShowMessage("3", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
try
{
DBEngine.beginTransaction();
DBEngine.exec("SC_User_Delete", CommonConst.A_LoginID, StaticVars.LoginID, "@p_LoginID", dtLoginInfo.Rows[0][strLoginID]);
DBEngine.commit();
Methods.ShowMessage(Common.CommonConst.DELETE_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
DBEngine.rollback();
Methods.ShowError(ex);
}
}
// =======================================================
// NAME: Commit
// TASK: Override Commit() method to save data
// PARAM:
// RETURN: TRUE = successfully, FALSE = fail
// THROW:
// REV:
// 2003-12-
// =======================================================
/// <summary>
/// Save data
/// </summary>
public override bool Commit()
{
// remember current Action State
HPA.Component.Framework.Base.EActionState eOldActionState = ActionState;
try
{
// switch to COMMITING state
ActionState = HPA.Component.Framework.Base.EActionState.BUSY;
// wait-cursor
this.Cursor = Cursors.WaitCursor;
try
{
DBEngine.beginTransaction();
// TODO - add code here to perform commiting tasks
DBEngine.commit();
}
catch (Exception ex)
{
DBEngine.rollback();
throw(ex);
}
// restore cursor
this.Cursor = Cursors.Default;
// restore action state
ActionState = eOldActionState;
}
catch (Exception e)
{
// restore cursor
this.Cursor = Cursors.Default;
// show error
HPA.Common.Helper.ShowException(e, this.Name + ".Commit()", null);
// restore action state
ActionState = eOldActionState;
// unable to commit
return(false);
}
// commit successfully
return(true);
}
private void btnSave_Click(object sender, EventArgs e)
{
HPA.Properties.Settings.Default.LanguageID = txtLanguageID.Text;
HPA.Properties.Settings.Default.EnterToTab = ckbEnter_to_tab.Checked;
HPA.Properties.Settings.Default.UsedModenMenu = ckbUsedModenMenu.Checked;
HPA.Properties.Settings.Default.WallpaperPath = strWallPaperPath;
HPA.Properties.Settings.Default.LoginWallpaper = strLoginWallpaper;
HPA.Properties.Settings.Default.LockProgramInterval = Convert.ToInt32(txtInterval.EditValue);
HPA.Properties.Settings.Default.Save();
if (dtLableNameList == null)
{
return;
}
try
{
DataTable dtChanged = dtLableNameList.GetChanges();
if (dtChanged == null || dtChanged.Rows.Count <= 0)
{
return;
}
DBEngine.beginTransaction();
foreach (DataRow dr in dtChanged.Rows)
{
DBEngine.exec("sp_LableName_Language_Save", CommonConst.A_LoginID, UIMessage.userID,
"@LanguageID", txtLanguageID.Text, "@MessageID", dr["MessageID"], "@Content", dr["Content"]);
}
DBEngine.commit();
dtLableNameList.AcceptChanges();
UIMessage.ShowMessage(CommonConst.DATASAVED_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
// m_dtTableData.RejectChanges();
DBEngine.rollback();
throw (ex);
}
// restore cursor
this.Cursor = Cursors.Default;
}
public void Add()
{
if (txtLoginName.Text != "" && txtPassword.Text != "")
{
try
{
DBEngine.beginTransaction();
DBEngine.exec("SC_User_Insert", "@p_LoginName", txtLoginName.Text.Trim(),
"@p_Password", txtPassword.Text.Trim(),
"@p_EmployeeID", txtEmployeeID.Text.Trim(),
"@p_DepartmentID", dtLoginInfo.Rows[0]["DepartmentID"]);
DBEngine.commit();
LoadLoginInfo();
}
catch (Exception ex)
{
DBEngine.rollback();
Methods.ShowError(ex);
return;
}
}
}
public override bool OnDelete()
{
if (!base.OnDelete())
{
return(false);
}
if (dtLoginInfor.Rows[0][AdminRight] != DBNull.Value && Convert.ToBoolean(dtLoginInfor.Rows[0][AdminRight]) == true)
{
UIMessage.ShowMessage("CANNOT_DELETE_ADMIN", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (UIMessage.ShowMessage(3, System.Windows.Forms.MessageBoxButtons.YesNo,
System.Windows.Forms.MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No)
{
return(false);
}
try
{
DBEngine.beginTransaction();
// Delete user from tblSC_Login
// Delete from Right table
// Delete from DevSecView table
DBEngine.exec("SC_User_Delete",
CommonConst.A_LoginID, UserID,
"@p_LoginID", dtLoginInfor.Rows[0][LoginID]);
}
catch (Exception ex)
{
DBEngine.rollback();
HPA.Common.Helper.ShowException(ex, this.Name, "OnDelete");
}
UIMessage.ShowMessage(HPA.Common.CommonConst.DELETE_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadLoginInfo();
txtEmployeeID.Focus();
DBEngine.commit();
return(true);
}
public override bool Commit()
{
try
{
if (SaveProdureName_TA.Equals(string.Empty))
{
return(true);
}
if (UIMessage.ShowMessage(2, System.Windows.Forms.MessageBoxButtons.YesNo,
System.Windows.Forms.MessageBoxIcon.Question) == DialogResult.No)
{
return(false);
}
// wait-cursor
this.Cursor = Cursors.WaitCursor;
short a;
try
{
DBEngine.beginTransaction();
CRowUtility.updateDataRow(grvAttendanceList);
grvAttendanceList.BeginUpdate();
if (dtAttendanceList != null)
{
DataTable dtChanges = dtAttendanceList.GetChanges();
foreach (DataRow dr in dtChanges.Rows)
{
foreach (DataColumn dc in dtChanges.Columns)
{
if (dr[dc.ColumnName] != dr[dc.ColumnName, DataRowVersion.Original])
{
if (Int16.TryParse(dc.ColumnName, out a))
{
DBEngine.exec(SaveProdureName_TA,
CommonConst.A_LoginID, this.UserID,
CommonConst.A_Month, month,
CommonConst.A_Year, year,
CommonConst.A_EmployeeID, dr[CommonConst.EmployeeID],
"@DateName", dc.ColumnName,
"@Value", dr[dc.ColumnName]);
}
}
}
}
}
grvAttendanceList.EndUpdate();
dtAttendanceList.AcceptChanges();
DBEngine.commit();
}
catch (Exception ex)
{
grvAttendanceList.EndUpdate();
DBEngine.rollback();
throw (ex);
}
// restore cursor
this.Cursor = Cursors.Default;
}
catch (Exception e)
{
// restore cursor
this.Cursor = Cursors.Default;
// show error
HPA.Common.Helper.ShowException(e, this.Name + ".Commit()", null);
// unable to commit
return(false);
}
txtEmployeeID_Search.Focus();
txtEmployeeID_Search.SelectAll();
return(true);
}
public void Save()
{
bool success = false;
if (txtLoginName.Text == "" || txtPassword.Text == "")
{
return;
}
try
{
DBEngine.beginTransaction();
//if (dtLoginInfo.GetChanges() != null && dtLoginInfo.GetChanges().Rows.Count > 0)
{
DBEngine.exec("SC_LoginInfo_Save", CommonConst.A_LoginID, StaticVars.LoginID,
"@LoginName", txtLoginName.Text,
"@Password", Encryption.EncryptText(txtPassword.Text, true),
"@EmployeeID", txtEmployeeID.Text,
"@DepartmentID", dtLoginInfo.Rows[0][strDepartmentID].ToString());
}
if (dtObjectList.GetChanges() != null && dtObjectList.GetChanges().Rows.Count > 0)
{
foreach (DataRow dtRow in dtObjectList.Rows)
{
DBEngine.exec("SC_UserObjects_Save",
CommonConst.A_LoginID, StaticVars.LoginID,
"@p_LoginID", dtLoginInfo.Rows[0][strLoginID],
"@p_ObjectID", dtRow[strObjectID],
"@p_FullAccess", dtRow["Right"]);
}
}
if (dtDepartment.GetChanges() != null && dtDepartment.GetChanges().Rows.Count > 0)
{
foreach (DataRow dtRow in dtDepartment.Rows)
{
DBEngine.exec("SC_UserDeptViewInfo_Save",
CommonConst.A_LoginID, StaticVars.LoginID,
"@p_LoginID", dtLoginInfo.Rows[0][strLoginID],
"@p_DepartmentID", dtRow[strDepartmentID],
"@p_ViewInfo", dtRow[strViewInfo]);
}
}
if (dtSection.GetChanges() != null && dtSection.GetChanges().Rows.Count > 0)
{
foreach (DataRow dtRow in dtSection.Rows)
{
DBEngine.exec("SC_UserSectViewInfo_Save",
CommonConst.A_LoginID, StaticVars.LoginID,
"@p_LoginID", dtLoginInfo.Rows[0][strLoginID],
"@p_DepartmentID", dtRow[strDepartmentID],
"@p_SectionID", dtRow[strSectionID],
"@p_ViewInfo", dtRow[strViewInfo]);
}
}
DBEngine.commit();
LoadLoginInfo();
success = true;
}
catch
{
DBEngine.rollback();
success = false;
}
if (success)
{
Methods.ShowMessage(Common.CommonConst.DATASAVED_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Methods.ShowMessage(Common.CommonConst.DELETE_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
// =======================================================
// NAME: OnDelete
// TASK: Override OnDelete() method to perform delete tasks.
// PARAM:
// RETURN: TRUE = successfully, FALSE = fail
// THROW:
// REV:
// 2003-12-
// =======================================================
/// <summary>
/// Perform delete tasks
/// </summary>
public override bool OnDelete()
{
if (!base.OnDelete())
{
return(false);
}
try
{
// wait-cursor
this.Cursor = Cursors.WaitCursor;
DataRow dr = grvShiftSetting.GetDataRow(grvShiftSetting.FocusedRowHandle);
if (dr == null)
{
UIMessage.ShowMessage(1992, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation);
return(false);
}
grvShiftSetting.CloseEditor();
grvShiftSetting.UpdateCurrentRow();
grvShiftSetting.BeginUpdate();
if (UIMessage.ShowMessage(3, System.Windows.Forms.MessageBoxButtons.YesNo,
System.Windows.Forms.MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
DBEngine.beginTransaction();
try
{
DBEngine.exec("MD_WorkingShift_Delete",
"@ShiftCode", dr[ShiftCode, DataRowVersion.Original],
CommonConst.A_LoginID, this.UserID);
}
catch (Exception ex)
{
DBEngine.rollback();
HPA.Common.Helper.ShowException(ex, this.Name, "OnDelete");
}
DBEngine.commit();
UIMessage.ShowMessage(CommonConst.DELETE_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
myInit();
}
grvShiftSetting.EndUpdate();
// TODO - add code here to perform delete tasks
// restore cursor
this.Cursor = Cursors.Default;
}
catch (Exception e)
{
// restore cursor
this.Cursor = Cursors.Default;
// show error
HPA.Common.Helper.ShowException(e, this.Name + ".OnDelete()", null);
// unable to delete
return(false);
}
// delete successfully
return(true);
}
// =======================================================
// NAME: Commit
// TASK: Override Commit() method to save data
// PARAM:
// RETURN: TRUE = successfully, FALSE = fail
// THROW:
// REV:
// 2003-12-
// =======================================================
/// <summary>
/// Save data
/// </summary>
public override bool Commit()
{
try
{
// wait-cursor
this.Cursor = Cursors.WaitCursor;
try
{
DBEngine.beginTransaction();
DBEngine.exec("MD_WorkingShift_Update",
"@ShiftCode", txtShiftCode.Text,
"@ShiftName", txtShiftName.Text,
"@ShiftAllowance", txtShiftAllowance.EditValue,
"@HilightColorCode", txtHilightColorCode.EditValue,
"@WorkStart1", tedWorkStart1.EditValue,
"@WorkEnd1", tedWorkEnd1.EditValue,
"@BreakStart1", tedBreakStart1.EditValue,
"@BreakEnd1", tedBreakEnd1.EditValue,
"@DayOff1", ckbDayoff1.EditValue,
"@WorkStart2", tedWorkStart2.EditValue,
"@WorkEnd2", tedWorkEnd2.EditValue,
"@BreakStart2", tedBreakStart2.EditValue,
"@BreakEnd2", tedBreakEnd2.EditValue,
"@DayOff2", ckbDayoff2.EditValue,
"@WorkStart3", tedWorkStart3.EditValue,
"@WorkEnd3", tedWorkEnd3.EditValue,
"@BreakStart3", tedBreakStart3.EditValue,
"@BreakEnd3", tedBreakEnd3.EditValue,
"@DayOff3", ckbDayoff3.EditValue,
"@WorkStart4", tedWorkStart4.EditValue,
"@WorkEnd4", tedWorkEnd4.EditValue,
"@BreakStart4", tedBreakStart4.EditValue,
"@BreakEnd4", tedBreakEnd4.EditValue,
"@DayOff4", ckbDayoff4.EditValue,
"@WorkStart5", tedWorkStart5.EditValue,
"@WorkEnd5", tedWorkEnd5.EditValue,
"@BreakStart5", tedBreakStart5.EditValue,
"@BreakEnd5", tedBreakEnd5.EditValue,
"@DayOff5", ckbDayoff5.EditValue,
"@WorkStart6", tedWorkStart6.EditValue,
"@WorkEnd6", tedWorkEnd6.EditValue,
"@BreakStart6", tedBreakStart6.EditValue,
"@BreakEnd6", tedBreakEnd6.EditValue,
"@DayOff6", ckbDayoff6.EditValue,
"@WorkStart7", tedWorkStart7.EditValue,
"@WorkEnd7", tedWorkEnd7.EditValue,
"@BreakStart7", tedBreakStart7.EditValue,
"@BreakEnd7", tedBreakEnd7.EditValue,
"@OTBeforeStart1", tedOTBeforeStart1.EditValue,
"@OTBeforeStart2", tedOTBeforeStart2.EditValue,
"@OTBeforeStart3", tedOTBeforeStart3.EditValue,
"@OTBeforeStart4", tedOTBeforeStart4.EditValue,
"@OTBeforeStart5", tedOTBeforeStart5.EditValue,
"@OTBeforeStart6", tedOTBeforeStart6.EditValue,
"@OTBeforeStart7", tedOTBeforeStart7.EditValue,
"@OTBeforeEnd1", tedOTBeforeEnd1.EditValue,
"@OTBeforeEnd2", tedOTBeforeEnd2.EditValue,
"@OTBeforeEnd3", tedOTBeforeEnd3.EditValue,
"@OTBeforeEnd4", tedOTBeforeEnd4.EditValue,
"@OTBeforeEnd5", tedOTBeforeEnd5.EditValue,
"@OTBeforeEnd6", tedOTBeforeEnd6.EditValue,
"@OTBeforeEnd7", tedOTBeforeEnd7.EditValue,
"@OTAfterStart1", tedOTAfterStart1.EditValue,
"@OTAfterStart2", tedOTAfterStart2.EditValue,
"@OTAfterStart3", tedOTAfterStart3.EditValue,
"@OTAfterStart4", tedOTAfterStart4.EditValue,
"@OTAfterStart5", tedOTAfterStart5.EditValue,
"@OTAfterStart6", tedOTAfterStart6.EditValue,
"@OTAfterStart7", tedOTAfterStart7.EditValue,
"@OTAfterEnd1", tedOTAfterEnd1.EditValue,
"@OTAfterEnd2", tedOTAfterEnd2.EditValue,
"@OTAfterEnd3", tedOTAfterEnd3.EditValue,
"@OTAfterEnd4", tedOTAfterEnd4.EditValue,
"@OTAfterEnd5", tedOTAfterEnd5.EditValue,
"@OTAfterEnd6", tedOTAfterEnd6.EditValue,
"@OTAfterEnd7", tedOTAfterEnd7.EditValue,
"@DayOff7", ckbDayoff7.EditValue,
CommonConst.A_LoginID, this.UserID);
DBEngine.commit();
}
catch (Exception ex)
{
DBEngine.rollback();
throw (ex);
}
m_dtShiftSetting.AcceptChanges();
// restore cursor
this.Cursor = Cursors.Default;
}
catch (Exception e)
{
// restore cursor
this.Cursor = Cursors.Default;
// show error
HPA.Common.Helper.ShowException(e, this.Name + ".Commit()", null);
// unable to commit
return(false);
}
UIMessage.ShowMessage(CommonConst.DATASAVED_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DirtyData = false;
// commit successfully
return(true);
}
public override bool Commit()
{
const int pCheck = 0;
try
{
// switch to COMMITING state
this.Cursor = Cursors.WaitCursor;
try
{
DBEngine.beginTransaction();
if (dtLoginInfor.GetChanges() != null && dtLoginInfor.GetChanges().Rows.Count > 0)
{
if (!dtLoginInfor.Rows[0]["Password", DataRowVersion.Original].ToString().Equals(txtPassword.Text))
{
DBEngine.exec("SC_LoginInfo_Save",
CommonConst.A_LoginID, UserID,
"@LoginName", txtLoginName.Text,
"@Password", Encryption.EncryptText(txtPassword.Text, true),
"@EmployeeID", txtEmployeeID.Text,
"@DepartmentID", txtDepartmentID.EditValue);
}
}
if (dtObjectList.GetChanges() != null && dtObjectList.GetChanges().Rows.Count > 0)
{
foreach (DataRow drObject in dtObjectList.GetChanges().Rows)
{
DBEngine.exec("SC_UserObjects_Save",
CommonConst.A_LoginID, UserID,
"@p_LoginID", dtLoginInfor.Rows[0][LoginID],
"@p_ObjectID", drObject[ObjectID_D],
"@p_FullAccess", drObject[Right_D]);
}
}
if (dtSectionList.GetChanges() != null && dtSectionList.GetChanges().Rows.Count > 0)
{
foreach (DataRow drSec in dtSectionList.GetChanges().Rows)
{
DBEngine.exec("SC_UserSectViewInfo_Save",
CommonConst.A_LoginID, UserID,
"@p_LoginID", dtLoginInfor.Rows[0][LoginID],
"@p_DepartmentID", drSec[DepartmentID],
"@p_SectionID", drSec[SectionID],
"@p_ViewInfo", drSec[ViewInfo]);
}
}
if (dtDepartmentList.GetChanges() != null && dtDepartmentList.GetChanges().Rows.Count > 0)
{
foreach (DataRow drDept in dtDepartmentList.GetChanges().Rows)
{
DBEngine.exec("SC_UserDeptViewInfo_Save",
CommonConst.A_LoginID, UserID,
"@p_LoginID", dtLoginInfor.Rows[0][LoginID],
"@p_DepartmentID", drDept[DepartmentID],
"@p_ViewInfo", drDept[ViewInfo]);
}
}
DBEngine.commit();
}
catch (Exception ex)
{
// dtEmployeeInformation.RejectChanges();
DBEngine.rollback();
throw (ex);
}
// restore cursor
this.Cursor = Cursors.Default;
}
catch (Exception e)
{
// restore cursor
this.Cursor = Cursors.Default;
// show error
HPA.Common.Helper.ShowException(e, this.Name + ".Commit()", null);
return(false);
}
if (pCheck == 0 || pCheck == 1)
{
UIMessage.ShowMessage(HPA.Common.CommonConst.DATASAVED_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
UIMessage.ShowMessage(HPA.Common.CommonConst.DELETE_SUCCESSFULLY, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.DirtyData = false;
LoadLoginInfo();
// commit successfully
return(true);
}
