public string GetConnectionString_Client() { try { CurrentInfo objCurInfo = new CurrentInfo(); string connectionString = string.Empty; connectionString = objCurInfo.GetConnectionString(); return(connectionString); } catch (Exception ex) { //System.Web.HttpContext.Current.Response.Write("Exception: " + ex.Message); _strError = "DCRMobile " + " Public_fn:GetConnectionString_Client " + " Stack Trace : " + ex.StackTrace + " Error msg " + ex.Message; throw ex; } }
public DataTable GetTopTenProduct() { DataTable dt = new DataTable(); try { CurrentInfo _objCurrentInfo = new CurrentInfo(); SqlDataAdapter da = new SqlDataAdapter(); SqlConnection con = new SqlConnection(); con.ConnectionString = _objCurrentInfo.GetConnectionString(); con.Open(); SqlCommand Command = new SqlCommand(); Command.Parameters.Clear(); Command.CommandType = CommandType.StoredProcedure; if (_adminDashboard.IsPS) { Command.CommandText = "SP_HD_GetlstTopTenPrimarySalesProduct"; } else { Command.CommandText = "SP_HD_GetlstTopTenSecondarySalesProduct"; } Command.Parameters.AddWithValue("@User_Code", _adminDashboard.UserCode); Command.Parameters.AddWithValue("@Company_Code", _adminDashboard.CompanyCode); Command.Parameters.AddWithValue("@Division_Code", _adminDashboard.DivisionCode); Command.Connection = con; da = new SqlDataAdapter(Command); da.Fill(dt); con.Close(); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("userCode", _adminDashboard.UserCode); Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); return(null); } return(dt); }