public SparePartsInfoDTO GetSparePartsInfo(int SparePartsInfoID)
{
SparePartsInfoDTO obj = new SparePartsInfoDTO();
try
{
using (var entities = new ManiMotorsEntities1())
{
var lstSparePartsInfo = entities.SparePartsInfoes.Where(x => x.SparePartsInfoID == SparePartsInfoID).FirstOrDefault();
obj.SparePartsInfoID = lstSparePartsInfo.SparePartsInfoID;
obj.SparePartsTypeID = lstSparePartsInfo.SparePartsTypeID;
obj.ModelCode = lstSparePartsInfo.ModelCode;
obj.ModelName = lstSparePartsInfo.ModelName;
obj.ShowRoomPrice = lstSparePartsInfo.ShowRoomPrice;
obj.MarginPrice = lstSparePartsInfo.MarginPrice;
obj.CreatedDate = lstSparePartsInfo.CreatedDate ?? DateTime.Now;
obj.CreatedBy = lstSparePartsInfo.Createdby ?? 0;
obj.ModifiedDate = lstSparePartsInfo.ModifiedDate ?? DateTime.Now;
obj.ModifiedBy = lstSparePartsInfo.Modifiedby ?? 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public List <SparePartsInfoDTO> GetAllSparePartsInfo()
{
List <SparePartsInfoDTO> obj = new List <SparePartsInfoDTO>();
try
{
using (var entities = new ManiMotorsEntities1())
{
var lstSparePartsInfo = entities.SparePartsInfoes.ToList();
foreach (var Info in lstSparePartsInfo)
{
SparePartsInfoDTO dto = new SparePartsInfoDTO();
dto.SparePartsInfoID = Info.SparePartsInfoID;
dto.SparePartsTypeID = Info.SparePartsTypeID;
dto.ModelCode = Info.ModelCode;
dto.ModelName = Info.ModelName;
dto.ShowRoomPrice = Info.ShowRoomPrice;
dto.MarginPrice = Info.MarginPrice;
dto.CreatedDate = Info.CreatedDate ?? DateTime.Now;
dto.CreatedBy = Info.Createdby ?? 0;
dto.ModifiedDate = Info.ModifiedDate ?? DateTime.Now;
dto.ModifiedBy = Info.Modifiedby ?? 0;
obj.Add(dto);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ddlSparePartsType.SelectedIndex == -1 || txtModelCode.Text == "" || txtModelName.Text == "" || txtMarginPrice.Text == "" || txtShowRoomPrice.Text == "")
{
MyMessageBox.ShowBox("Please Select All Mandatory Fields!!!");
return;
}
SparePartsInfoDTO info = new SparePartsInfoDTO();
var selItem = (ComboboxItem)ddlSparePartsType.SelectedItem;
info.SparePartsInfoID = _SparePartsInfoID;
info.SparePartsTypeID = Convert.ToInt32(selItem.Value);
info.ModelCode = txtModelCode.Text;
info.ModelName = txtModelName.Text;
info.ShowRoomPrice = Convert.ToInt32(txtShowRoomPrice.Text);
info.MarginPrice = Convert.ToInt32(txtMarginPrice.Text);
info.CreatedDate = System.DateTime.Now;
info.CreatedBy = GlobalSetup.Userid;
info.ModifiedDate = System.DateTime.Now;
SparePartsInfoBL viBL = new SparePartsInfoBL();
var flag = viBL.SaveSparePartsInfo(info, _mode);
if (flag)
{
MyMessageBox.ShowBox("SpareParts Information Saved", "SpareParts Info");
Clear();
}
else
{
MyMessageBox.ShowBox("SpareParts Information Failed to Save", "SpareParts Info");
}
}
public bool SaveSparePartsInfo(SparePartsInfoDTO dto, string mode)
{
var flag = false;
try
{
using (var entities = new ManiMotorsEntities1())
{
if (mode == "EDIT")
{
var info = entities.SparePartsInfoes.FirstOrDefault(v => v.SparePartsInfoID == dto.SparePartsInfoID);
info.SparePartsTypeID = dto.SparePartsTypeID;
info.ModelCode = dto.ModelCode;
info.ModelName = dto.ModelName;
info.ShowRoomPrice = dto.ShowRoomPrice;
info.MarginPrice = dto.MarginPrice;
info.CreatedDate = dto.CreatedDate;
info.Createdby = dto.CreatedBy;
info.ModifiedDate = dto.ModifiedDate;
info.Modifiedby = dto.ModifiedBy;
entities.SaveChanges();
flag = true;
}
else
{
SparePartsInfo info = new SparePartsInfo();
info.SparePartsTypeID = dto.SparePartsTypeID;
info.ModelCode = dto.ModelCode;
info.ModelName = dto.ModelName;
info.ShowRoomPrice = dto.ShowRoomPrice;
info.MarginPrice = dto.MarginPrice;
info.CreatedDate = dto.CreatedDate;
info.Createdby = dto.CreatedBy;
info.ModifiedDate = dto.ModifiedDate;
info.Modifiedby = dto.ModifiedBy;
entities.SparePartsInfoes.Add(info);
entities.SaveChanges();
flag = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
