public bool editDetail(ProductionLineInfoModel detail, int prid)
{
bool result = false;
var tbl = (from t in context.PP_ScheduleProductionLineInfos
where
t.ScheduleProductionLineID == detail.ScheduleProductionLineID
select t).FirstOrDefault();
//DataLayer.PP_ScheduleProductionLineInfo tbl = new DataLayer.PP_ScheduleProductionLineInfo();
tbl.ProductionLineID = prid;
tbl.ScheduleID = detail.ScheduleID;
tbl.ScheduleProductionLineID = (int)detail.ScheduleProductionLineID;
tbl.CycleTime = detail.CycleTime;
tbl.ScheduleStartTime = detail.ScheduleStartTime;
tbl.DurationTime = detail.DurationTime;
tbl.Date = detail.Date;
tbl.ScheduleFinishTime = detail.ScheduleFinishTime;
tbl.Year = returnYear(detail.Date);
tbl.Month = returnMonth(detail.Date);
tbl.Day = returnDay(detail.Date);
tbl.RoutID = detail.RoutID;
tbl.InputID = detail.InputID;
tbl.YearID = CRMStaticData.StaticData.getYearID;
tbl.UserID = CRMStaticData.StaticData.getUserID;
tbl.BranchID = CRMStaticData.StaticData.getBranchID;
tbl.RegisteredDate = CRMStaticData.StaticData.DateNow(0).Date;
// context.PP_ScheduleProductionLineInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
result = true;
return(result);
}
/// <summary>
/// this function conver the table form to model
/// </summary>
/// <param name="tbl"></param> the covertable table
/// <returns></returns>the converted model
public ProductionLineInfoModel ConvertToModel(DataLayer.PP_ProductionLineInfo tbl)
{
ProductionLineInfoModel model = new ProductionLineInfoModel();
var res = context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.ResponsibleID).FirstOrDefault();
var sche = context.PP_ScheduleProductionLineInfos.Where(q => q.ProductionLineID == tbl.ProductionLineID).FirstOrDefault();
var shiftstatus = context.PP_ProductionLineInfos.Where(q => q.Shift == tbl.Shift).FirstOrDefault();
model.ProductionLineID = tbl.ProductionLineID;
// model.ProductionLineStop = tbl.ProductionLineStop;
model.ResponsibleID = tbl.ResponsibleID;
model.ResponsibleName = (res == null)?"-":res.WorkersSurname;
model.WorkStationID = tbl.WorkStationID;
model.Shift = tbl.Shift;
if (shiftstatus != null)
{
if (tbl.Shift == 1)
{
model.ShiftName = "شب";
}
if (tbl.Shift == 2)
{
model.ShiftName = "روز";
}
}
// model.LineAcceptance = tbl.LineAcceptance;
// model.LineEfficiency = tbl.LineEfficiency;
//model.LineGoal = tbl.LineGoal;
model.RoutID = tbl.RoutID;
model.YearID = tbl.YearID;
model.UserID = tbl.UserID;
if (sche != null)
{
model.RegisteredDate = sche.Date;
}
else
{
model.RegisteredDate = tbl.RegisteredDate;
}
model.BranchID = tbl.BranchID;
// model.RoutName = context.PP_RoutInfos.Where(q => q.RoutID == tbl.RoutID).FirstOrDefault().RoutName;
if (context.PP_WorkStationInfos.Where(q => q.WorkStationID == tbl.WorkStationID).FirstOrDefault() != null)
{
model.WorkStationName = context.PP_WorkStationInfos.Where(q => q.WorkStationID == tbl.WorkStationID).FirstOrDefault().WorkStationName;
}
if (sche != null)
{
model.ScheduleProductionLineID = sche.ScheduleProductionLineID;
}
return(model);
}
/// <summary>
/// this function copy the model for edit
/// </summary>
/// <param name="model"></param> the model should be edited
/// <returns></returns> returns if the copy is successfull
public Boolean Edit(ProductionLineInfoModel model)
{
Boolean result = true;
try
{
IsEdit = true;
_model = model;
}
catch (Exception ex)
{
result = false;
}
return(result);
}
/// <summary>
/// this function copy the models to save
/// </summary>
/// <param name="model"></param> the copyable model
/// <returns></returns> returns if the copy is successfull
public Boolean Add(ProductionLineInfoModel model)
{
Boolean result = true;
try
{
_model = model;
_model.BranchID = CRMStaticData.StaticData.getBranchID;
_model.RegisteredDate = CRMStaticData.StaticData.getRegisteredDate;
_model.UserID = CRMStaticData.StaticData.getUserID;
_model.YearID = CRMStaticData.StaticData.getYearID;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(result);
}
/// <summary>
/// this function convert the model to table form
/// </summary>
/// <param name="model"></param> the convertable model
/// <returns></returns> returns the converted table
public DataLayer.PP_ProductionLineInfo ConvertToTable(ProductionLineInfoModel model)
{
DataLayer.PP_ProductionLineInfo tbl = new DataLayer.PP_ProductionLineInfo();
tbl.ProductionLineID = model.ProductionLineID;
tbl.ProductionLineStop = model.ProductionLineStop;
tbl.WorkStationID = model.WorkStationID;
tbl.LineAcceptance = model.LineAcceptance;
tbl.LineEfficiency = model.LineEfficiency;
tbl.LineGoal = model.LineGoal;
tbl.Shift = model.Shift;
tbl.RoutID = model.RoutID;
tbl.YearID = model.YearID;
tbl.UserID = model.UserID;
tbl.RegisteredDate = model.RegisteredDate;
tbl.BranchID = model.BranchID;
tbl.ResponsibleID = model.ResponsibleID;
return(tbl);
}
public void saveDetail(ProductionLineInfoModel item, int MasterID)
{
DataLayer.PP_ScheduleProductionLineInfo tbl = new DataLayer.PP_ScheduleProductionLineInfo();
tbl.ProductionLineID = MasterID;
tbl.ScheduleID = item.ScheduleID;
tbl.CycleTime = item.CycleTime;
tbl.ScheduleStartTime = item.ScheduleStartTime;
tbl.DurationTime = item.DurationTime;
tbl.Date = item.Date;
tbl.ScheduleFinishTime = item.ScheduleFinishTime;
tbl.Year = returnYear(item.Date);
tbl.Month = returnMonth(item.Date);
tbl.Day = returnDay(item.Date);
tbl.RoutID = item.RoutID;
tbl.InputID = item.InputID;
tbl.YearID = CRMStaticData.StaticData.getYearID;
tbl.UserID = CRMStaticData.StaticData.getUserID;
tbl.BranchID = CRMStaticData.StaticData.getBranchID;
tbl.RegisteredDate = CRMStaticData.StaticData.DateNow(0).Date;
context.PP_ScheduleProductionLineInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}