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);
}
