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 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("@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("@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 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 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 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 DataTable CT_EMPLOYEE_GetRate()
{
string procname = "CT_EMPLOYEE_GetRate";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@FromYear", 2005);
db.AddParameter("@ToYear", DateTime.Now.Year);
return(db.ExecuteDataTable(procname));
}
public DataTable CT_TIMEKEEPER_TABLELIST_Get()
{
string procname = "CT_TIMEKEEPER_TABLELIST_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Month", Month);
db.AddParameter("@Year", Year);
return(db.ExecuteDataTable(procname));
}
public DataTable GetAllowanceByCode()
{
string procname = "HRM_EMPLOYEE_ALLOWANCE_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@AllowanceCode", AllowanceCode);
return(db.ExecuteDataTable(procname));
}
public DataTable CHECKINOUT_GetByDate()
{
string procname = "CHECKINOUT_GetByDate";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@FromDay", FromDay);
db.AddParameter("@ToDay", ToDay);
return(db.ExecuteDataTable(procname));
}
public DataTable CT_TIMEKEEPER_TABLE_GetListByGroup()
{
string procname = "CT_TIMEKEEPER_TABLE_GetListByGroup";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.AddParameter("@GroupCode", GroupCode);
return(db.ExecuteDataTable(procname));
}
public DataTable CheckLogin()
{
string procname = "CT_USER_Get_Login";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@UserName", UserName);
db.AddParameter("@Password", Password);
return(db.ExecuteDataTable(procname));
}
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 DataTable CT_TIMEKEEPER_TABLE_COMMENT_Get()
{
string procname = "CT_TIMEKEEPER_TABLE_COMMENT_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.AddParameter("@EmployeeCode", EmployeeCode);
db.AddParameter("@Day", Day);
DataTable dt = db.ExecuteDataTable(procname);
return(dt);
}
public DataTable CT_TIMEKEEPER_SHIFT_GetListByGroup()
{
string procname = "CT_TIMEKEEPER_SHIFT_GetListByGroup";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
db.AddParameter("@GroupCode", GroupCode);
DataTable dt = db.ExecuteDataTable(procname);
dt.Columns.Add("IsUpdate");
return(dt);
}
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("@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 DataTable CT_TIMEKEEPER_TABLE_GetList()
{
string procname = "CT_TIMEKEEPER_TABLE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
DataTable dt = db.ExecuteDataTable(procname);
// tinh tong phep theo thang
dt.Columns.Add("PN", typeof(float));
dt.Columns.Add("HL", typeof(float));
dt.Columns.Add("BH", typeof(float));
dt.Columns.Add("KL", typeof(float));
dt.Columns.Add("KP", typeof(float));
dt.Columns.Add("LD", typeof(float));
dt.Columns.Add("NB", typeof(float));
dt.Columns.Add("OFF", typeof(float));
dt.Columns.Add("PB", typeof(float));
dt.Columns.Add("TD", typeof(float));
dt.Columns.Add("NC", typeof(float));
dt.Columns.Add("IsUpdate");
dt.Columns.Add("PrintAllow", typeof(bool));
return(dt);
}
public DataTable CT_EMPLOYEE_GetListBirthdayByMonth(int _Month)
{
string procname = "CT_EMPLOYEE_GetListBirthdayByMonth";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Month", _Month);
DataTable dt = db.ExecuteDataTable(procname);
dt.Columns.Add("Day", Type.GetType("System.String"));
for (int i = 0; i < dt.Rows.Count; i++)
{
string txt = ((DateTime)dt.Rows[i]["BirthDay"]).Day.ToString();
if (txt.Length == 1)
{
txt = "0" + txt;
}
dt.Rows[i]["Day"] = txt;
}
DataView dv = dt.DefaultView;
dv.Sort = "Day ASC";
dt = dv.ToTable();
return(dt);
}
public static string GetProvinceSearch(string strCode)
{
string procname = "CT_PROVINCE_Search";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@ProvinceCode", "");
db.AddParameter("@ProvinceName", strCode);
db.AddParameter("@Description", "");
DataTable dt = db.ExecuteDataTable(procname);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["ProvinceCode"].ToString());
}
return("");
}
public DataTable CT_TIMEKEEPER_SYNTHESIS_GetList(string Thang)
{
string procname = "CT_TIMEKEEPER_SYNTHESIS_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", Thang);
DataTable dt = db.ExecuteDataTable(procname);
// bảo trì không chấm ra -----/// ---- khai thac dich vu
#region bao tri ko cham cong
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// if (dt.Rows[i]["Position"].ToString().ToLower().Contains("bảo trì") || dt.Rows[i]["Position"].ToString().ToLower().Contains("quản lý chung cư"))
// {
// // loai nhung nhan vien van tinh ra trong phong do
// if (dt.Rows[i]["EmployeeCode"].ToString().Contains("LBC0699")) // nhan vien bang trong khai thac dich vu
// {
// }
// else
// {
// for (int j = 0; j < dt.Columns.Count; j++)
// {
// if (dt.Columns[j].ColumnName.StartsWith("D") && dt.Columns[j].ColumnName.Length < 4)
// {
// if (dt.Rows[i][j].ToString().Equals("KR"))
// {
// dt.Rows[i][j] = "1";
// }
// if (dt.Rows[i][j].ToString().StartsWith("S"))
// {
// dt.Rows[i][j] = "1"; // chi co som ko, thi van tinh 1 ca du vi chi cham vao
// }
// if (dt.Rows[i][j].ToString().EndsWith("-KR"))
// {
// dt.Rows[i][j] = dt.Rows[i][j].ToString().Replace("-KR", ""); // bo ko ra o phia sau
// }
// }
// }
// }
// }
//}
#endregion
dt.Columns.Add("Total15");
dt.Columns.Add("TotalNgay15");
dt.Columns.Add("TotalTren15");
dt.Columns.Add("TotalNgayTren15");
return(dt);
}
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
{
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 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("@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 DataTable CT_EMPLOYEE_DEACTIVE_GetByEmployeeCode()
{
string procname = "CT_EMPLOYEE_DEACTIVE_GetByEmployeeCode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
return(db.ExecuteDataTable(procname));
}
public DataTable CT_EMPLOYEE_DEACTIVE_GetByYear()
{
string procname = "CT_EMPLOYEE_DEACTIVE_GetByYear";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Year", Year);
return(db.ExecuteDataTable(procname));
}
public DataTable GetBranchByCode(string strCode)
{
string procname = "CT_BRANCH_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@BranchCode", strCode);
return(db.ExecuteDataTable(procname));
}
public DataTable HRM_CONTRACT_SEASON_GetByEmployee()
{
string procname = "HRM_CONTRACT_SEASON_GetByEmployee";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
return(db.ExecuteDataTable(procname));
}
