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