public bool UpdateSpareParts(SparePartsTypeDTO sparePartsDTO) { var flag = true; try { using (var entities = new ManiMotorsEntities1()) { var Gamesys = entities.SparePartsTypes.Where(g => g.SparePartsTypeID == sparePartsDTO.SparePartsTypeID).FirstOrDefault(); Gamesys.Description = sparePartsDTO.Description; //Gamesys.CreatedDate = expensesDTO.CreatedDate; //Gamesys.Createdby = expensesDTO.CreatedBy; Gamesys.Modifiedby = sparePartsDTO.ModifiedBy; Gamesys.ModifiedDate = sparePartsDTO.ModifiedDate; entities.SaveChanges(); } } catch (Exception ex) { flag = false; throw ex; } return(flag); }
public bool AddSpareParts(SparePartsTypeDTO sparePartsDTO) { var flag = true; try { using (var entities = new ManiMotorsEntities1()) { var sp = new SparePartsType() { Description = sparePartsDTO.Description, CreatedDate = sparePartsDTO.CreatedDate, Createdby = sparePartsDTO.CreatedBy, Modifiedby = sparePartsDTO.ModifiedBy, ModifiedDate = sparePartsDTO.ModifiedDate }; entities.SparePartsTypes.Add(sp); entities.SaveChanges(); flag = true; } } catch (Exception ex) { flag = false; throw ex; } return(flag); }
public List <SparePartsTypeDTO> GetSparePartsTypes() { var lstSparePartsTypes = new List <SparePartsTypeDTO>(); using (var entities = new ManiMotorsEntities1()) { foreach (var ent in entities.SparePartsTypes) { var sparePartsDTO = new SparePartsTypeDTO(); sparePartsDTO.SparePartsTypeID = ent.SparePartsTypeID; sparePartsDTO.Description = ent.Description; lstSparePartsTypes.Add(sparePartsDTO); } } return(lstSparePartsTypes); }
private void btnAdd_Click(object sender, EventArgs e) { if (validate()) { if (btntext == "ADD") { SparePartsTypeDTO spDTO = new SparePartsTypeDTO(); spDTO.Description = txtDescription.Text; spDTO.CreatedBy = GlobalSetup.Userid; spDTO.CreatedDate = DateTime.Now; spDTO.ModifiedDate = DateTime.Now; SparePartsTypeBL expen = new SparePartsTypeBL(); var result = expen.AddSpareParts(spDTO); LoadSparePartsType(); if (result) { MyMessageBox.ShowBox("SpareParts Type is Saved", "SpareParts"); } else { MyMessageBox.ShowBox("SpareParts Save is failed !!!"); } } else { SparePartsTypeDTO expenseDTO = new SparePartsTypeDTO(); expenseDTO.Description = txtDescription.Text; expenseDTO.SparePartsTypeID = Convert.ToInt32(dgSparePartsType.CurrentRow.Cells["SparePartsTypeID"].Value); expenseDTO.ModifiedDate = DateTime.Now; expenseDTO.ModifiedBy = GlobalSetup.Userid; SparePartsTypeBL exp = new SparePartsTypeBL(); var result = exp.UpdateSpareParts(expenseDTO); btntext = "ADD"; } clear(); LoadSparePartsType(); } else { MyMessageBox.ShowBox("Description cannot be Empty !!!"); } }
public List <SparePartsTypeDTO> GetSparePartsTypes() { List <SparePartsTypeDTO> obj = new List <SparePartsTypeDTO>(); try { using (var entities = new ManiMotorsEntities1()) { var lstSparePartsType = entities.SparePartsTypes.ToList(); foreach (var SparePartstype in lstSparePartsType) { SparePartsTypeDTO SparePartstypedto = new SparePartsTypeDTO(); SparePartstypedto.SparePartsTypeID = SparePartstype.SparePartsTypeID; SparePartstypedto.Description = SparePartstype.Description; obj.Add(SparePartstypedto); } } } catch (Exception ex) { throw ex; } return(obj); }