static public DataSet Select(string query, DataLinkCon dlc) { SqlConnection con = null; if (dlc == DataLinkCon.mgmuser) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mgmdb"].ToString()); } if (dlc == DataLinkCon.bpss) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["bpss"].ToString()); } SqlCommand cmd = new SqlCommand(query, con); SqlDataAdapter da; DataSet ds = new DataSet(); using (con) { try { con.Open(); da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); } catch (SqlException ex) { System.Console.WriteLine(ex.ToString()); return(null); } } }
/// <summary> /// Logs that this user opened Rep Portal. /// </summary> /// <param name="sUserName"></param> protected void WriteToLog(string sUserName) { string sSql = "INSERT INTO LogUserActivity(UserName) " + Environment.NewLine + "VALUES ('" + sUserName + "')"; DataLinkCon dlc = DataLinkCon.mgmuser; DataLink.Update(sSql, dlc); }
static public int EmailPendingExists(int iEmailID, DataLinkCon dlc) { int iRetValue = -1; SqlConnection con = null; if (dlc == DataLinkCon.mgmuser) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mgmdb"].ToString()); } if (dlc == DataLinkCon.bpss) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["bpss"].ToString()); } SqlCommand cmd = new SqlCommand("select QuoteEmailID from EmailPendingLog where QuoteEmailID = " + iEmailID, con); SqlDataAdapter da; DataSet ds = new DataSet(); using (con) { try { con.Open(); da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { iRetValue = Convert.ToInt32(dr["Attempts"]); } } } } catch (SqlException ex) { System.Console.WriteLine(ex.ToString()); iRetValue = -1; } } return(iRetValue); }
static public bool Update(string qry, DataLinkCon dlc) { SqlConnection con = new SqlConnection(); int iRowsAffected = 0; if (dlc == DataLinkCon.mgmuser) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mgmdb"].ToString()); } if (dlc == DataLinkCon.bpss) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["bpss"].ToString()); } SqlCommand cmd = new SqlCommand(qry, con); using (con) { try { con.Open(); iRowsAffected = cmd.ExecuteNonQuery(); if (iRowsAffected == 0) { return(false); } else { return(true); } } catch (SqlException ex) { return(false); } } }
static public bool ProcNoReturn(string sProcName, List <SqlParameter> lstParams, DataLinkCon dlc) { SqlConnection con = new SqlConnection(); int iRowsAffected = 0; if (dlc == DataLinkCon.mgmuser) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mgmdb"].ToString()); } if (dlc == DataLinkCon.bpss) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["bpss"].ToString()); } SqlCommand cmd = new SqlCommand(sProcName, con); cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter s in lstParams) { cmd.Parameters.Add(s); } using (con) { try { con.Open(); iRowsAffected = cmd.ExecuteNonQuery(); if (iRowsAffected == 0) { return(false); } else { return(true); } } catch (SqlException ex) { return(false); } } }
static public DataSet StoredProcSelect(string sName, List <SqlParameter> lstParams, DataLinkCon dlc) { SqlConnection con = new SqlConnection(); if (dlc == DataLinkCon.mgmuser) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mgmdb"].ToString()); } if (dlc == DataLinkCon.bpss) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["bpss"].ToString()); } string strSql = sName; SqlCommand comd = new SqlCommand(strSql, con); comd.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); foreach (SqlParameter param in lstParams) { comd.Parameters.Add(param); } try { con.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = comd; sda.Fill(ds); con.Close(); } catch (Exception ex) { System.Console.Write(ex.Message); } finally { } return(ds); }