// Get outstanding detail by specific req number and itemid
public static OutstandingReqDetailModel GetOutstandingReqDetailByIds
(int outreqid, int itemid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
outstandingrequisitiondetail ord = new outstandingrequisitiondetail();
OutstandingReqDetailModel ordm = new OutstandingReqDetailModel();
try
{
ord = entities.outstandingrequisitiondetails
.Where(x => x.outreqid == outreqid && x.itemid == itemid)
.FirstOrDefault();
ordm = ConvertDBOutReqDetailToAPIModel(ord);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(ordm);
}
public static OutstandingReqDetailModel CreateOutReqDetail(OutstandingReqDetailModel outreqdetail, string token, out string error)
{
string url = APIHelper.Baseurl + "/outstandingreqdetail/create/";
string objectstring = JsonConvert.SerializeObject(outreqdetail);
OutstandingReqDetailModel outm = APIHelper.Execute <OutstandingReqDetailModel>(token, objectstring, url, out error);
return(outm);
}
// Covert From APIModel to DBModel
public static outstandingrequisitiondetail ConvertAPIOutReqDetailToDBModel(OutstandingReqDetailModel outreqdetail)
{
outstandingrequisitiondetail ord =
new outstandingrequisitiondetail();
ord.outreqid = outreqdetail.OutReqId;
ord.itemid = outreqdetail.ItemId;
ord.qty = outreqdetail.Qty;
return(ord);
}
public IHttpActionResult CreateOutReqDetail(OutstandingReqDetailModel outreqdetail)
{
string error = "";
OutstandingReqDetailModel ordm =
OutstandingReqDetailRepo.CreateOutReqDetail(outreqdetail, out error);
if (error != "" || ordm == null)
{
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(ordm));
}
public IHttpActionResult UpdateOutReqDetail(OutstandingReqDetailModel outreqdetail)
{
string error = "";
OutstandingReqDetailModel ordm =
OutstandingReqDetailRepo.UpdateOutReqDetail(outreqdetail, out error);
if (error != "" || ordm == null)
{
if (error == ConError.Status.NOTFOUND)
{
return(Content(HttpStatusCode.NotFound, "Outstanding Not Found"));
}
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(ordm));
}
public static OutstandingReqDetailModel UpdateOutReqDetail
(OutstandingReqDetailModel ordm, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
OutstandingReqDetailModel outreqdetailm = new OutstandingReqDetailModel();
outstandingrequisitiondetail outreqdetail = new outstandingrequisitiondetail();
try
{
// finding the db object using API model
outreqdetail = entities.outstandingrequisitiondetails
.Where(x => x.outreqid == ordm.OutReqId &&
x.itemid == ordm.ItemId).FirstOrDefault();
// transfering data from API model to DB Model
outreqdetail.outreqid = ordm.OutReqId;
outreqdetail.itemid = ordm.ItemId;
outreqdetail.qty = ordm.Qty;
// saving the update
entities.SaveChanges();
// return the updated model
outreqdetailm = ConvertDBOutReqDetailToAPIModel(outreqdetail);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(outreqdetailm);
}
public static OutstandingReqDetailModel CreateOutReqDetail
(OutstandingReqDetailModel ordm, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
OutstandingReqDetailModel outreqdetailm = new OutstandingReqDetailModel();
outstandingrequisitiondetail outreqdetail = new outstandingrequisitiondetail();
try
{
// transfering data from API model to DB Model
outreqdetail.outreqid = ordm.OutReqId;
outreqdetail.itemid = ordm.ItemId;
outreqdetail.qty = ordm.Qty;
// adding into DB
entities.outstandingrequisitiondetails.Add(outreqdetail);
entities.SaveChanges();
outreqdetailm = GetOutstandingReqDetailByIds
(outreqdetail.outreqid, outreqdetail.itemid, out error);
// return the model
// outreqdetailm = ConvertDBOutReqDetailToAPIModel(outreqdetail);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(outreqdetailm);
}
