public DataTable Search(mdlModulesList obj_mdlModulesList) { DataTable dt = new DataTable(); dt = obj_dalModulesList.Search(obj_mdlModulesList); return dt; }
public bool UpdateModulesList(mdlModulesList obj_mdlModulesList) { Updated = obj_dalModulesList.UpdateModulesList(obj_mdlModulesList); return Updated; }
public bool InsertModulesList(mdlModulesList obj_mdlModulesList) { Inserted = obj_dalModulesList.InsertModulesList(obj_mdlModulesList); return Inserted; }
public int GetMaxID(mdlModulesList obj_mdlModulesList) { int CountID = 0; return CountID = obj_dalModulesList.GetMaxID(obj_mdlModulesList); }
public bool UpdateModulesList(mdlModulesList obj_mdlModulesList) { bool Updated = false; try { SqlCommand cmd = new SqlCommand("stp_ERP_ModulesList_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ModuleID", SqlDbType.Int).Value = obj_mdlModulesList.ModuleID; cmd.Parameters.Add("@ModuleName", SqlDbType.VarChar, 100).Value = obj_mdlModulesList.ModuleName; cmd.Parameters.Add("@ModuleType", SqlDbType.VarChar, 20).Value = obj_mdlModulesList.ModuleType; cmd.Parameters.Add("@ModuleCategory", SqlDbType.VarChar, 50).Value = obj_mdlModulesList.ModuleCategory; cmd.Parameters.Add("@FormName", SqlDbType.VarChar, 100).Value = obj_mdlModulesList.FormName; cmd.Parameters.Add("@Discontinued", SqlDbType.Bit).Value = obj_mdlModulesList.IsDiscontinued; if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); cmd.ExecuteNonQuery(); if (conn.State == ConnectionState.Open) { conn.Close(); Updated = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); if (conn.State == ConnectionState.Open) { conn.Close(); } } return Updated; }
public DataTable Search(mdlModulesList obj_mdlModulesList) { DataTable dt = new DataTable(); try { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); SqlDataAdapter ad = new SqlDataAdapter("stp_ERP_ModulesList_Select", conn); ad.SelectCommand.CommandType = CommandType.StoredProcedure; ad.SelectCommand.Parameters.Add("@ModuleID", SqlDbType.Int).Value = obj_mdlModulesList.ModuleID; ad.Fill(dt); if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); if (conn.State == ConnectionState.Open) { conn.Close(); } } return dt; }
public int GetMaxID(mdlModulesList obj_mdlModulesList) { int CountID = 0; try { SqlCommand cmd = new SqlCommand("SELECT COALESCE(MAX(ModuleID), 0) FROM M_ERP_ModulesList", conn); if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); CountID = Convert.ToInt32(cmd.ExecuteScalar()) + 1; if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); if (conn.State == ConnectionState.Open) { conn.Close(); } } return CountID; }