public void BindSalesID()
{
// Find Label on MasterPage
var lbl_masterSalesID = (Label)Master.FindControl("lbl_masterSalesID");
var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
var cmd = new SqlCommand("SELECT * FROM tbl_SalesMaster WHERE aspnetId = @aspnetId", sqlConn);
cmd.Parameters.Add("@aspnetId", SqlDbType.VarChar, 255).Value = FetchUser.UserID();
cmd.Connection.Open();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
lbl_masterSalesID.Text = rdr["SalesID"].ToString();
Session["SalesID"] = rdr["SalesID"].ToString();
}
cmd.Connection.Close();
cmd.Connection.Dispose();
}
//// END DATALIST EVENTS ////
//// BEGIN BUTTONS ////
protected void btn_UserImage_Click(object sender, EventArgs e)
{
if (upl_userimage.HasFile)
{
var op = new ImageOptimizer();
op.ImgQuality = 80;
op.MaxHeight = 150;
op.MaxWidth = 150;
Bitmap bmp = ResizeImage(upl_userimage.PostedFile.InputStream, 150, 150);
bmp.Save(Server.MapPath("~/Images/Users/" + FetchUser.UserID() + "/user_defined.jpg"), ImageFormat.Jpeg);
op.Optimize(Server.MapPath("~/Images/Users/" + FetchUser.UserID() + "/user_defined.jpg"));
// Reload Page
Response.Redirect("ManageOrg.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Get UserID from Session
string sUserID = Session["UserID"].ToString();
// Get ASP.NET User ID from Membership
string saspnetID = FetchUser.UserID();
string MergeAccountSQL = "UPDATE tbl_UsersMaster SET aspnetID = '" + saspnetID + "' WHERE UserID = '" +
sUserID + "'";
var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
var cmd = new SqlCommand(MergeAccountSQL, sqlConn);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
Response.Redirect("/Catch.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
// First Load Events
if (!IsPostBack)
{
// Failsafe for losing OrgID
if (Session["OrgID"] == null)
{
Response.Redirect("Default.aspx");
}
BindOrg();
}
// Check for image in User Links folder
string imgDisplayPath = Server.MapPath("~/Images/Users/" + FetchUser.UserID() + "/user_defined.jpg");
if (File.Exists(imgDisplayPath))
{
// Set Image Control URL
img_user.ImageUrl = "~/Images/Users/" + FetchUser.UserID() + "/user_defined.jpg";
}
}
//// GET ORGID WITH LEADERS ASPNET EMAIL ////
protected void GetOrgId()
{
// Instantiate SQL String
string SelectOrgIDSQL;
// Select SQL
SelectOrgIDSQL = "SELECT UserID, OrgID FROM tbl_UsersMaster WHERE UserEmail ='" + FetchUser.UserEmail() +
"'";
// Use SQL Statement to Select Records from DB
var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
var cmd = new SqlCommand(SelectOrgIDSQL, sqlConn);
cmd.Connection.Open();
SqlDataReader OrgIdRdr;
OrgIdRdr = cmd.ExecuteReader();
while (OrgIdRdr.Read())
{
string sOrgID = OrgIdRdr["OrgID"].ToString();
lbl_OrgID.Text = sOrgID;
// Set Session
Session["OrgID"] = sOrgID;
string sUserID = OrgIdRdr["UserID"].ToString();
// Set Session
Session["UserID"] = sUserID;
}
cmd.Connection.Close();
cmd.Connection.Dispose();
}
