//linq query used to update po details of (ImSS_Master_PO)
public List <ImSS_Master_PO> UpdatePO(ImSS_Master_PO po)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_PO UpdatePo = (from c in context.ImSS_Master_PO where c.ID == po.ID select c).FirstOrDefault();
UpdatePo.Client_Name = po.Client_Name;
UpdatePo.Project_Name = po.Project_Name;
UpdatePo.PO_Number = po.PO_Number;
UpdatePo.Point_Of_Contact = po.Point_Of_Contact;
UpdatePo.Mode_Of_Payment = po.Mode_Of_Payment;
UpdatePo.Currency = po.Currency;
UpdatePo.PO_StartDate = po.PO_StartDate;
UpdatePo.PO_EndDate = po.PO_EndDate;
UpdatePo.PO_Initial_Amount = po.PO_Initial_Amount;
UpdatePo.PO_Duration = po.PO_Duration;
UpdatePo.PO_Renewed_Amount = po.PO_Renewed_Amount;
UpdatePo.PO_Renewed_Date = po.PO_Renewed_Date;
UpdatePo.Parent_PO = po.Parent_PO;
UpdatePo.PO_Status = po.PO_Status;
UpdatePo.PO_Total_Amount_INR = po.PO_Total_Amount_INR;
UpdatePo.PO_Close_Date = po.PO_Close_Date;
context.SaveChanges();
return((from a in context.ImSS_Master_PO select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult InsertPO(ImSS_Master_PO po)
{
try
{
if (ModelState.IsValid)
{
PBL.AddPOMaster(po);
}
return(Json(po));
}
catch (Exception e)
{
throw e;
}
}
public ActionResult Edit(ImSS_Master_PO po)
{
try
{
if (ModelState.IsValid)
{
PBL.UpdatePO(po);
}
return(Json(po));
}
catch (Exception e)
{
throw e;
}
}
//linq query used to insert POMaster details into (ImSS_Master_Emp_List)
public ImSS_Master_PO AddPOMaster(ImSS_Master_PO po)
{
try
{
using (var context = new Billing_StagingEntities1())
{
context.ImSS_Master_PO.Add(po);
context.SaveChanges();
return(po);
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to delete PO details of (ImSS_Master_PO)
public List <ImSS_Master_PO> Delete(int?Id)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_PO DeleteCilent = (from c in context.ImSS_Master_PO where c.ID == Id select c).FirstOrDefault();
if (DeleteCilent != null)
{
context.ImSS_Master_PO.Remove(DeleteCilent);
context.SaveChanges();
}
return((from a in context.ImSS_Master_PO select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
