public CiPlModel GetCiPlById(long ci_pl_master_id)
{
var ciPlModel = new CiPlModel();
ciPlModel.CiPlMasterData = _entities.ci_pl_master.Find(ci_pl_master_id);
ciPlModel.CiPlDetailsList =
_entities.ci_pl_details
.Join(_entities.products, jp => jp.product_id, p => p.product_id, (jp, p) => new { jp, p })
.Where(k => k.jp.ci_pl_master_id == ci_pl_master_id)
.Select(i => new CiPlDetailsModel
{
ci_pl_details_id = i.jp.ci_pl_details_id,
ci_pl_master_id = i.jp.ci_pl_master_id,
product_id = i.p.product_id,
product_name = i.p.product_name,
has_serial = i.p.has_serial ?? false,
quantity = i.jp.quantity,
unit_price = i.jp.unit_price,
amount = i.jp.amount,
nw_kg_ctn = i.jp.nw_kg_ctn,
gw_kg_ctn = i.jp.gw_kg_ctn,
measurement = i.jp.measurement
}).OrderByDescending(p => p.ci_pl_details_id).ToList();
return(ciPlModel);
}
public HttpResponseMessage Put([FromBody] CiPlModel ciPlModel)
{
try
{
if (string.IsNullOrEmpty(ciPlModel.CiPlMasterData.supplier_id.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Please Select Supplier !!"
}, formatter));
}
if (string.IsNullOrEmpty(ciPlModel.CiPlMasterData.purchase_order_master_id.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Please Select PI !!"
}, formatter));
}
if (string.IsNullOrEmpty(ciPlModel.CiPlMasterData.ci_no.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Please Select PI !!"
}, formatter));
}
if (string.IsNullOrEmpty(ciPlModel.CiPlMasterData.ci_date.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "CI date is empty !!"
}, formatter));
}
if (string.IsNullOrEmpty(ciPlModel.CiPlMasterData.issue_date.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Issue date empty !!"
}, formatter));
}
else
{
ciPlRepository.EditCiPl(ciPlModel);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "CiPl Update successfully"
}, formatter));
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
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 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);
}
}
