public long PostAccessories(inventory_adjustment inventory_adjustment)
{
try
{
inventory_adjustment insertInventoryAdjustment = new inventory_adjustment
{
adjustment_type = inventory_adjustment.adjustment_type,
warehouse_id = inventory_adjustment.warehouse_id,
contra_warehouse_id = inventory_adjustment.contra_warehouse_id,
product_id = inventory_adjustment.product_id,
system_quantity = inventory_adjustment.system_quantity,
physical_quantity = inventory_adjustment.physical_quantity,
adjustment_quantity = inventory_adjustment.adjustment_quantity,
status = inventory_adjustment.status,
created_by = inventory_adjustment.created_by,
created_date = inventory_adjustment.created_date,
updated_by = inventory_adjustment.created_by,
updated_date = inventory_adjustment.updated_date
};
_entities.inventory_adjustment.Add(insertInventoryAdjustment);
_entities.SaveChanges();
long last_insert_id = insertInventoryAdjustment.inventory_adjustment_id;
return(last_insert_id);
}
catch (Exception ex)
{
return(0);
}
}
public bool ApproveInventoryAdjustment(long inventory_adjustment_id, long user_id)
{
try
{
inventory_adjustment oInventoryAdjustment = _entities.inventory_adjustment.Find(inventory_adjustment_id);
oInventoryAdjustment.status = "Approved";
oInventoryAdjustment.approve_by = user_id;
oInventoryAdjustment.approve_date = DateTime.Now;
_entities.SaveChanges();
var updateInventoty = new InventoryRepository();
if (oInventoryAdjustment.system_quantity > oInventoryAdjustment.physical_quantity)
{
updateInventoty.UpdateInventory("Inventory Adjustment", "IA-" + oInventoryAdjustment.inventory_adjustment_id + "", oInventoryAdjustment.warehouse_id ?? 0,
oInventoryAdjustment.contra_warehouse_id ?? 0, oInventoryAdjustment.product_id ?? 0, oInventoryAdjustment.color_id ?? 0, oInventoryAdjustment.product_version_id ?? 0, 1,
oInventoryAdjustment.adjustment_quantity ?? 0, user_id);
}
if (oInventoryAdjustment.system_quantity < oInventoryAdjustment.physical_quantity)
{
updateInventoty.UpdateInventory("Inventory Adjustment", "IA-" + oInventoryAdjustment.inventory_adjustment_id + "", oInventoryAdjustment.contra_warehouse_id ?? 0,
oInventoryAdjustment.warehouse_id ?? 0, oInventoryAdjustment.product_id ?? 0, oInventoryAdjustment.color_id ?? 0, oInventoryAdjustment.product_version_id ?? 0, 1,
Math.Abs(oInventoryAdjustment.adjustment_quantity ?? 0), user_id);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeleteInventoryAdjustment(long inventory_adjustment_id)
{
try
{
inventory_adjustment oInventoryAdjustment = _entities.inventory_adjustment.Find(inventory_adjustment_id);
_entities.inventory_adjustment.Attach(oInventoryAdjustment);
_entities.inventory_adjustment.Remove(oInventoryAdjustment);
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool PutAccessories(inventory_adjustment inventory_adjustment)
{
try
{
inventory_adjustment editInventoryAdjustment = _entities.inventory_adjustment.Find(inventory_adjustment.inventory_adjustment_id);
editInventoryAdjustment.warehouse_id = inventory_adjustment.warehouse_id;
editInventoryAdjustment.contra_warehouse_id = inventory_adjustment.contra_warehouse_id;
editInventoryAdjustment.product_id = inventory_adjustment.product_id;
editInventoryAdjustment.system_quantity = inventory_adjustment.system_quantity;
editInventoryAdjustment.physical_quantity = inventory_adjustment.physical_quantity;
editInventoryAdjustment.adjustment_quantity = inventory_adjustment.adjustment_quantity;
editInventoryAdjustment.status = inventory_adjustment.status;
editInventoryAdjustment.created_by = inventory_adjustment.created_by;
editInventoryAdjustment.created_date = inventory_adjustment.created_date;
editInventoryAdjustment.updated_by = inventory_adjustment.created_by;
editInventoryAdjustment.updated_date = inventory_adjustment.updated_date;
_entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public HttpResponseMessage PostAccessories([FromBody] Models.inventory_adjustment inventory_adjustment)
{
try
{
if (string.IsNullOrEmpty(inventory_adjustment.warehouse_id.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Select Warehouse"
}, formatter));
}
if (string.IsNullOrEmpty(inventory_adjustment.contra_warehouse_id.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Select Contra Warehouse"
}, formatter));
}
if (string.IsNullOrEmpty(inventory_adjustment.product_id.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Select Product"
}, formatter));
}
if (string.IsNullOrEmpty(inventory_adjustment.physical_quantity.ToString()))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Physical Count is empty !!"
}, formatter));
}
else
{
inventory_adjustment insertInventoryAdjustment = new inventory_adjustment
{
adjustment_type = "Accessories",
warehouse_id = inventory_adjustment.warehouse_id,
contra_warehouse_id = inventory_adjustment.contra_warehouse_id,
product_id = inventory_adjustment.product_id,
system_quantity = inventory_adjustment.system_quantity,
physical_quantity = inventory_adjustment.physical_quantity,
adjustment_quantity = inventory_adjustment.adjustment_quantity,
status = "Created",
created_by = inventory_adjustment.created_by,
created_date = DateTime.Now,
updated_by = inventory_adjustment.created_by,
updated_date = DateTime.Now
};
var x = inventoryAdjustmentRepository.PostAccessories(insertInventoryAdjustment);
if (x == 0)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Error !!"
}, formatter));
}
else
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Saved successfully"
}, formatter));
}
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
