public HttpResponseMessage UpdateQuotation(Entities.TrnQuotation objQuotation, String id)
{
try
{
var quotaion = from d in db.IS_TrnQuotations
where d.Id == Convert.ToInt32(id)
select d;
if (quotaion.Any())
{
var updateQuotaion = quotaion.FirstOrDefault();
updateQuotaion.QuotationNumber = objQuotation.QuotationNumber;
updateQuotaion.QuotationDate = Convert.ToDateTime(objQuotation.QuotationDate);
updateQuotaion.LeadId = objQuotation.LeadId;
updateQuotaion.CustomerId = objQuotation.CustomerId;
updateQuotaion.ProductId = objQuotation.ProductId;
updateQuotaion.Remarks = objQuotation.Remarks;
updateQuotaion.QuotationStatus = objQuotation.QuotationStatus;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Updated!"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Data Not Exist!"));
};
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!"));
}
}
public HttpResponseMessage AddQuotation(Entities.TrnQuotation objQuotation)
{
try
{
Data.IS_TrnQuotation newQuotation = new Data.IS_TrnQuotation
{
Id = objQuotation.Id,
QuotationNumber = objQuotation.QuotationNumber,
QuotationDate = Convert.ToDateTime(objQuotation.QuotationDate),
LeadId = objQuotation.LeadId,
CustomerId = objQuotation.CustomerId,
ProductId = objQuotation.ProductId,
Remarks = objQuotation.Remarks,
EncodedByUserId = objQuotation.EncodedByUserId,
QuotationStatus = objQuotation.QuotationStatus
};
db.IS_TrnQuotations.InsertOnSubmit(newQuotation);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Added!"));
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!"));
}
}