public int Update(Models.MEmployees model) { Common.Logger l = new Common.Logger(); string ClassName = "Employees"; try { var query = from o in obj.Employees where Convert.ToString(o.id) == model.id select o; foreach (var item in query) { item.DesignationId = Convert.ToInt32(model.DesignationId); item.FirstName = model.FirstName; item.FirstName = model.FirstName; item.LastName = model.LastName; item.DateOfBirth = model.DateOfBirth; item.Gender = model.Gender; item.Address = model.Address; item.City = model.City; item.HomePhone = model.HomePhone; item.CellNo = model.CellNo; item.Email = model.Email; item.EmergencyContactNo = model.EmergencyContactNo; } l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] DesignationId[" + model.DesignationId + "] FirstName[" + model.FirstName + "] LastName[" + model.LastName + "] DateOfBirth [" + model.DateOfBirth + " ] gender [ " + model.Gender + " ] Address[ " + model.Address + " ] City [ " + model.City + " ] HomePhone [ " + model.HomePhone + " ] CellPhone [ " + model.CellNo + " ] Email[ " + model.Email + " ] EmergencyContactNo [ " + model.EmergencyContactNo + " ]"); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public List <Models.MEmployees> GetAllbyid(int id) { List <Models.MEmployees> model = new List <Models.MEmployees>(); var query = from o in obj.Employees where Convert.ToString(o.id) == id.ToString() select o; foreach (var item in query) { Models.MEmployees m = new Models.MEmployees(); m.id = Convert.ToString(item.id); m.DesignationId = Convert.ToString(item.DesignationId); m.FirstName = item.FirstName; m.LastName = item.LastName; m.DateOfBirth = item.DateOfBirth; m.Gender = item.Gender; m.Address = item.Address; m.City = item.City; m.HomePhone = item.HomePhone; m.CellNo = item.CellNo; m.Email = item.Email; m.EmergencyContactNo = item.EmergencyContactNo; model.Add(m); } return(model); }
public int Save(Models.MEmployees model) { Common.Logger l = new Common.Logger(); string ClassName = "CEmployees"; try { DB.Employee bs = new DB.Employee(); bs.id = Convert.ToInt32(model.id); bs.DesignationId = Convert.ToInt32(model.DesignationId); bs.FirstName = model.FirstName; bs.LastName = model.LastName; bs.DateOfBirth = model.DateOfBirth; bs.Gender = model.Gender; bs.Address = model.Address; bs.City = model.City; bs.HomePhone = model.HomePhone; bs.CellNo = model.CellNo; bs.Email = model.Email; bs.EmergencyContactNo = model.EmergencyContactNo; bs.WarehouseId = Convert.ToInt32(model.WareHouseId); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] DesignationId[" + model.DesignationId + "] FirstName[" + model.FirstName + "] LastName[" + model.LastName + "] DateOfBirth [" + model.DateOfBirth + " ] gender [ " + model.Gender + " ] Address[ " + model.Address + " ] City [ " + model.City + " ] HomePhone [ " + model.HomePhone + " ] CellPhone [ " + model.CellNo + " ] Email[ " + model.Email + " ] EmergencyContactNo [ " + model.EmergencyContactNo + " ]"); obj.Employees.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
protected void btnSaveEmployee_Click(object sender, EventArgs e) { if (Session["WareHouse"] != null) { string WareHouseId = Session["WareHouse"].ToString(); if (Page.IsValid) { string FirstName = txtEmployeeFirstName.Text; string LastName = txtEmployeeLastName.Text; string Dob = txtEmployeeDateOfBirth.Text; string Gender = txtEmployeeGender.Text; string Address = txtEmployeeAddress.Text; string City = txtEmployeeCity.Text; string HomePhone = txtEmployeeHomePhone.Text; string CellNo = txtEmployeeCellNo.Text; string Email = txtEmployeeEmail.Text; string EmergencyContactNo = txtEmployeeEmergencyContactNo.Text; Models.MEmployees me = new Models.MEmployees(); me.DesignationId = "1"; me.FirstName = FirstName; me.LastName = LastName; me.DateOfBirth = Dob; me.Address = Address; me.City = City; me.HomePhone = HomePhone; me.CellNo = CellNo; me.Email = Email; me.EmergencyContactNo = EmergencyContactNo; me.WareHouseId = WareHouseId; Classes.CEmployees ce = new Classes.CEmployees(); if (ce.Save(me) < 0) { ShowFailMessage(); } else { ShowSuccessMessage(); ClearTextBoxes(Page); } } } else { ShowErrorModal("Cannot Save, No Warehouse associated with current user"); } }