protected void Page_Load(object sender, EventArgs e) { if (ClaimsPrincipal.Current.Identity.IsAuthenticated == false) { Response.Redirect("~/Account/Login.aspx"); } else { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); UserModel lUserModel; lUserModel = CommonClass.Get_External_User_Profile(dbconn); bool lRedirect = false; if (lUserModel.Email_Address_Validated == 0 || lUserModel.Mobile_Validated == 0) { lRedirect = true; } dbconn.Close(); if (lRedirect) { Response.Redirect("~/Account/Validate.aspx"); } } if (!IsPostBack) { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); AddressBook1.Load_Address(dbconn, true); dbconn.Close(); } }
protected void Link_Command(object sender, CommandEventArgs e) { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); if (e.CommandArgument.ToString() == "0") { Bind_User_Profile(dbconn); MultiView1.SetActiveView(Profile_View); } else if (e.CommandArgument.ToString() == "1") { AddressBook1.Load_Address(dbconn); MultiView1.SetActiveView(Address_View); } else if (e.CommandArgument.ToString() == "2") { SqlDataSource1.EnableCaching = false; SqlDataSource1.SelectParameters["P_EXTERNAL_USER_ID"].DefaultValue = ClaimsPrincipal.Current.FindFirst("user_id").Value; SqlDataSource1.DataBind(); Order_ListView.DataBind(); MultiView1.SetActiveView(Orders_View); } dbconn.Close(); }
public void Prepare_Order_Form() { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); Populate_Products(dbconn); Show_Active_Promotion(dbconn); AddressBook1.Load_Address(dbconn, true); //AddressBook1.Load_Address(dbconn); if (Store_Place_Holder.Visible == false) { PAYMENT_TYPE_ID.Value = WalletPaymentType; ORDER_STATUS.Value = "Open"; } Payment_Received_Flag.ClearSelection(); Payment_Type.ClearSelection(); Delivery_Method.ClearSelection(); Calculate_Grand_Total(); Payment_Received_Information.Visible = false; PaymentControl1.Prepare_Payment_Form(dbconn); PaymentControl1.Clear_Cheque_Details(); dbconn.Close(); if (OrderLoad != null) { OrderLoad(this, EventArgs.Empty); } }
protected void Address_Book_Button_Click(object sender, EventArgs e) { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); AddressBook1.Set_User_Id = CustomerId.Value; AddressBook1.Load_Address(dbconn); dbconn.Close(); MultiView2.SetActiveView(Address_View); }
protected void CheckOut_Button_Click(object sender, EventArgs e) { //Check_Out_Message.Visible = false; Checkout_Message_PlaceHolder.Visible = false; if (Cart_Details_Repeater.Items.Count != 0) { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); if (ClaimsPrincipal.Current.Identity.IsAuthenticated == false) { dbconn.Close(); Response.Redirect("~/Account/Login.aspx"); } else { UserModel lUserModel; lUserModel = CommonClass.Get_External_User_Profile(dbconn); bool lRedirect = false; if (lUserModel.Email_Address_Validated == 0 || lUserModel.Mobile_Validated == 0) { lRedirect = true; } if (lRedirect) { dbconn.Close(); Response.Redirect("~/Account/Validate.aspx"); } } foreach (RepeaterItem lRepeaterItem in Cart_Details_Repeater.Items) { ShoppingCartClass.Update_Shopping_Cart(dbconn, int.Parse((lRepeaterItem.FindControl("PRODUCT_ID") as HiddenField).Value), double.Parse((lRepeaterItem.FindControl("MEASUREMENT_UNIT") as HiddenField).Value), int.Parse((lRepeaterItem.FindControl("OLD_QUANTITY") as HiddenField).Value), int.Parse((lRepeaterItem.FindControl("Quantity") as TextBox).Text), double.Parse((lRepeaterItem.FindControl("PRICE") as HiddenField).Value)); } AddressBook1.Load_Address(dbconn, true); dbconn.Close(); Change_View("Personal_Info"); MultiView1.SetActiveView(AddressBook_View); } else { Checkout_Message_PlaceHolder.Visible = true; //Check_Out_Message.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); ShoppingCartClass.Create_Shopping_Cart(dbconn); //Load_States(dbconn); Load_Shopping_Cart(dbconn, Cart_Details_Repeater); AddressBook1.Load_Address(dbconn, true); dbconn.Close(); Change_View("Order_Info"); } }
protected void Page_Load(object sender, EventArgs e) { if (ClaimsPrincipal.Current.Identity.IsAuthenticated == false) { Response.Redirect("~/Account/Login.aspx"); } if (!IsPostBack) { MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring); dbconn.Open(); AddressBook1.Load_Address(dbconn); dbconn.Close(); } }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "alpha" || e.CommandName == "NoFilter") { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}%", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } ObjectDataSource1.SelectParameters["LastName"].DefaultValue = value; ObjectDataSource1.DataBind(); RadGrid1.Rebind(); } else if (e.CommandName == "QuickUpdate") { string UserName, Role; var oUser = new User(); foreach (GridDataItem item in RadGrid1.Items) { UserName = item.GetDataKeyValue("UserName").ToString(); Role = ((RadComboBox)item.FindControl("ddlRole")).SelectedValue; oUser.ChangeRole(UserName, Role); } } else if (e.CommandName == "DeleteSelected") { var oAddressBook1 = new AddressBook1(); var oUser = new User(); string errorList = "", UserName = ""; foreach (GridDataItem item in RadGrid1.SelectedItems) { try { var AddressBookID = item.GetDataKeyValue("AddressBookID").ToString(); UserName = item["UserName"].Text; oAddressBook1.AddressBook1Delete(AddressBookID); oUser.UserDelete(UserName); } catch (Exception ex) { lblError.Text = ex.Message; if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString()) { errorList += ", " + UserName; } } } if (!string.IsNullOrEmpty(errorList)) { e.Canceled = true; string strAlertMessage = "Tài khoản <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang có đơn hàng .<br /> Xin xóa đơn hàng hoặc sử dụng chức năng khoá tài khoản."; lblError.Text = strAlertMessage; } RadGrid1.Rebind(); } else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { try { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var DistrictID = ((RadComboBox)row.FindControl("ddlDistrict")).SelectedValue; var ProvinceID = ((RadComboBox)row.FindControl("ddlProvince")).SelectedValue; var RoleName = ((RadComboBox)row.FindControl("ddlRole")).SelectedValue; var UserName = ((RadTextBox)row.FindControl("txtUserName")).Text; var IsPrimary = "True"; var CountryID = "1"; var oUser = new User(); if (e.CommandName == "PerformInsert") { var insertParams = ObjectDataSource1.InsertParameters; insertParams["CountryID"].DefaultValue = CountryID; insertParams["ProvinceID"].DefaultValue = ProvinceID; insertParams["DistrictID"].DefaultValue = DistrictID; insertParams["RoleName"].DefaultValue = RoleName; insertParams["IsPrimary"].DefaultValue = IsPrimary; oUser.ChangeRole(UserName, RoleName); } else { var updateParams = ObjectDataSource1.UpdateParameters; updateParams["CountryID"].DefaultValue = CountryID; updateParams["ProvinceID"].DefaultValue = ProvinceID; updateParams["DistrictID"].DefaultValue = DistrictID; updateParams["RoleName"].DefaultValue = RoleName; updateParams["IsPrimary"].DefaultValue = IsPrimary; oUser.ChangeRole(UserName, RoleName); } } catch (Exception ex) { lblError.Text = ex.Message; } } }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "alpha" || e.CommandName == "NoFilter") { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}%", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } ObjectDataSource1.SelectParameters["Company"].DefaultValue = value; ObjectDataSource1.DataBind(); RadGrid1.Rebind(); } else if (e.CommandName == "QuickUpdate") { string AddressBookID, Priority, IsShowOnHomePage, IsHot, IsNew, IsAvailable; var oAđdressBook = new AddressBook1(); foreach (GridDataItem item in RadGrid1.Items) { AddressBookID = item.GetDataKeyValue("AddressBookID").ToString(); //Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim(); //IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString(); //IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString(); //IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString(); IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString(); oAđdressBook.AddressBook1QuickUpdate( AddressBookID, IsAvailable ); } } //else if (e.CommandName == "DeleteSelected") //{ // string OldImageName; // var oArticle = new Article(); // foreach (GridDataItem item in RadGrid1.SelectedItems) // { // OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value; // DeleteImage(OldImageName); // } //} else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var FileImageName = (RadUpload)row.FindControl("FileImageName"); var oAddressBook = new AddressBook1(); string strAddressBookID = ((HiddenField)row.FindControl("hdnAddressBookID")).Value; //string strOldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value; //string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : ""; //string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim(); //string strMetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim(); //string strMetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim(); //string strArticleTitle = ((TextBox)row.FindControl("txtArticleTitle")).Text.Trim(); //string strConvertedArticleTitle = Common.ConvertTitle(strArticleTitle); //string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim())); //string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim())); //string strTag = ((TextBox)row.FindControl("txtTag")).Text.Trim(); //string strArticleCategoryID = ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue; //string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString(); //string strIsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString(); //string strIsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString(); string strThanhPho = ((RadComboBox)row.FindControl("ddlProvince")).SelectedValue; string strQuan = ((RadComboBox)row.FindControl("ddlDistrict")).SelectedValue; string strCompany = ((TextBox)row.FindControl("txtCompany")).Text.Trim(); string strCompanyEn = ((TextBox)row.FindControl("txtCompanyEn")).Text.Trim(); string strDiaChi = ((TextBox)row.FindControl("txtAddress")).Text.Trim(); string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString(); //string strMetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim(); //string strMetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim(); //string strArticleTitleEn = ((TextBox)row.FindControl("txtArticleTitleEn")).Text.Trim(); //string strDescriptionEn = ((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim(); //string strContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim(); //string strTagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim(); if (e.CommandName == "PerformInsert") { oAddressBook.AddressBook1Insert( "", "", "", "", "", "", "", strCompany, strCompanyEn, strDiaChi, "", "", "", "1", strThanhPho, strQuan, strIsAvailable, "", "", "" ); //string strFullPath = "~/res/article/" + strImageName; //if (!string.IsNullOrEmpty(strImageName)) //{ // FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); // ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); // ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120); //} RadGrid1.Rebind(); } else { var dsUpdateParam = ObjectDataSource1.UpdateParameters; //var strOldImagePath = Server.MapPath("~/res/article/" + strOldImageName); //var strOldThumbImagePath = Server.MapPath("~/res/article/thumbs/" + strOldImageName); dsUpdateParam["Company"].DefaultValue = strCompany; dsUpdateParam["CompanyEn"].DefaultValue = strCompanyEn; dsUpdateParam["Address1"].DefaultValue = strDiaChi; dsUpdateParam["CountryID"].DefaultValue = "1"; dsUpdateParam["ProvinceID"].DefaultValue = strThanhPho; dsUpdateParam["DistrictID"].DefaultValue = strQuan; dsUpdateParam["IsPrimary"].DefaultValue = strIsAvailable; //if (!string.IsNullOrEmpty(strImageName)) //{ // if (File.Exists(strOldImagePath)) // File.Delete(strOldImagePath); // if (File.Exists(strOldThumbImagePath)) // File.Delete(strOldThumbImagePath); // strImageName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strImageName.Substring(strImageName.LastIndexOf('.')); // string strFullPath = "~/res/article/" + strImageName; // FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); // ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); // ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120); //} } } //if (e.CommandName == "DeleteImage") //{ // var oArticle = new Article(); // var lnkDeleteImage = (LinkButton)e.CommandSource; // var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#'); // var strArticleID = s[0]; // var strImageName = s[1]; // oArticle.ArticleImageDelete(strArticleID); // DeleteImage(strImageName); // RadGrid1.Rebind(); //} }