public DataTable InserOrUpdateRecipe(string procedure, string callname, DyeingProcessRecipe recipe) { 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("@ID", recipe.ID)); cmd.Parameters.Add(new SqlParameter("@SetNo", recipe.SetNo)); cmd.Parameters.Add(new SqlParameter("@RecipeType", recipe.RecipeType)); cmd.Parameters.Add(new SqlParameter("@QuantityGpl", recipe.QuantityGpl)); cmd.Parameters.Add(new SqlParameter("@ItemCode", recipe.ItemCode)); cmd.Parameters.Add(new SqlParameter("@ItemName", recipe.ItemName)); cmd.Parameters.Add(new SqlParameter("@Remark", recipe.Remark)); cmd.Parameters.Add(new SqlParameter("@EntryBy", recipe.EntryBy)); cmd.Parameters.Add(new SqlParameter("@EntryDate", recipe.EntryDate)); cmd.Parameters.Add(new SqlParameter("@UpdateBy", recipe.UpdateBy)); cmd.Parameters.Add(new SqlParameter("@UpdateDate", recipe.UpdateDate)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public DyeingProcessRecipe SaveRecipe(DyeingProcessRecipe recipe) { return(dataService.SaveRecipe(recipe)); }