public bool AddMRecipeMain(MRecipeMain RecipeMain) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMRecipeMain"; cmd.Parameters.AddWithValue("@MRecipeID", RecipeMain.MRecipeID); cmd.Parameters.AddWithValue("@DocNo", RecipeMain.DocNo); cmd.Parameters.AddWithValue("@ESFlag", RecipeMain.ESFlag); cmd.Parameters.AddWithValue("@GroupNo ", RecipeMain.GroupNo); cmd.Parameters.AddWithValue("@FinishItemID", RecipeMain.FinishItemID); cmd.Parameters.AddWithValue("@PackingSize", RecipeMain.PackingSize); cmd.Parameters.AddWithValue("@RDate", RecipeMain.RDate); cmd.Parameters.AddWithValue("@Qty", RecipeMain.Qty); cmd.Parameters.AddWithValue("@ProdQty", RecipeMain.ProdQty); cmd.Parameters.AddWithValue("@UomNo", RecipeMain.UomNo); cmd.Parameters.AddWithValue("@RecipeType", RecipeMain.RecipeType); cmd.Parameters.AddWithValue("@FkRecipeID", RecipeMain.FkRecipeID); cmd.Parameters.AddWithValue("@IsLock", RecipeMain.IsLock); cmd.Parameters.AddWithValue("@IsActive", RecipeMain.IsActive); cmd.Parameters.AddWithValue("@UserID", RecipeMain.UserID); cmd.Parameters.AddWithValue("@UserDate", RecipeMain.UserDate); SqlParameter outParameter = new SqlParameter(); outParameter.ParameterName = "@ReturnID"; outParameter.Direction = ParameterDirection.Output; outParameter.DbType = DbType.Int32; cmd.Parameters.Add(outParameter); commandcollection.Add(cmd); return(true); }
public MRecipeMain ModifyMRecipeMainByID(long ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from MRecipeMain where MRecipeID =" + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { MRecipeMain MM = new MRecipeMain(); while (dr.Read()) { MM.MRecipeID = Convert.ToInt32(dr["MRecipeID"]); if (!Convert.IsDBNull(dr["DocNo"])) { MM.DocNo = Convert.ToInt64(dr["DocNo"]); } if (!Convert.IsDBNull(dr["ESFlag"])) { MM.ESFlag = Convert.ToBoolean(dr["ESFlag"]); } if (!Convert.IsDBNull(dr["GroupNo"])) { MM.GroupNo = Convert.ToInt64(dr["GroupNo"]); } if (!Convert.IsDBNull(dr["FinishItemID"])) { MM.FinishItemID = Convert.ToInt64(dr["FinishItemID"]); } if (!Convert.IsDBNull(dr["PackingSize"])) { MM.PackingSize = Convert.ToInt64(dr["PackingSize"]); } if (!Convert.IsDBNull(dr["RDate"])) { MM.RDate = Convert.ToDateTime(dr["RDate"]); } if (!Convert.IsDBNull(dr["Qty"])) { MM.Qty = Convert.ToDouble(dr["Qty"]); } if (!Convert.IsDBNull(dr["ProdQty"])) { MM.ProdQty = Convert.ToDouble(dr["ProdQty"]); } if (!Convert.IsDBNull(dr["UomNo"])) { MM.UomNo = Convert.ToInt64(dr["UomNo"]); } if (!Convert.IsDBNull(dr["RecipeType"])) { MM.RecipeType = Convert.ToInt64(dr["RecipeType"]); } if (!Convert.IsDBNull(dr["FkRecipeID"])) { MM.FkRecipeID = Convert.ToInt64(dr["FkRecipeID"]); } if (!Convert.IsDBNull(dr["IsLock"])) { MM.IsLock = Convert.ToBoolean(dr["IsLock"]); } if (!Convert.IsDBNull(dr["IsActive"])) { MM.IsActive = Convert.ToBoolean(dr["IsActive"]); } if (!Convert.IsDBNull(dr["UserID"])) { MM.UserID = Convert.ToInt64(dr["UserID"]); } if (!Convert.IsDBNull(dr["UserDate"])) { MM.UserDate = Convert.ToDateTime(dr["UserDate"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new MRecipeMain()); }