public string SaveMasterInfo(FinishingStockMaster objMaster) { string rv = ""; try { var result = Insert_Update_MasterInfo("sp_insert_finishing_floor_stock_master_info", "SAVE_FINISHING_STOCK_MASTER", objMaster); rv = Operation.Success.ToString(); return(result.Rows[0]["FID"].ToString()); } catch (Exception ex) { rv = ex.Message; } return(rv); }
public DataTable Insert_Update_MasterInfo(string procedure, string callname, FinishingStockMaster objMaster) { dbConn = new SqlConnection(ConnectionString); dbConn.Open(); cmd = new SqlCommand(procedure, dbConn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@call_name", callname)); cmd.Parameters.Add(new SqlParameter("@FID", objMaster.FID)); cmd.Parameters.Add(new SqlParameter("@FDate", objMaster.FDate.ToString("dd-MMM-yyyy"))); cmd.Parameters.Add(new SqlParameter("@Remarks", objMaster.Remarks)); cmd.Parameters.Add(new SqlParameter("@Stock", objMaster.Stock)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public string SaveMasterInfo(FinishingStockMaster objMaster) { return(_service.SaveMasterInfo(objMaster)); }