/// <summary> /// 编辑按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gv1_RowUpdating(object sender, GridViewUpdateEventArgs e) { sqlconn = SQLHelper.Connect(); /*try * {*/ //暂时禁用外键关系 SqlCommand sqlCmdNoCheck = new SqlCommand("alter table Department NOCHECK constraint all", sqlconn); SqlCommand sqlCmd2NoCheck = new SqlCommand("alter table Employee NOCHECK constraint all", sqlconn); sqlCmdNoCheck.ExecuteNonQuery(); sqlCmd2NoCheck.ExecuteNonQuery(); //实例化上下文对象 using (EMSEntities context = new EMSEntities()) { //先删除后新增 int DptId = int.Parse(gv1.DataKeys[e.RowIndex].Values[0].ToString()); Department eqp = context.Department.Where <Department>(dpt => dpt.DptId == DptId).FirstOrDefault <Department>(); //告诉上下文要删除 context.Entry <Department>(eqp).State = System.Data.Entity.EntityState.Deleted; //执行删除操作 context.SaveChanges(); Department depart = new Department { DptId = int.Parse((gv1.Rows[e.RowIndex].FindControl("txtId") as TextBox).Text.Trim()), DptName = (gv1.Rows[e.RowIndex].FindControl("txtEqpName") as TextBox).Text.Trim(), DptAdmin = int.Parse((gv1.Rows[e.RowIndex].FindControl("txtDptAdmin") as TextBox).Text.Trim()) }; //告诉上下文要进行添加操作 context.Entry <Department>(depart).State = System.Data.Entity.EntityState.Added; //执行添加操作 context.SaveChanges(); } //恢复外键关系 SqlCommand sqlComdCheck = new SqlCommand("alter table Department CHECK constraint all", sqlconn); sqlComdCheck.ExecuteNonQuery(); SqlCommand sqlComd2Check = new SqlCommand("alter table Employee CHECK constraint all", sqlconn); sqlComd2Check.ExecuteNonQuery(); gv1.EditIndex = -1; PopulateGridView(); lblSuccessMessage.Text = "修改成功!"; lblErrorMessage.Text = ""; /*} * catch (Exception ex) * { * lblSuccessMessage.Text = ""; * lblErrorMessage.Text = ex.Message; * SQLHelper.Close(sqlconn); * } * SQLHelper.Close(sqlconn);*/ }
//insert method public void saveProjectProgressDB(project_progress progress) { try { db.project_progress.Add(progress); db.SaveChanges(); } catch (Exception) { throw; } }
//insert public int saveProgressDB(emp_progresses progress) { try { db.emp_progresses.Add(progress); return(db.SaveChanges()); } catch (Exception) { throw; } }
//insert public void saveProjectDB(project project) { try { db.projects.Add(project); db.SaveChanges(); } catch (Exception) { throw; } }
protected void Button1_Click(object sender, EventArgs e) { sqlconn = SQLHelper.Connect(); try { //暂时禁用外键关系 SqlCommand sqlCmdNoCheck = new SqlCommand("alter table Department NOCHECK constraint all", sqlconn); SqlCommand sqlCmd2NoCheck = new SqlCommand("alter table Employee NOCHECK constraint all", sqlconn); sqlCmdNoCheck.ExecuteNonQuery(); sqlCmd2NoCheck.ExecuteNonQuery(); //实例化上下文对象 using (EMSEntities context = new EMSEntities()) { //先删除后新增 int EmpId = int.Parse(TextBox1.Text.ToString()); Employee emp = context.Employee.Where <Employee>(empl => empl.EmpId == EmpId).FirstOrDefault <Employee>(); //告诉上下文要删除 context.Entry <Employee>(emp).State = System.Data.Entity.EntityState.Deleted; //执行删除操作 context.SaveChanges(); Employee empEdit = new Employee { EmpId = int.Parse(TextBox1.Text.Trim()), EmpName = TextBox2.Text.Trim(), Password = TextBox3.Text.Trim(), EmpPhone = TextBox4.Text.Trim(), DptId = int.Parse(TextBox6.Text.Trim()), IsAdmin = int.Parse(TextBox7.Text.Trim()) }; //告诉上下文要进行添加操作 context.Entry <Employee>(empEdit).State = System.Data.Entity.EntityState.Added; //执行添加操作 context.SaveChanges(); } //恢复外键关系 SqlCommand sqlComdCheck = new SqlCommand("alter table Department CHECK constraint all", sqlconn); SqlCommand sqlComd2Check = new SqlCommand("alter table Employee CHECK constraint all", sqlconn); sqlComdCheck.ExecuteNonQuery(); sqlComd2Check.ExecuteNonQuery(); Label1.Visible = true; Label1.Text = "修改成功!"; } catch (Exception ex) { Label1.Visible = true; Label1.Text = ex.Message; SQLHelper.Close(sqlconn); } SQLHelper.Close(sqlconn); }
public void addEvent(Event e) { this.e = e; try { entities.Events.Add(e); entities.SaveChanges(); } catch (Exception) { MessageBox.Show("Something went horribly wrong."); } }
public void addActivity(Activity t) { this.t = t; try { entities.Activities.Add(t); entities.SaveChanges(); } catch (Exception) { MessageBox.Show("Something went horribly wrong."); } }
public void UpdateMEnterprise(MEnterprise _enterprise) { EMSEntities entity = new EMSEntities(); if (_enterprise.MEnterpriseID == 0) { entity.MEnterprise.Add(_enterprise); } else { MEnterprise ishave = entity.MEnterprise.Where(m => m.MEnterpriseID == _enterprise.MEnterpriseID).First(); if (ishave != null) { //string brief = ishave.MEnterpriseBrief; ishave.MEnterpriseAddress = _enterprise.MEnterpriseAddress; ishave.MEnterpriseName = _enterprise.MEnterpriseName; ishave.MEnterpriseRight = _enterprise.MEnterpriseRight; ishave.MEnterpriseTelphoneNumber = _enterprise.MEnterpriseTelphoneNumber; ishave.MEnterpriseLogo = _enterprise.MEnterpriseLogo; ishave.MEnterpriseEmail = _enterprise.MEnterpriseEmail; ishave.MEnterpriseBriefShort = _enterprise.MEnterpriseBriefShort; //ishave.MEnterpriseBrief = brief; } } entity.SaveChanges(); }
public static void EditEmployeeProjectRoleAssignmnet(Project_role Project_role) { EMSEntities datacontext = new EMSEntities(); try { if (Project_role != null) { int empl_status = EmployeeRepo.GetEmployeeStatusById(Project_role.employee_id); ProjectModel proj = ProjectRepo.GetProjectDetailsById(Project_role.project_id); int actual_resource_count = proj.resources_req; List <Project_role_model> assigned_resource = ProjectRepo.GetAssignedProjectRoleList(0, proj.project_id, 0); if ((empl_status == 1) && (proj != null) && (assigned_resource.Count <= actual_resource_count)) { datacontext.Entry(Project_role).State = EntityState.Modified; datacontext.SaveChanges(); } else { throw new Exception("Check Project details , employee status and resource allocation count "); } } } catch (Exception exception) { Debug.WriteLine(exception.Message); Debug.WriteLine(exception.GetBaseException()); throw exception; } finally { datacontext.Dispose(); } }
public static void InsertLeaveBalance(Employee employee, int[] arr)//arr constant array - contains manager , HR and TeamLead ID { EMSEntities datacontext = new EMSEntities(); try { for (int i = 0; i < arr.Length; i++) { Leavebalance_sheet leave_balance = new Leavebalance_sheet(); leave_balance.employee_id = employee.id; leave_balance.leavetype_id = arr[i]; leave_balance.no_of_days = (decimal)Utils.LeaveCalculationBasedDOJ(employee.date_of_joining, arr[i]); leave_balance.actual_balance = leave_balance.no_of_days; datacontext.Leavebalance_sheet.Add(leave_balance); } datacontext.SaveChanges(); } catch (Exception exception) { Debug.WriteLine(exception.Message); Debug.WriteLine(exception.GetBaseException()); throw exception; } finally { datacontext.Dispose(); } }
/// <summary> /// 删除按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gv1_RowDeleting(object sender, GridViewDeleteEventArgs e) { sqlconn = SQLHelper.Connect(); try { //暂时禁用外键关系 SqlCommand sqlCmdNoCheck = new SqlCommand("alter table Equipment NOCHECK constraint all", sqlconn); sqlCmdNoCheck.ExecuteNonQuery(); using (EMSEntities context = new EMSEntities()) { //找到要删除的id int EqpId = int.Parse(gv1.DataKeys[e.RowIndex].Values[0].ToString()); Equipment eqp = context.Equipment.Where <Equipment>(equip => equip.EqpId == EqpId).FirstOrDefault <Equipment>(); //告诉上下文要删除 context.Entry <Equipment>(eqp).State = System.Data.Entity.EntityState.Deleted; //执行删除操作 context.SaveChanges(); } //恢复外键关系 SqlCommand sqlComdCheck = new SqlCommand("alter table Equipment CHECK constraint all", sqlconn); sqlComdCheck.ExecuteNonQuery(); PopulateGridView(); lblSuccessMessage.Text = "删除成功!"; lblErrorMessage.Text = ""; } catch (Exception ex) { lblSuccessMessage.Text = ""; lblErrorMessage.Text = ex.Message; SQLHelper.Close(sqlconn); } SQLHelper.Close(sqlconn); }
public static void InactiveEmployee(Employee existinginstance) { EMSEntities datacontext = new EMSEntities(); try { //var query = from employee in datacontext.Employees // join user in datacontext.Users // on employee.user_id equals user.id // where employee.id == e_id && user.is_active ==1 // select user; var query = from user in datacontext.Users where existinginstance.user_id == user.id && user.is_active == 1 select user; User user_details = query.FirstOrDefault(); user_details.is_active = 0; datacontext.Entry(user_details).State = EntityState.Modified; datacontext.SaveChanges(); //datacontext.Entry(query.FirstOrDefault()).State = EntityState.Deleted; //datacontext.SaveChanges(); } catch (Exception exception) { Debug.WriteLine(exception.Message); Debug.WriteLine(exception.GetBaseException()); throw exception; } finally { datacontext.Dispose(); } }
public void DeleteMEnterriseMessage(int id) { EMSEntities entity = new EMSEntities(); MEnterpriseMessage item = entity.MEnterpriseMessage.SingleOrDefault(m => m.MessageID == id); entity.MEnterpriseMessage.Remove(item); entity.SaveChanges(); }
public void DeleteMEnterpriseCases(int cid) { EMSEntities entity = new EMSEntities(); MEnterpriseCases cases = entity.MEnterpriseCases.SingleOrDefault(m => m.MEnterpriseCasesID == cid); entity.MEnterpriseCases.Remove(cases); entity.SaveChanges(); }
public void DeleteEnterprise(int id) { EMSEntities entity = new EMSEntities(); Enterprise item = entity.Enterprise.SingleOrDefault(m => m.EnterpriseID == id); entity.Enterprise.Remove(item); entity.SaveChanges(); }
public void SetMEnterriseMessage(MEnterpriseMessage message) { EMSEntities entity = new EMSEntities(); entity.MEnterpriseMessage.Add(message); entity.SaveChanges(); }
public void UpdateMEnterriseMessage(int id, bool read) { EMSEntities entity = new EMSEntities(); MEnterpriseMessage item = entity.MEnterpriseMessage.SingleOrDefault(m => m.MessageID == id); item.MessageIsRead = read; entity.SaveChanges(); }
//public IHttpActionResult GetAllGrps(string name) //{ // IList<GroupChangeViewModel> gps = null; // using (var ctx = new EMSEntities()) // { // gps = ctx.GRPCHANGEs // .Where(s => s.CHDATE.ToLower() == name.ToLower()) // .Select(s => new GroupChangeViewModel() // { // TRNNO = s.TRNNO, // CHDATE = s.CHDATE, // EM_TRNNO = s.EM_TRNNO, // GRPMST_TRNNO = s.GRPMST_TRNNO // }).ToList<GroupChangeViewModel>(); // } // if (gps.Count == 0) // { // return NotFound(); // } // return Ok(gps); //} public IHttpActionResult PostNewGrp(GroupChangeViewModel bp) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new EMSEntities()) { int _trnno; //int _sr = 1; //db.Users.OrderByDescending(u => u.UserId).FirstOrDefault(); if (bp.TRNNO == 0) { _trnno = Convert.ToInt32(ctx.GRPCHANGEs.OrderByDescending(t => t.TRNNO).FirstOrDefault().TRNNO); _trnno = _trnno + 1; //_trnno = Convert.ToInt32(ctx.EMs.OrderByDescending(t => t.TRNNO).First().ToString()); } else { _trnno = Convert.ToInt32(bp.TRNNO) + 1; } // int totalConunt = ctx.GRPCHANGEs.Count<GRPCHANGE>(); //bp.TRNNO = _trnno; ctx.GRPCHANGEs.Add(new GRPCHANGE() { TRNNO = _trnno, CHDATE = bp.CHDATE, EM_TRNNO = bp.EM_TRNNO, GRPMST_TRNNO = bp.GRPMST_TRNNO }); try { ctx.SaveChanges(); } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } } return(Ok()); }
//insert public int saveEmpDB(employee employee) { try { int flag = 0; var result = db.employees.Where(e => e.emp_nic.Equals(employee.emp_nic)).FirstOrDefault(); if (result == null) { db.employees.Add(employee); db.SaveChanges(); flag = 1; } return(flag); } catch (Exception) { throw; } }
public void InsertMEnterpriseCases(MEnterpriseCases cases) { EMSEntities entity = new EMSEntities(); if (!entity.MEnterpriseCases.Any(m => m.MEnterpriseCasesID == cases.MEnterpriseCasesID)) { entity.MEnterpriseCases.Add(cases); entity.SaveChanges(); } }
public IHttpActionResult Put(ClassFeeViewModel mt) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new EMSEntities()) { try { var existingClassFee = ctx.CLFEEMSTs.Where(s => s.TRNNO == mt.TRNNO) .FirstOrDefault <CLFEEMST>(); if (existingClassFee != null) { existingClassFee.CLASS_TRNNO = mt.CLASS_TRNNO; foreach (var dtl in mt.CLFEEDTLs) { var mkdetail = new CLFEEDTL { TRNNO = dtl.TRNNO, SR = dtl.SR, FEE = dtl.FEE, ADT = dtl.ADT }; ctx.Entry(mkdetail).State = System.Data.Entity.EntityState.Modified; } ctx.SaveChanges(); } else { return(NotFound()); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(Ok()); }
public IHttpActionResult Put(SectionViewModel sec) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new EMSEntities()) { try { var existingSection = ctx.SECMSTs.Where(s => s.TRNNO == sec.TRNNO) .FirstOrDefault <SECMST>(); if (existingSection != null) { existingSection.CLASS_TRNNO = sec.CLASS_TRNNO; existingSection.TRNNO = sec.TRNNO; foreach (var secdtl in sec.SECDTLs) { var detailSection = new SECDTL { //BudgetId = Here i need to get id of the Budget table that i inserted before TRNNO = sec.TRNNO, SR = secdtl.SR, SNAME = secdtl.SNAME, STATUS = secdtl.STATUS, }; ctx.SECDTLs.Add(detailSection); } ctx.SaveChanges(); } else { return(NotFound()); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(Ok()); }
//insert method public int saveClientDB(client client) { int flag = 0; try { var result = db.clients.Where(c => c.client_nic.Equals(client.client_nic)).FirstOrDefault(); if (result == null) { db.clients.Add(client); db.SaveChanges(); flag = 1; } } catch (Exception) { throw; } return(flag); }
public bool SaveEnquiry(EnquiryDetailViewModel ob) { var _enq = new EnquiryDetail(); _enq.FirstName = ob.FirstName.ToStringValue(); _enq.LastName = ob.LastName.ToStringValue(); _enq.DOB = ob.DOB.ToStringValue(); _enq.Mobile = ob.Mobile.ToStringValue(); _enq.Class = ob.Class.ToStringValue(); _enq.Address = ob.Address.ToStringValue(); _enq.Email = ob.Email.ToStringValue(); _enq.EntryTime = DateTime.Now; _enq.ResolvedTime = null; _enq.Dated = DateTime.Now; _enq.Resolved = false; _ety.EnquiryDetails.Add(_enq); _ety.SaveChanges(); ob.ID = _enq.ID; return(true); }
/// <summary> /// Saves context changes /// </summary> public void SaveChanges() { try { _context.SaveChanges(); } catch (DbEntityValidationException e) { LogEntityValidationErrors(e.EntityValidationErrors); throw; } }
public bool SetEnterpriseStatus(int id, bool status) { EMSEntities entity = new EMSEntities(); Enterprise enterprise = entity.Enterprise.SingleOrDefault(m => m.EnterpriseID == id); if (enterprise != null) { enterprise.EnterpriseStatus = status; return(entity.SaveChanges() != 0); } return(false); }
public bool AddTemplate(string templateName, string templateFile) { EMSEntities entity = new EMSEntities(); Templates template = new Templates(); template.TemplateName = templateName; template.Template = templateFile; entity.Templates.Add(template); return(entity.SaveChanges() != 0); }
public bool SetEnterpriseBrief(int enterpriseID, string brief) { EMSEntities entity = new EMSEntities(); Enterprise enterprise = entity.Enterprise.SingleOrDefault(m => m.EnterpriseID == enterpriseID); if (enterprise != null) { enterprise.EnterpriseBrief = brief; return(entity.SaveChanges() != 0); } return(false); }
//update method public int updateTaskDB(int id, task task) { int flag = 0; try { var result = db.tasks.Where(t => t.task_id == id && t.task_status == 1).FirstOrDefault(); if (result != null) { db.Entry(result).State = EntityState.Detached; db.Entry(task).State = EntityState.Modified; db.SaveChanges(); flag = 1; } } catch (Exception) { throw; } return(flag); }
public bool ChangeAdminPwd(string admin, string newpwd) { EMSEntities entity = new EMSEntities(); MEnterpriseAdmin _admin = entity.MEnterpriseAdmin.SingleOrDefault(m => m.AdminName == admin); if (_admin == null) { return(false); } _admin.MEnterpriseAdminPassword = newpwd; entity.SaveChanges(); return(true); }
protected void Button2_Click(object sender, EventArgs e) { EMSEntities Context=new EMSEntities(); EntittyFramewordWebApplication4.StudentDetail stud1=new StudentDetail(); stud1.id = "67"; stud1.name = "ziauddin"; stud1.address = "chittagong"; stud1.marks = 88; stud1.section = "C"; Context.StudentDetails.Add(stud1); Context.SaveChanges(); Label1.Text = "added"; }
protected void Button3_Click(object sender, EventArgs e) { EMSEntities dbcontext = new EMSEntities(); EntittyFramewordWebApplication4.StudentDetail stud1 = new StudentDetail(); try { string idd = TextBox2.Text; stud1 = dbcontext.StudentDetails.FirstOrDefault(xx => xx.id == idd); stud1.marks = int.Parse(TextBox6.Text); stud1.section = TextBox5.Text; dbcontext.SaveChanges(); Label1.Text = "updated successfull"; } catch(Exception e1) { Label1.Text = "not found"; } }
protected void Button7_Click(object sender, EventArgs e) { //EMSEntities dbcontext = new EMSEntities(); //emp e1 = new emp(); //e1.empId = int.Parse(TextBox2.Text); //e1.name = TextBox4.Text; //e1.deptno = int.Parse(TextBox5.Text); //e1.job = TextBox5.Text; //e1.salary = int.Parse(TextBox6.Text); //dbcontext.emps.Add(e1); //dbcontext.SaveChanges(); //Label1.Text = "added from emp table"; EMSEntities dbcontext = new EMSEntities(); emp e1 = new emp(); e1.empId = 786; e1.name = "pabel"; e1.deptno = 56; e1.job = "hr"; e1.salary = 6700; dbcontext.emps.Add(e1); dbcontext.SaveChanges(); Label1.Text = "added from emp table"; }