public bool SaveUpdateWareHouse(mdlWareHouse obMdlWareHouse, string operation)
{
return objDalWareHouse.SaveUpdateWareHouse(obMdlWareHouse, operation);
}
public bool SaveUpdateWareHouse(mdlWareHouse objMdlWareHouse, string operation)
{
bool isSuccess;
try
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
SqlCommand cmd = new SqlCommand("stp_ERP_WareHouse_CRUD", con);
cmd.Parameters.Add("@WHID", SqlDbType.VarChar, 6).Value = objMdlWareHouse.WHID;
cmd.Parameters.Add("@WHName", SqlDbType.VarChar, 50).Value = objMdlWareHouse.WHName;
cmd.Parameters.Add("@Description", SqlDbType.VarChar, 100).Value = objMdlWareHouse.WHdescription;
cmd.Parameters.Add("@Discontinue", SqlDbType.Bit).Value = objMdlWareHouse.IsDiscontinue;
switch (operation)
{
case "Save":
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "Save";
break;
case "Update":
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "Update";
break;
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
isSuccess = true;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
isSuccess = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return isSuccess;
}
