public bool CT_TIMEKEEPER_TABLELIST_Lock()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.AddParameter("@IsLock", IsLock);
db.AddParameter("@IsFinish", IsFinish);
db.ExecuteNonQueryWithTransaction("CT_TIMEKEEPER_TABLELIST_Lock");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool CT_TIMEKEEPER_TABLE_COMMENT_Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@Day", Day);
db.ExecuteNonQueryWithTransaction("CT_TIMEKEEPER_TABLE_COMMENT_Delete");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Update()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
db.AddParameter("@Object_ID", Object_ID);
db.AddParameter("@Object_Name", Object_Name);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("CT_OBJECT_Update");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Update()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@EthnicCode", EthnicCode);
db.AddParameter("@EthnicName", EthnicName);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("CT_ETHNIC_Update");
db.CommitTransaction();
Class.S_Log.Insert("Dân Tộc", "Cập nhật Dân tộc: " + EthnicName);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Update()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ReligionCode", ReligionCode);
db.AddParameter("@ReligionName", ReligionName);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("CT_RELIGION_Update");
db.CommitTransaction();
Class.S_Log.Insert("Tôn giáo", "Cập nhật Tôn giáo: " + ReligionName);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Update(DataTable Data, int _DayNumber)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
for (int i = 0; i < Data.Rows.Count; i++)
{
//if (Data.Rows[i]["IsUpdate"].ToString() == "1") // tinh co cap nhat moi thay doi
//{
int _Up = 0;
for (int ii = _DayNumber; ii > 1; ii--)
{
string _day = "0";
if (Data.Rows[i]["D" + ii].ToString() == _day)
{
_Up = ii;
}
}
if (_Up > 0)
{
_Up--; // tra lai truoc 1 ngày de tranh tình trang ko cham ra ma chot luon ko cham ra
}
else
{
_Up = _DayNumber;
}
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", Data.Rows[i]["TimeKeeperTableListID"].ToString());
db.AddParameter("@EmployeeCode", Data.Rows[i]["EmployeeCode"].ToString());
db.AddParameter("@ShiftCode", Data.Rows[i]["ShiftCode"].ToString());
db.AddParameter("@D1", Data.Rows[i]["D1"].ToString());
db.AddParameter("@D2", Data.Rows[i]["D2"].ToString());
db.AddParameter("@D3", Data.Rows[i]["D3"].ToString());
db.AddParameter("@D4", Data.Rows[i]["D4"].ToString());
db.AddParameter("@D5", Data.Rows[i]["D5"].ToString());
db.AddParameter("@D6", Data.Rows[i]["D6"].ToString());
db.AddParameter("@D7", Data.Rows[i]["D7"].ToString());
db.AddParameter("@D8", Data.Rows[i]["D8"].ToString());
db.AddParameter("@D9", Data.Rows[i]["D9"].ToString());
db.AddParameter("@D10", Data.Rows[i]["D10"].ToString());
db.AddParameter("@D11", Data.Rows[i]["D11"].ToString());
db.AddParameter("@D12", Data.Rows[i]["D12"].ToString());
db.AddParameter("@D13", Data.Rows[i]["D13"].ToString());
db.AddParameter("@D14", Data.Rows[i]["D14"].ToString());
db.AddParameter("@D15", Data.Rows[i]["D15"].ToString());
db.AddParameter("@D16", Data.Rows[i]["D16"].ToString());
db.AddParameter("@D17", Data.Rows[i]["D17"].ToString());
db.AddParameter("@D18", Data.Rows[i]["D18"].ToString());
db.AddParameter("@D19", Data.Rows[i]["D19"].ToString());
db.AddParameter("@D20", Data.Rows[i]["D20"].ToString());
db.AddParameter("@D21", Data.Rows[i]["D21"].ToString());
db.AddParameter("@D22", Data.Rows[i]["D22"].ToString());
db.AddParameter("@D23", Data.Rows[i]["D23"].ToString());
db.AddParameter("@D24", Data.Rows[i]["D24"].ToString());
db.AddParameter("@D25", Data.Rows[i]["D25"].ToString());
db.AddParameter("@D26", Data.Rows[i]["D26"].ToString());
db.AddParameter("@D27", Data.Rows[i]["D27"].ToString());
db.AddParameter("@D28", Data.Rows[i]["D28"].ToString());
db.AddParameter("@D29", Data.Rows[i]["D29"].ToString());
db.AddParameter("@D30", Data.Rows[i]["D30"].ToString());
db.AddParameter("@D31", Data.Rows[i]["D31"].ToString());
db.AddParameter("@UpdateDay", _Up);
db.ExecuteNonQueryWithTransaction("CT_TIMEKEEPER_TABLE_Update");
//db.CreateNewSqlCommand();
//db.AddParameter("@UserName", S_Log.UserName);
//db.AddParameter("@Created", DateTime.Now);
//db.AddParameter("@Module", "Chấm công");
//db.AddParameter("@IPLan", S_Log.IPLan);
//db.AddParameter("@PCName", S_Log.PCName);
//db.AddParameter("@Description", S_Log.Description + Data.Rows[i]["FirstName"].ToString() + " " + Data.Rows[i]["LastName"].ToString());
//db.AddParameter("@Active", true);
//db.ExecuteNonQueryWithTransaction("CT_LOG_Insert");
//}
}
db.CommitTransaction();
//Class.S_Log.Insert("Chấm công", " Cập nhật Bảng Chấm công tháng ");
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}