public SavedProductResult SaveSubDealerProducts(int PackageId, int Quantity, int SubDealerId) { SqlConnection connection; SqlCommand command = new SqlCommand(); int flag = 0; connection = new SqlConnection(connetionString); SavedProductResult objDataObject = new SavedProductResult(); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "Usp_SaveSubDealerProducts"; command.Parameters.AddWithValue("@StockId", 0); command.Parameters.AddWithValue("@PackageId", PackageId); command.Parameters.AddWithValue("@Quantity", Quantity); command.Parameters.AddWithValue("@SubDealerId", SubDealerId); flag = (int)command.ExecuteScalar(); if (flag > 0) { objDataObject.Status = 1; objDataObject.StockQty = flag; objDataObject.Msg = "Products have been added successfully to stock."; } else { objDataObject.Status = 0; objDataObject.StockQty = 0; objDataObject.Msg = "Issue Occurred, Please try again!!"; } command.Parameters.Clear(); LogDal.MethodCallLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, SubDealerId); } connection.Close(); return(objDataObject); }
public SavedProductResult SaveSubDealerProducts(SubDealerProductCreate obj) { ReasonStatusBal _rsbal = new ReasonStatusBal(); SavedProductResult objSavedData = new SavedProductResult(); int flag = 0; Dictionary <string, int> returndata = new Dictionary <string, int>(); returndata.Add("status", 0); try { objSavedData = _rsbal.SaveSubDealerProducts(obj); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, obj.StockId); } return(objSavedData); }
public SavedProductResult SaveSubDealerProducts(SubDealerProductCreate obj) { SavedProductResult objCreateData = _rsdal.SaveSubDealerProducts(obj.PackageId, obj.Quantity, obj.SubDealerId); return(objCreateData); }