//CREATE EVENT public static string CreateEvent(EventViewModel paramDataEvent) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { t_event c = new t_event(); c.code = EventCode(); c.event_name = paramDataEvent.eventName; c.place = paramDataEvent.place; c.start_date = paramDataEvent.startDate; c.end_date = paramDataEvent.endDate; c.budget = paramDataEvent.budget; c.status = paramDataEvent.status; c.is_delete = paramDataEvent.isDelete; c.request_by = paramDataEvent.requestBy; c.request_date = paramDataEvent.requestDate; c.note = paramDataEvent.note; c.create_by = paramDataEvent.createBy; c.create_date = paramDataEvent.createDate; db.t_event.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.code; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); } } } return(latestSaveCode); }
//public static List<EmployeeViewModel> GetListEmployee(EmployeeViewModel paramSearch) //{ // List<EmployeeViewModel> result = new List<EmployeeViewModel>(); // using (var context = new MarkomApplicationDBEntities()) // { // var res = context.spEmployeeSearch(paramSearch.code, paramSearch.fullName,paramSearch.mCompanyId, paramSearch.createDate2, paramSearch.createBy); // List<EmployeeViewModel> comList = res.Select(c => new EmployeeViewModel // { // id = c.id, // code = c.employee_number, // firstName = c.first_name, // lastName = c.last_name, // mCompanyId = c.m_company_id, // companyName = c.name, // createDate = c.create_date, // createBy = c.create_by // }).ToList(); // result = comList; // } // return result; //} //CREATE EMPLOYEE public static string CreateEmployee(EmployeeViewModel paramDataEmployee) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { m_employee c = new m_employee(); c.employee_number = paramDataEmployee.code; c.first_name = paramDataEmployee.firstName; c.last_name = paramDataEmployee.lastName; c.m_company_id = paramDataEmployee.mCompanyId; c.email = paramDataEmployee.email; c.is_delete = paramDataEmployee.isDelete; c.create_by = paramDataEmployee.createBy; c.create_date = paramDataEmployee.createDate; db.m_employee.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.employee_number; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); //throw; } } } return(latestSaveCode); }
public static string CreateCompany(CompanyViewModel paramDataCompany) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { m_company c = new m_company(); c.code = CompanyCode(); c.name = paramDataCompany.name; c.address = paramDataCompany.address; c.phone = paramDataCompany.phone; c.email = paramDataCompany.email; c.is_delete = paramDataCompany.isDelete; c.create_by = paramDataCompany.createBy; c.create_date = paramDataCompany.createDate; db.m_company.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.code; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); //throw; } } } return(latestSaveCode); }
public static string CreateMenu(MenuViewModel paramDataMenu) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { m_menu c = new m_menu(); c.code = MenuCode(); c.name = paramDataMenu.name; c.controller = paramDataMenu.controller; c.parent_id = paramDataMenu.parentId; c.is_delete = paramDataMenu.isDelete; c.create_by = paramDataMenu.createBy; c.create_date = paramDataMenu.createDate; db.m_menu.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.code; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); //throw; } } } return(latestSaveCode); }
public static string CreateSouvenir(SouvenirViewModel paramDataSou) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { m_souvenir c = new m_souvenir(); c.code = SouvenirCode(); c.name = paramDataSou.name; c.m_unit_id = paramDataSou.mUnitId; c.description = paramDataSou.description; c.is_delete = paramDataSou.isDelete; c.create_by = paramDataSou.createBy; c.create_date = paramDataSou.createDate; db.m_souvenir.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.code; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); //throw; } } } return(latestSaveCode); }
public static string CreateProduct(ProductViewModel paramDataProd) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { m_product c = new m_product(); c.code = ProductCode(); c.name = paramDataProd.name; c.description = paramDataProd.description; c.is_delete = paramDataProd.isDelete; c.create_by = paramDataProd.createBy; c.create_date = paramDataProd.createDate; db.m_product.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.code; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); //throw; } } } return(latestSaveCode); }