public List <StockMasterDto> GetAndEditStockMaster(int StockId, int IsActive)
{
List <StockMasterDto> lstStockMasterDto = new List <StockMasterDto>();
SqlCommand cmd = new SqlCommand("GetAndEditStockMaster", connectionRepository.con);
cmd.Parameters.AddWithValue("@StockId", StockId);
cmd.Parameters.AddWithValue("@IsActive", IsActive);
cmd.CommandType = CommandType.StoredProcedure;
connectionRepository.con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StockMasterDto stockMasterDto = new StockMasterDto();
stockMasterDto.StockId = Convert.ToInt32(dr["StockId"]);
stockMasterDto.GroupId = Convert.ToInt32(dr["GroupId"]);
stockMasterDto.GroupName = Convert.ToString(dr["GroupName"]);
stockMasterDto.CategoryId = Convert.ToInt32(dr["CategoryId"]);
stockMasterDto.CategoryName = Convert.ToString(dr["CategoryName"]);
stockMasterDto.ItemId = Convert.ToInt32(dr["ItemId"]);
stockMasterDto.ItemName = Convert.ToString(dr["ItemName"]);
stockMasterDto.ItemImage = Convert.ToString(dr["ItemImage"]);
stockMasterDto.Quantity = Convert.ToInt32(dr["Quantity"]);
stockMasterDto.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
stockMasterDto.CreatedDate = Convert.ToString(dr["CreatedDate"]);
stockMasterDto.ModifiedBy = Convert.ToInt32(dr["ModifiedBy"] != DBNull.Value ? dr["ModifiedBy"] : 0);
stockMasterDto.ModifiedDate = Convert.ToString(dr["ModifiedDate"] != DBNull.Value ? dr["ModifiedDate"] : "");
stockMasterDto.IsActive = Convert.ToInt32(dr["IsActive"]);
lstStockMasterDto.Add(stockMasterDto);
}
connectionRepository.con.Close();
return(lstStockMasterDto);
}
public ActionResult SaveStockMaster(StockMasterDto stockMasterDto)
{
StockMasterDal stockMasterDal = new StockMasterDal();
stockMasterDto.CreatedBy = Convert.ToInt32(Session["AdminId"]);
stockMasterDto.ModifiedBy = Convert.ToInt32(Session["AdminId"]);
stockMasterDto.IsActive = 1;
int i = stockMasterDal.SaveStockMaster(stockMasterDto);
return(Json(i, JsonRequestBehavior.AllowGet));
}
public int SaveStockMaster(StockMasterDto stockMasterDto)
{
try
{
SqlCommand cmd = new SqlCommand("SaveAndUpdateStockMaster", connectionRepository.con);
cmd.Parameters.AddWithValue("@StockId", stockMasterDto.StockId);
cmd.Parameters.AddWithValue("@GroupId", stockMasterDto.GroupId);
cmd.Parameters.AddWithValue("@CategoryId", stockMasterDto.CategoryId);
cmd.Parameters.AddWithValue("@ItemId", stockMasterDto.ItemId);
cmd.Parameters.AddWithValue("@Quantity", stockMasterDto.Quantity);
cmd.Parameters.AddWithValue("@CreatedBy", stockMasterDto.CreatedBy);
cmd.Parameters.AddWithValue("@ModifiedBy", stockMasterDto.ModifiedBy);
cmd.Parameters.AddWithValue("@IsActive", stockMasterDto.IsActive);
cmd.CommandType = CommandType.StoredProcedure;
connectionRepository.con.Open();
int i = cmd.ExecuteNonQuery();
connectionRepository.con.Close();
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
