public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@RewardID", RewardID);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@Foundation", Foundation);
db.AddParameter("@Reason", Reason);
db.AddParameter("@Form", Form);
db.AddParameter("@Date", Date);
db.AddParameter("@DecideNumber", DecideNumber);
db.AddParameter("@Person", Person);
db.ExecuteNonQueryWithTransaction("CT_PROCESS_REWARD_Insert");
db.CommitTransaction();
Class.S_Log.Insert("Quá trình làm việc", "Thêm thông tin khen thưởng Nhân viên: " + Class.App._hotennv);
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("@DepartmentCode", DepartmentCode);
db.AddParameter("@BranchCode", BranchCode);
db.AddParameter("@DepartmentName", DepartmentName);
db.AddParameter("@Phone", Phone);
db.AddParameter("@Quantity", Quantity);
db.AddParameter("@FactQuantity", FactQuantity);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("CT_DEPARTMENT_Update");
db.CommitTransaction();
Class.S_Log.Insert("Phòng ban", "Cập nhật Phòng ban: " + DepartmentName);
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("@HospitalCode", HospitalCode);
db.AddParameter("@ProvinceCode", ProvinceCode);
db.AddParameter("@HospitalName", HospitalName);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("CT_HOSPITAL_Update");
Class.S_Log.Insert("Bệnh viện", "Cập nhật bệnh viện: " + HospitalName);
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@SymbolCode", SymbolCode);
db.AddParameter("@SymbolName", SymbolName);
db.AddParameter("@PercentSalary", PercentSalary);
db.AddParameter("@IsEdit", IsEdit);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("CT_SYMBOL_Insert");
db.CommitTransaction();
Class.S_Log.Insert("Ký hiệu chấm công", "Thêm Ký hiệu chấm công: " + SymbolName);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ShiftCode", ShiftCode);
db.AddParameter("@ShiftName", ShiftName);
db.AddParameter("@BeginTime", BeginTime);
db.AddParameter("@EndTime", EndTime);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("CT_SHIFT_Insert");
db.CommitTransaction();
Class.S_Log.Insert("Ca làm việc", "Ca làm việc: " + ShiftName);
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("@BranchCode", BranchCode);
db.AddParameter("@BranchName", BranchName);
db.AddParameter("@Address", Address);
db.AddParameter("@Phone", Phone);
db.AddParameter("@Fax", Fax);
db.AddParameter("@MinimumSalary", MinimumSalary);
db.AddParameter("@PersonName", PersonName);
db.AddParameter("@Quantity", Quantity);
db.AddParameter("@FactQuantity", FactQuantity);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("CT_BRANCH_Update");
db.CommitTransaction();
Class.S_Log.Insert("Chi nhánh", "Cập nhật Chi nhánh: " + BranchName);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
IsLock = false;
IsFinish = false;
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.AddParameter("@TimeKeeperTableListName", TimeKeeperTableListName);
db.AddParameter("@Month", Month);
db.AddParameter("@Year", Year);
db.AddParameter("@IsLock", IsLock);
db.AddParameter("@IsFinish", IsFinish);
db.ExecuteNonQueryWithTransaction("CT_TIMEKEEPER_TABLELIST_Insert");
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.ExecuteNonQueryWithTransaction("CT_TIMEKEEPER_SHIFT_Create");
db.CommitTransaction();
// Class.S_Log.Insert("Chức vụ", "Thêm Chức vụ " + PositionName);
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("@PositionCode", PositionCode);
db.AddParameter("@PositionName", PositionName);
db.AddParameter("@IsManager", IsManager);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("CT_POSITION_Update");
db.CommitTransaction();
Class.S_Log.Insert("Chức vụ", "Cập nhật Chức vụ " + PositionName);
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("@TrainingID", TrainingID);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@TrainingName", TrainingName);
db.AddParameter("@Reason", Reason);
db.AddParameter("@Form", Form);
db.AddParameter("@Time", Time);
db.AddParameter("@BeginDate", BeginDate);
db.AddParameter("@Date", Date);
db.AddParameter("@DecideNumber", DecideNumber);
db.AddParameter("@Person", Person);
db.AddParameter("@FilePath", "");
db.ExecuteNonQueryWithTransaction("CT_PROCESS_TRAINING_Update");
db.CommitTransaction();
Class.S_Log.Insert("Quá trình làm việc", "Cập nhật thông tin đào tao: " + TrainingName + " - Nhân viên: " + Class.App._hotennv);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@CompanyID", CompanyID);
db.AddParameter("@CompanyName", CompanyName);
db.AddParameter("@CompanyAddress", CompanyAddress);
db.AddParameter("@CompanyTax", CompanyTax);
db.AddParameter("@Tel", Tel);
db.AddParameter("@Fax", Fax);
db.AddParameter("@WebSite", WebSite);
db.AddParameter("@Email", Email);
db.AddParameter("@Logo", Logo);
db.ExecuteNonQueryWithTransaction("COMPANY_Insert");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete_Permission(DataTable dt)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((bool)dt.Rows[i]["selectvalue"] == true)
{
db.CreateNewSqlCommand();
db.AddParameter("@UserName", UserName);
db.AddParameter("@Object_ID", dt.Rows[i]["Object_ID"].ToString());
db.ExecuteNonQueryWithTransaction("CT_USER_RULE_Delete");
}
}
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public static bool Insert(string _module, string _des)
{
Module = _module;
Description = _des;
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@UserName", UserName);
db.AddParameter("@Created", DateTime.Now);
db.AddParameter("@Module", Module);
db.AddParameter("@IPLan", IPLan);
db.AddParameter("@PCName", PCName);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", true);
db.ExecuteNonQueryWithTransaction("CT_LOG_Insert");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ProfessionalCode", ProfessionalCode);
db.AddParameter("@ProfessionalName", ProfessionalName);
db.AddParameter("@Description", Description);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("CT_PROFESSIONAL_Insert");
db.CommitTransaction();
Class.S_Log.Insert("Chuyên môn", "Thêm chuyên môn: " + ProfessionalName);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@PersonID", PersonID);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@PersonName", PersonName);
db.AddParameter("@Relative", Relative);
db.AddParameter("@Address", Address);
db.AddParameter("@Email", Email);
db.AddParameter("@Phone", Phone);
db.AddParameter("@IsDepend", IsDepend);
db.ExecuteNonQueryWithTransaction("HRM_EMPLOYEE_RELATIVE_Insert");
db.CommitTransaction();
Class.S_Log.Insert("Liên hệ", "Thêm liên hệ: " + PersonName);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MachineCode", MachineCode);
db.AddParameter("@MachineName", MachineName);
db.AddParameter("@PortType", PortType);
db.AddParameter("@PortID", PortID);
db.AddParameter("@IP", IP);
db.AddParameter("@Password", Password);
db.AddParameter("@Com", Com);
db.ExecuteNonQueryWithTransaction("CT_MACHINE_Insert");
db.CommitTransaction();
Class.S_Log.Insert("Thiết bị chấm công", "Thêm Thiết bị chấm công: " + MachineName);
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("@GroupCode", GroupCode);
db.AddParameter("@DepartmentCode", DepartmentCode);
db.AddParameter("@GroupName", GroupName);
db.AddParameter("@Quantity", Quantity);
db.AddParameter("@FactQuantity", FactQuantity);
db.AddParameter("@Description", Description);
db.ExecuteNonQueryWithTransaction("HRM_GROUP_Update");
db.CommitTransaction();
Class.S_Log.Insert("Tổ nhóm", "Cập nhật Tổ nhóm: " + GroupName);
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
{
// thu hien neu la hd hien tai
if (IsCurrent)
{
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
db.ExecuteNonQueryWithTransaction("HRM_CONTRACT_SEASON_Update_notIsCurrent");
}
//
db.CreateNewSqlCommand();
db.AddParameter("@ContractCode", ContractCode);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@ContractTime", ContractTime);
db.AddParameter("@ContractYear", ContractYear);
db.AddParameter("@SignDate", SignDate);
db.AddParameter("@FromDate", FromDate);
db.AddParameter("@ToDate", ToDate);
db.AddParameter("@BasicSalary", BasicSalary);
db.AddParameter("@PayForm", PayForm);
db.AddParameter("@PayDate", PayDate);
db.AddParameter("@Allowance", Allowance);
db.AddParameter("@Insurance", Insurance);
db.AddParameter("@WorkTime", WorkTime);
db.AddParameter("@Signer", Signer);
db.AddParameter("@SignerPosition", SignerPosition);
db.AddParameter("@SignerNationality", SignerNationality);
db.AddParameter("@Company", Company);
db.AddParameter("@Address", Address);
db.AddParameter("@Tel", Tel);
db.AddParameter("@Description", Description);
db.AddParameter("@IsCurrent", IsCurrent);
db.ExecuteNonQueryWithTransaction("HRM_CONTRACT_SEASON_Update");
db.CommitTransaction();
Class.S_Log.Insert("Hợp Đồng", "Cập nhật Hợp đồng thời vụ: " + ContractCode + " - Mã Nhân viên: " + EmployeeCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Insert(DataTable Data)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
for (int i = 0; i < Data.Rows.Count; i++)
{
InOutCode = Data.Rows[i]["InOutCode"].ToString();
MachineNumber = Data.Rows[i]["MachineNumber"].ToString();
EnrollNumber = Data.Rows[i]["EnrollNumber"].ToString();
VerifyMode = Data.Rows[i]["VerifyMode"].ToString();
InOutMode = Data.Rows[i]["InOutMode"].ToString();
Year = Data.Rows[i]["Year"].ToString();
Month = Data.Rows[i]["Month"].ToString();
Day = Data.Rows[i]["Day"].ToString();
Hour = Data.Rows[i]["Hour"].ToString();
Minute = Data.Rows[i]["Minute"].ToString();
Second = Data.Rows[i]["Second"].ToString();
TimeStr = (DateTime)Data.Rows[i]["TimeStr"];
db.CreateNewSqlCommand();
db.AddParameter("@InOutCode", InOutCode);
db.AddParameter("@MachineNumber", MachineNumber);
db.AddParameter("@EnrollNumber", EnrollNumber);
db.AddParameter("@VerifyMode", VerifyMode);
db.AddParameter("@InOutMode", InOutMode);
db.AddParameter("@Year", Year);
db.AddParameter("@Month", Month);
db.AddParameter("@Day", Day);
db.AddParameter("@Hour", Hour);
db.AddParameter("@Minute", Minute);
db.AddParameter("@Second", Second);
db.AddParameter("@TimeStr", TimeStr);
db.ExecuteNonQueryWithTransaction("CHECKINOUT_Insert");
}
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("@PositionID", PositionID);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@OldBranch", OldBranch);
db.AddParameter("@OldDepartment", OldDepartment);
db.AddParameter("@OldGroup", OldGroup);
db.AddParameter("@OldPosition", OldPosition);
db.AddParameter("@NewBranch", NewBranch);
db.AddParameter("@NewDepartment", NewDepartment);
db.AddParameter("@NewGroup", NewGroup);
db.AddParameter("@NewPosition", NewPosition);
db.AddParameter("@Date", Date);
db.AddParameter("@Reason", Reason);
db.AddParameter("@DecideNumber", DecideNumber);
db.AddParameter("@Person", Person);
db.ExecuteNonQueryWithTransaction("CT_PROCESS_POSITION_Update");
// db.CreateNewSqlCommand();
// db.AddParameter("@EmployeeCode", EmployeeCode);
// db.AddParameter("@BranchCode", NewBranch);
// db.AddParameter("@DepartmentCode", NewDepartment);
// db.AddParameter("@GroupCode", NewGroup);
// db.AddParameter("@Position", NewPosition);
//db.ExecuteNonQueryWithTransaction("CT_EMPLOYEE_UpdatePosition");
// db.CreateNewSqlCommand();
// db.ExecuteNonQueryWithTransaction("CT_EMPLOYEE_Count");
db.CommitTransaction();
Class.S_Log.Insert("Quá trình làm việc", "Cập nhật thông tin Chứa vụ, phòng ban Nhân viên: " + Class.App._hotennv);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public static bool ClearAll_Log_HeThong()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.ExecuteNonQueryWithTransaction("CT_LOG_DeleteAll");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
db.ExecuteNonQueryWithTransaction("HRM_EMPLOYEE_ALLOWANCE_Delete");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@UserName", UserName);
db.ExecuteNonQueryWithTransaction("CT_USER_Delete");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool CT_TIMEKEEPER_SHIFT_UpdateNewEmployee()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.ExecuteNonQueryWithTransaction("CT_TIMEKEEPER_SHIFT_UpdateNewEmployee");
db.CommitTransaction();
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@ContractCode", ContractCode);
db.ExecuteNonQueryWithTransaction("HRM_CONTRACT_SEASON_Delete");
db.CommitTransaction();
Class.S_Log.Insert("Hợp Đồng", "Xóa Hợp đồng thời vụ: " + ContractCode + " - Mã Nhân viên: " + EmployeeCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@DegreeCode", DegreeCode);
db.ExecuteNonQueryWithTransaction("CT_DEGREE_Delete");
db.CommitTransaction();
Class.S_Log.Insert("Bằng Cấp", "Xóa bằng cấp: " + DegreeCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@BranchCode", BranchCode);
db.ExecuteNonQueryWithTransaction("CT_BRANCH_Delete");
db.CommitTransaction();
Class.S_Log.Insert("Chi nhánh", "Xóa Chi nhánh: " + BranchCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@DisciplineID", DisciplineID);
db.ExecuteNonQueryWithTransaction("CT_PROCESS_DISCIPLINE_Delete");
db.CommitTransaction();
Class.S_Log.Insert("Quá trình làm việc", "Xóa thông tin kỷ luật Nhân viên: " + Class.App._hotennv);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@GroupCode", GroupCode);
db.ExecuteNonQueryWithTransaction("HRM_GROUP_Delete");
db.CommitTransaction();
Class.S_Log.Insert("Tổ nhóm", "Xóa Tổ nhóm: " + GroupCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
db.ExecuteNonQueryWithTransaction("CT_EMPLOYEE_DEACTIVE_Delete");
db.CommitTransaction();
// Class.S_Log.Insert("Ngoại ngữ", "Xóa Ngoại ngữ: " + LanguageCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@NationalityCode", NationalityCode);
db.ExecuteNonQueryWithTransaction("CT_NATIONALITY_Delete");
db.CommitTransaction();
Class.S_Log.Insert("Quốc tịch", "Xóa Quốc tịch: " + NationalityCode);
return(true);
}
catch (Exception ex)
{
db.RollbackTransaction();
Class.App.Log_Write(ex.Message);
return(false);
}
}
