public long AddCiPl(CiPlModel ciPlModel)
{
try
{
var ciPlMaster = ciPlModel.CiPlMasterData;
var ciPlDetailsList = ciPlModel.CiPlDetailsList;
ciPlMaster.supplier_id = ciPlModel.CiPlMasterData.supplier_id;
ciPlMaster.purchase_order_master_id = ciPlModel.CiPlMasterData.purchase_order_master_id;
ciPlMaster.ci_no = ciPlModel.CiPlMasterData.ci_no;
ciPlMaster.ref_no = ciPlModel.CiPlMasterData.ref_no;
ciPlMaster.ci_date = Convert.ToDateTime(ciPlModel.CiPlMasterData.ci_date);
ciPlMaster.payment_term = ciPlModel.CiPlMasterData.payment_term;
ciPlMaster.dc_no = ciPlModel.CiPlMasterData.dc_no;
ciPlMaster.issue_date = Convert.ToDateTime(ciPlModel.CiPlMasterData.issue_date);
ciPlMaster.created_by = ciPlModel.CiPlMasterData.created_by;
ciPlMaster.created_date = DateTime.Now;
ciPlMaster.updated_by = ciPlModel.CiPlMasterData.updated_by;
ciPlMaster.updated_date = DateTime.Now;
ciPlMaster.is_active = true;
ciPlMaster.is_received = false;
_entities.ci_pl_master.Add(ciPlMaster);
_entities.SaveChanges();
long ciPlMasterId = ciPlMaster.ci_pl_master_id;
foreach (var item in ciPlDetailsList)
{
var ciPlDetails = new ci_pl_details
{
ci_pl_master_id = ciPlMasterId,
product_id = item.product_id,
unit_price = item.unit_price,
quantity = item.quantity,
amount = item.amount,
nw_kg_ctn = item.nw_kg_ctn,
gw_kg_ctn = item.gw_kg_ctn,
measurement = item.measurement
};
_entities.ci_pl_details.Add(ciPlDetails);
_entities.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public bool DeleteCiPlDetailsById(long ci_pl_details_id)
{
try
{
ci_pl_details oCiPlDetailsDetails = _entities.ci_pl_details.Find(ci_pl_details_id);
_entities.ci_pl_details.Attach(oCiPlDetailsDetails);
_entities.ci_pl_details.Remove(oCiPlDetailsDetails);
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool EditCiPl(CiPlModel ciPlModel)
{
try
{
var ciPlMaster = ciPlModel.CiPlMasterData;
var ciPlDetailsList = ciPlModel.CiPlDetailsList;
ci_pl_master masterData = _entities.ci_pl_master.Find(ciPlMaster.ci_pl_master_id);
masterData.supplier_id = ciPlModel.CiPlMasterData.supplier_id;
masterData.purchase_order_master_id = ciPlModel.CiPlMasterData.purchase_order_master_id;
masterData.ci_no = ciPlModel.CiPlMasterData.ci_no;
masterData.ref_no = ciPlModel.CiPlMasterData.ref_no;
masterData.ci_date = Convert.ToDateTime(ciPlModel.CiPlMasterData.ci_date);
masterData.payment_term = ciPlModel.CiPlMasterData.payment_term;
masterData.dc_no = ciPlModel.CiPlMasterData.dc_no;
masterData.issue_date = Convert.ToDateTime(ciPlModel.CiPlMasterData.issue_date);
masterData.updated_by = ciPlModel.CiPlMasterData.updated_by;
masterData.updated_date = DateTime.Now;
masterData.is_active = true;
_entities.SaveChanges();
foreach (var item in ciPlDetailsList)
{
ci_pl_details detailsData = _entities.ci_pl_details.FirstOrDefault(pd => pd.ci_pl_master_id == item.ci_pl_master_id && pd.ci_pl_details_id == item.ci_pl_details_id);
if (detailsData != null)
{
detailsData.ci_pl_master_id = ciPlMaster.ci_pl_master_id;
detailsData.product_id = item.product_id;
detailsData.unit_price = item.unit_price;
detailsData.quantity = item.quantity;
detailsData.amount = item.amount;
detailsData.nw_kg_ctn = item.nw_kg_ctn;
detailsData.gw_kg_ctn = item.gw_kg_ctn;
detailsData.measurement = item.measurement;
_entities.SaveChanges();
}
else
{
var ciPlDetails = new ci_pl_details
{
ci_pl_master_id = ciPlMaster.ci_pl_master_id,
product_id = item.product_id,
unit_price = item.unit_price,
quantity = item.quantity,
amount = item.amount,
nw_kg_ctn = item.nw_kg_ctn,
gw_kg_ctn = item.gw_kg_ctn,
measurement = item.measurement
};
_entities.ci_pl_details.Add(ciPlDetails);
_entities.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
