public async Task <HttpResponseMessage> Post([FromBody] InvStockProductRegistrationModel mInvStockProductRegistrationModel) { var formatter = RequestFormat.JsonFormaterString(); string msg = ""; try { if (mInvStockProductRegistrationModel.Id == 0) { if (mInvStockProductRegistrationModel.ProductName == "") { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = "Product Name is Empty" }, formatter)); } else if (mInvStockProductRegistrationModel.ProductCategory == 0) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = "Please Select Product Category" }, formatter)); } else if (mInvStockProductRegistrationModel.Unit == "") { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = " Unit is Empty" }, formatter)); } else { msg = await _gtInvStokeProductRegistrationGatway.Save(mInvStockProductRegistrationModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "success", Msg = msg }, formatter)); } } else { msg = await _gtInvStokeProductRegistrationGatway.Update(mInvStockProductRegistrationModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "Update success", Msg = msg }, formatter)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = ex.ToString() }, formatter)); } }
public Task <string> Update(InvStockProductRegistrationModel aModel) { try { string msg = ""; const string query = @"Update tbl_INVSTOCK_SalesProductList SET ProductName=@ProductName,ProductCategoryId=@ProductCategoryId,Unit=@Unit,Valid=@Valid,UserName=@UserName , RackNumber=@RackNumber, cellNumber=@cellNumber, DepreciationMethodId=@DepreciationMethodId, DepreciationAmount=@DepreciationAmount, DepreciationAmountType=@DepreciationAmountType, AssetType=@AssetType, MinimumQuantity=@MinimumQuantity, EconomicQuantity=@EconomicQuantity Where Id=@Id"; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Id", aModel.Id); cmd.Parameters.AddWithValue("@ProductName", aModel.ProductName); cmd.Parameters.AddWithValue("@ProductCategoryId", aModel.ProductCategory); cmd.Parameters.AddWithValue("@Unit", aModel.Unit); cmd.Parameters.AddWithValue("@Valid", 1); cmd.Parameters.AddWithValue("@UserName", aModel.UserName); cmd.Parameters.AddWithValue("@RackNumber", aModel.rackNumber); cmd.Parameters.AddWithValue("@cellNumber", aModel.cellNumber); cmd.Parameters.AddWithValue("@DepreciationMethodId", aModel.DepreciationMethodId); cmd.Parameters.AddWithValue("@DepreciationAmount", aModel.DepreciationAmount); cmd.Parameters.AddWithValue("@DepreciationAmountType", aModel.DepreciationAmountType); cmd.Parameters.AddWithValue("@AssetType", aModel.AssetType); cmd.Parameters.AddWithValue("@MinimumQuantity", aModel.MinimumQuantity); cmd.Parameters.AddWithValue("@EconomicQuantity", aModel.EconomicQuantity); int rtn = cmd.ExecuteNonQuery(); msg = rtn == 1 ? "Saved Success" : "Saved Failed"; Con.Close(); // return msg; return(Task.FromResult(msg)); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(Task.FromResult(exception.Message)); } }