public IHttpActionResult GetVoucherDTLById(int id)
{
VoucherDTLViewModel voucherDTL = null;
using (var ctx = new dbInventoryEntities())
{
voucherDTL = ctx.tblVoucherDTLs
.Where(s => s.intId == id)
.Select(s => new VoucherDTLViewModel()
{
intVNo = s.intVNo,
intId = s.intId,
intCategory = s.intCategory,
intItemCode = s.intItemCode,
intPieces = s.intPieces,
floatRate = s.floatRate,
floatCommission = s.floatCommission,
floatAmount = s.floatAmount
}).FirstOrDefault <VoucherDTLViewModel>();
}
if (voucherDTL == null)
{
return(NotFound());
}
return(Ok(voucherDTL));
}
public IHttpActionResult PostNewVoucherDTL(VoucherDTLViewModel voucherDTL)
{
//if (!ModelState.IsValid)
// return BadRequest("Invalid data.");
using (var ctx = new dbInventoryEntities())
{
int _intId = 1;
var obj = ctx.tblVoucherDTLs.OrderByDescending(t => t.intId).FirstOrDefault();
if (obj != null)
{
_intId = obj.intId + 1;
}
ctx.tblVoucherDTLs.Add(new tblVoucherDTL()
{
intVNo = voucherDTL.intVNo,
intId = _intId,
intCategory = voucherDTL.intCategory,
intItemCode = voucherDTL.intItemCode,
intPieces = voucherDTL.intPieces,
floatRate = voucherDTL.floatRate,
floatCommission = voucherDTL.floatCommission,
floatAmount = voucherDTL.floatCommission
});
try
{
ctx.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
return(Ok());
}
public IHttpActionResult Put(VoucherDTLViewModel voucherDTL)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new dbInventoryEntities())
{
try
{
var existingVoucherDTL = ctx.tblVoucherDTLs.Where(s => s.intId == voucherDTL.intId)
.FirstOrDefault <tblVoucherDTL>();
if (existingVoucherDTL != null)
{
existingVoucherDTL.intCategory = voucherDTL.intCategory;
existingVoucherDTL.intItemCode = voucherDTL.intItemCode;
existingVoucherDTL.intPieces = voucherDTL.intPieces;
existingVoucherDTL.floatRate = voucherDTL.floatRate;
existingVoucherDTL.floatCommission = voucherDTL.floatCommission;
existingVoucherDTL.floatAmount = voucherDTL.floatAmount;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
return(Ok());
}
