public void InsertUserPlan(int loginid)
        {
            DataTable dtplantype = new DataTable();
            objBL_Common = new BL_Common();
            try
            {
                dtplantype = objBL_Common.plantypedetails("top 1 *", "EC_PlanType", "LOWER(PlanName)='FREE' and IsActive = 1 order by plandate desc");

                if (dtplantype.Rows.Count > 0)
                {
                    objUserPlan = new UserPlan();
                    objBL_UserPlan = new BL_UserPlan();
                    objUserPlan.FK_UserID = loginid;
                    objUserPlan.FK_PlanID = Convert.ToInt32(dtplantype.Rows[0]["PK_PlanID"].ToString());
                    objUserPlan.ActiveFrom = DateTime.Now;
                    objUserPlan.ActiveTo = DateTime.Now.AddMonths(1);
                    objUserPlan.IsActive = true;
                    objUserPlan.CreatedBy = loginid;
                    objUserPlan.CreatedOn = DateTime.Now;
                    objBL_UserPlan.AccessInsertUserPlan(objUserPlan);
                    string[] UPtype = new string[3];
                    UPtype[0] = Convert.ToString(dtplantype.Rows[0]["IsSingleUser"]);
                    UPtype[1] = Convert.ToString(dtplantype.Rows[0]["NOC"]);
                    UPtype[2] = Convert.ToString(dtplantype.Rows[0]["AllowedMails"]);
                    Session["lstUserPlanType"] = UPtype;

                    objUserPlan = null;
                    objBL_UserPlan = null;
                }
            }
            catch (Exception ex)
            {
                New_EmailCampaign.App_Code.GlobalFunction.StoreLog("FreeAccountSignUp.aspx:InsertUserPlan() - " + ex.Message);
            }
        }
 public void InsertUserPlan()
 {
     objUserPlan = new UserPlan();
     objBL_UserPlan = new BL_UserPlan();
     objUserPlan.FK_UserID = Convert.ToInt32(Session["UserID"].ToString());
     objUserPlan.FK_PlanID = Convert.ToInt32(Request.QueryString["PlanID"].ToString());
     objUserPlan.ActiveFrom = DateTime.Now;
     objUserPlan.ActiveTo = DateTime.Now.AddMonths(1);
     objUserPlan.IsActive = true;
     objUserPlan.CreatedBy = Convert.ToInt32(Session["UserID"].ToString());
     objUserPlan.CreatedOn = DateTime.Now;
     objBL_UserPlan.AccessInsertUserPlan(objUserPlan);
     objUserPlan = null;
     objBL_UserPlan = null;
 }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                HttpCookie myCookie = new HttpCookie("myCookie");
                bool IsRemember = chkRememberme.Checked;
                lstUserDetails = new List<UserDetails>();
                lstUserDetails = objBL_UserLoginDetails.SelectUserDetailsforLogin(txtUsername.Value.ToString(), txtpassword.Value.ToString());

                if (lstUserDetails.Count > 0)
                {
                    if (lstUserDetails[0].AccountActivated == true)
                    {
                        if (IsRemember)
                        {
                            myCookie.Values.Add("username", txtUsername.Value);
                            myCookie.Values.Add("password", objCryptographicHashCode.EncryptPlainTextToCipherText(txtpassword.Value));
                            myCookie.Expires = DateTime.Now.AddDays(15);
                            Response.Cookies.Add(myCookie);
                        }
                        else
                        {
                            myCookie.Values.Add("username", string.Empty);
                            myCookie.Values.Add("password", string.Empty);
                            myCookie.Expires = DateTime.Now.AddMinutes(5);
                            Response.Cookies.Add(myCookie);
                        }

                        Session["UserID"] = lstUserDetails[0].PK_UserID;
                        Session["Usertype"] = lstUserDetails[0].UserType;
                        Session["CompanyID"] = lstUserDetails[0].FK_CompanyID;

                        if (lstUserDetails[0].FirstName == "" && lstUserDetails[0].LastName == "")
                            Session["UserName"] = lstUserDetails[0].UserName;
                        else
                            Session["UserName"] = lstUserDetails[0].FirstName + " " + lstUserDetails[0].LastName;

                        if (Session["CompanyID"].ToString() != "")
                            Session["CompanyName"] = objBL_Common.IsValidUser("Company_Name", "EC_Company", "PK_CompanyID =" + Convert.ToInt32(Session["CompanyID"].ToString()) + "");
                        else
                            Session["CompanyName"] = "-";

                        if (Convert.ToInt64(Session["Usertype"].ToString()) == 10)
                        {
                            Response.Redirect("UserPlanTypeDetails.aspx", false);
                            return;
                        }

                        if (lstUserDetails[0].FK_RoleID != null)
                            Session["RoleID"] = lstUserDetails[0].FK_RoleID;

                        if (lstUserDetails[0].UserType == 1)
                        {
                            if (lstUserDetails[0].FK_RoleID == null)
                            {
                                objRole = new Role();
                                objRole.RoleName = "Admin";
                                objRole.CampaignCreate = true;
                                objRole.FK_CompanyID = Convert.ToInt32(Session["CompanyID"].ToString());
                                objRole.MailSend = true;
                                objRole.CreateUser = true;
                                objRole.CampaignDelete = true;
                                objRole.ViewingReports = true;
                                objRole.TemplateView = true;
                                objRole.ListExports = true;
                                objRole.CreatedOn = DateTime.Now;
                                objRole.CreatedBy = Convert.ToInt32(Session["UserID"].ToString());
                                string pkcqid = objBL_Role.AccessInsertRole(objRole);

                                if (pkcqid != "")
                                {
                                    Session["RoleID"] = Convert.ToInt32(pkcqid);
                                    objBL_Common = new BL_Common();
                                    objBL_Common.AccessUpdateAllCampaign("EC_UserLogin", "FK_RoleID = '" + Convert.ToInt32(pkcqid) + "'", "PK_UserID =" + Convert.ToInt32(Session["UserID"].ToString()) + "");
                                    objBL_Common = null;

                                }
                            }
                        }
                        objBL_UserPlan = new BL_UserPlan();
                        lstUserPlan = new List<UserPlan>();
                        lstUserPlan = objBL_UserPlan.GetUserPlanBasedonCompanyID(Convert.ToInt32(Session["CompanyID"].ToString()));

                        if (lstUserPlan.Count <= 0)
                        {
                            InsertUserPlan(Convert.ToInt32(Session["UserID"].ToString()));
                            Response.Redirect("Dashboard.aspx", false);
                        }
                        else
                        {
                            Response.Redirect("Dashboard.aspx", false);
                            DataTable dtplantype = new DataTable();
                            objBL_Common = new BL_Common();
                            dtplantype = objBL_Common.plantypedetails("*", "EC_PlanType", "PK_PlanID = " + Convert.ToInt32(lstUserPlan[0].FK_PlanID.ToString()) + " and IsActive = 1 order by plandate desc");

                            string[] UPtype = new string[3];
                            UPtype[0] = Convert.ToString(dtplantype.Rows[0]["IsSingleUser"]);
                            UPtype[1] = Convert.ToString(dtplantype.Rows[0]["NOC"]);
                            UPtype[2] = Convert.ToString(dtplantype.Rows[0]["AllowedMails"]);
                            Session["lstUserPlanType"] = UPtype;
                        }

                        if (lstUserDetails[0].Email_id != null)
                            Session["AdminEmilid"] = lstUserDetails[0].Email_id;

                        if (lstUserDetails[0].FK_RoleID != 0)
                            roledetails();

                    }
                    else
                        lblerrormsg.Text = "<span style='color:#c85305;font-size:11.5px;'>You have to activate your account from mail sent. Then only you can access your account.</span>";
                }
                else
                    lblerrormsg.Text = "<span style='color:#c85305;font-size:11.5px;'>That account doesn't exist. Enter a different account detail or </span> <a href='FreeAccountSignUp.aspx' style='font-size:11.5px; color: #00acec;'>get a new account</a>";

            }
            catch (Exception ex)
            {
                New_EmailCampaign.App_Code.GlobalFunction.StoreLog("UserLogin.aspx:btnSubmit_Click() - " + ex.Message);
            }
        }