public int Update_In(int Id, ItemInVM itemInVM)
{
var query = "SP_Update_Item";
parameters.Add("@sp_id", Id);
parameters.Add("@sp_name", itemInVM.Name);
parameters.Add("@sp_type", itemInVM.Type);
parameters.Add("@sp_stock", itemInVM.Stock);
parameters.Add("@sp_info", itemInVM.Information);
parameters.Add("@sp_status", itemInVM.Status);
parameters.Add("@sp_brand_id", itemInVM.Brand_id);
parameters.Add("@sp_sup_id", itemInVM.Supplier_id);
parameters.Add("@sp_updatedate", itemInVM.UpdateDate);
var post = _connectionString.Connections.Execute(query, parameters, commandType: CommandType.StoredProcedure);
var query2 = "SP_Insert_IncomingItem";
parameters.Add("@sp_name", itemInVM.Name);
parameters.Add("@sp_stock", itemInVM.Temp);
parameters.Add("@sp_info", itemInVM.Information);
parameters.Add("@sp_date", DateTime.Now);
parameters.Add("@sp_item_id", Id);
parameters.Add("@sp_isdelete", false);
var post2 = _connectionString.Connections.Execute(query2, parameters, commandType: CommandType.StoredProcedure);
if (post > 0 && post2 > 0)
{
return(1);
}
return(0);
}
public ActionResult Put(int Id, ItemInVM itemInVM)
{
var get = _itemRepository.Get(Id);
var read = get.Result.Stock;
itemInVM.Update();
if (read < itemInVM.Stock)
{
itemInVM.Temp = itemInVM.Stock - read;
var put_in = _itemRepository.Update_In(Id, itemInVM);
if (put_in > 0)
{
return(Ok("Update Success In"));
}
}
else if (read > itemInVM.Stock)
{
itemInVM.Temp = read - itemInVM.Stock;
var put_out = _itemRepository.Update_Out(Id, itemInVM);
if (put_out > 0)
{
return(Ok("Update Success Out"));
}
}
return(BadRequest("Update Failed"));
}
public ActionResult Multiple_Post(ItemInVM itemInVM)
{
itemInVM.Create();
var create = _itemRepository.Multiple_Post(itemInVM);
if (create > 0)
{
return(Ok(create + " data has been created"));
}
return(BadRequest());
}
public JsonResult Edit_In_Out(int Id, ItemInVM item)
{
var myContent = JsonConvert.SerializeObject(item);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var ByteContent = new ByteArrayContent(buffer);
ByteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var update = client.PutAsync("Items/Update_InOut/" + Id, ByteContent).Result;
return(Json(new { data = update }));
}
public int Multiple_Post(ItemInVM itemInVM)
{
var query = "SP_Insert_Item";
parameters.Add("@sp_name", itemInVM.Name);
parameters.Add("@sp_type", itemInVM.Type);
parameters.Add("@sp_stock", itemInVM.Stock);
parameters.Add("@sp_info", itemInVM.Information);
parameters.Add("@sp_status", itemInVM.Status);
parameters.Add("@sp_brand_id", itemInVM.Brand_id);
parameters.Add("@sp_sup_id", itemInVM.Supplier_id);
parameters.Add("@sp_createdate", itemInVM.CreateDate);
var post = _connectionString.Connections.Execute(query, parameters, commandType: CommandType.StoredProcedure);
var queryget = "SP_Retrive_Id_ByItem";
parameters.Add("@sp_name", itemInVM.Name);
parameters.Add("@sp_type", itemInVM.Type);
parameters.Add("@sp_stock", itemInVM.Stock);
var get = _connectionString.Connections.Query <Item>(queryget, parameters, commandType: CommandType.StoredProcedure).SingleOrDefault();
var query2 = "SP_Insert_IncomingItem";
parameters.Add("@sp_name", itemInVM.Name);
parameters.Add("@sp_stock", itemInVM.Stock);
parameters.Add("@sp_info", itemInVM.Information);
parameters.Add("@sp_date", DateTime.Now);
parameters.Add("@sp_item_id", get.Id);
var post2 = _connectionString.Connections.Execute(query2, parameters, commandType: CommandType.StoredProcedure);
if (post > 0 && post2 > 0)
{
return(1);
}
return(0);
}
