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