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));
}
