/// <summary>
/// this function saves all parent info
/// </summary>
/// <param name="model">parent info</param>
public void SaveAllDetail1(IEnumerable <RoutFacilityInfoModel> model)
{
if (model.FirstOrDefault().RoutID != null)
{
context.ExecuteQuery <int>("DELETE from PP_RoutFacilityInfo where RoutID=" + model.FirstOrDefault().RoutID).FirstOrDefault();
}
// var itIsID = GetMaxID() - 1;
foreach (var item in model)
{
DataLayer.PP_RoutFacilityInfo tbl = new DataLayer.PP_RoutFacilityInfo();
tbl = ConvertToTable(item);
if (item.RoutID != null)
{
tbl.RoutID = item.RoutID;
}
else
{
tbl.RoutID = GetMaxID() - 1;
}
tbl.BranchID = CRMStaticData.StaticData.getBranchID;
tbl.RegisteredDate = CRMStaticData.StaticData.getRegisteredDate;
tbl.UserID = CRMStaticData.StaticData.getUserID;
tbl.YearID = CRMStaticData.StaticData.getYearID;
context.PP_RoutFacilityInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
context.ExecuteQuery <int>("UPDATE PP_RoutInfo set PartID=" + model.FirstOrDefault().PartID + "where RoutID=" + model.FirstOrDefault().RoutID);
}
/// <summary>
/// this function edit all parent data
/// first delete all parent id then save all sended parent info
/// </summary>
/// <param name="model">all parent info</param>
public void EditAllDetail1(IEnumerable <RoutFacilityInfoModel> model)
{
DeleteAllDetail1((int)model.First().RoutID);
foreach (var item in model)
{
DataLayer.PP_RoutFacilityInfo tbl = new DataLayer.PP_RoutFacilityInfo();
tbl = ConvertToTable(item);
context.PP_RoutFacilityInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
}
public DataLayer.PP_RoutFacilityInfo ConvertToTable(RoutFacilityInfoModel model)
{
DataLayer.PP_RoutFacilityInfo tbl = new DataLayer.PP_RoutFacilityInfo();
// tbl.RoutFacilityID = model.RoutFacilityID;
tbl.RoutID = model.RoutID;
tbl.FaciltiyID = model.FaciltiyID;
// part id saved in Master
tbl.PartID = _model.PartID;
tbl.TimeDurationMin = model.TimeDurationMin;
tbl.YearID = model.YearID;
tbl.BranchID = model.BranchID;
tbl.UserID = model.UserID;
tbl.RegisteredDate = model.RegisteredDate;
tbl.PartID = model.PartID;
return(tbl);
}
public RoutFacilityInfoModel ConvertToModel(DataLayer.PP_RoutFacilityInfo tbl)
{
RoutFacilityInfoModel model = new RoutFacilityInfoModel();
model.RoutFacilityID = tbl.RoutFacilityID;
model.RoutID = tbl.RoutID;
model.FaciltiyID = tbl.FaciltiyID;
model.PartID = tbl.PartID;
model.TimeDurationMin = tbl.TimeDurationMin;
model.YearID = tbl.YearID;
model.BranchID = tbl.BranchID;
model.UserID = tbl.UserID;
model.RegisteredDate = tbl.RegisteredDate;
model.FaciltiyName = context.PP_FacilityInfos.Where(q => q.FacilityID == tbl.FaciltiyID).FirstOrDefault().FacilityName;
model.PartName = context.MRP_PartInfos.Where(q => q.PartID == tbl.PartID).FirstOrDefault().PartName;
return(model);
}
