protected void BindGrid() { try { DataTable data = BeanHelper.SearchBean.GetData(ViewState["SearchCondition"].ToString() + ViewState["OrderBy"].ToString(), ViewState["SelectedField"].ToString()); DataColumn Col = data.Columns.Add("IdEnc", System.Type.GetType("System.String")); Col.SetOrdinal(1); for (int i = 0; i < data.Rows.Count; i++) { data.Rows[i][1] = HtmlSerializer.ObjectToHTML(data.Rows[i][0].ToString()); } grddata.DataSource = data; grddata.DataBind(); lblRecord.Text = (data.Rows.Count.ToString()) + " Record(s) found."; if (data.Rows.Count > 0) { btnExportExcel.Visible = true; btnExportPDF.Visible = true; } else { btnExportExcel.Visible = false; btnExportPDF.Visible = false; } } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int LoginId = 0; if (Request.QueryString["p2"] == null) { LoginId = 0; } else { LoginId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } if (BeanHelper.LoginBean.IsUserExist(LoginId, txtUserName.Text.Replace("'", string.Empty).Trim())) { dvMsg.Visible = true; lblMsg.Text = "User already Exists."; txtUserName.Focus(); return; } HelpMe.Entities.Login objLogin = new HelpMe.Entities.Login(); objLogin.LoginId = LoginId; objLogin.LoginName = txtUserName.Text.Trim().Replace("'", "''").Trim(); objLogin.LoginPassword = GlobalFunctions.Encrypt(txtPassword.Text.Trim()); objLogin.UserRoleId = Convert.ToInt32(ddlUserRole.SelectedValue); objLogin.IsActive = ChkIsActive.Checked == true ? 1 : 0; int ReturnValue; BeanHelper.LoginBean.LoginObject = objLogin; if (LoginId == 0) { ReturnValue = BeanHelper.LoginBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.LoginBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (LoginId == 0) { lblMsg.Text = "User Saved Successfully."; } else { lblMsg.Text = "User Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("User"), false); } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int UserRoleId = 0; if (Request.QueryString["p2"] == null) { UserRoleId = 0; } else { UserRoleId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } if (BeanHelper.UserRoleBean.IsUserRoleExist(UserRoleId, txtUserRoleName.Text.Replace("'", string.Empty).Trim())) { dvMsg.Visible = true; lblMsg.Text = "User Role already Exists."; txtUserRoleName.Focus(); return; } HelpMe.Entities.UserRole objUserRole = new HelpMe.Entities.UserRole(); objUserRole.UserRoleId = UserRoleId; objUserRole.UserRoleName = txtUserRoleName.Text.Replace("'", string.Empty).Trim(); objUserRole.UserRoleDesc = txtUserRoleDesc.Text.Replace("'", string.Empty).Trim(); int ReturnValue; BeanHelper.UserRoleBean.UserRole = objUserRole; if (UserRoleId == 0) { ReturnValue = BeanHelper.UserRoleBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.UserRoleBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { UpdateUserAccess(ReturnValue); if (UserRoleId == 0) { lblMsg.Text = "User Role Saved Successfully."; } else { lblMsg.Text = "User Role Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("UserRole"), false); } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int categoryID = 0; if (Request.QueryString["p2"] == null) { categoryID = 0; } else { categoryID = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.Category objCategory = new HelpMe.Entities.Category(); objCategory.CategoryId = categoryID; objCategory.CategoryName = txtCategoryName.Text.Trim().Replace("'", "''").Trim(); objCategory.CategoryPoints = Convert.ToInt32(txtCategoryPoints.Text.Trim().Replace("'", "''").Trim()); objCategory.Icon1 = lblPhoto1.Text; objCategory.Icon2 = lblPhoto2.Text; objCategory.ColorCode = "#" + txtColorCode.Text.Trim().ToString(); objCategory.IsActive = chkIsActive.Checked == true ? 1 : 0; objCategory.IsFree = chkIsFree.Checked == true ? 1 : 0; int ReturnValue; BeanHelper.CategoryBean.objCategory = objCategory; if (categoryID == 0) { ReturnValue = BeanHelper.CategoryBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.CategoryBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (categoryID == 0) { lblMsg.Text = "Category Saved Successfully."; } else { lblMsg.Text = "Category Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("Category"), false); } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int PackageId = 0; if (Request.QueryString["p2"] == null) { PackageId = 0; } else { PackageId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.Package objPackage = new HelpMe.Entities.Package(); objPackage.PackageId = PackageId; objPackage.PackageName = txtPackageName.Text.Trim().Replace("'", "''").Trim(); objPackage.Description = Convert.ToString(txtDescription.Text); objPackage.CreditPost = Convert.ToInt32(txtCreditPost.Text); objPackage.CreditPoint = Convert.ToInt32(txtCreditPoint.Text); objPackage.Amount = Convert.ToDecimal(txtAmount.Text); int ReturnValue; BeanHelper.PackageBean.objPackage = objPackage; if (PackageId == 0) { ReturnValue = BeanHelper.PackageBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.PackageBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (PackageId == 0) { lblErrorMsg.Text = "Package Saved Successfully."; } else { lblErrorMsg.Text = "Package Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("Package"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void lnkCancel_Click(object sender, EventArgs e) { try { Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("Email Settings"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int GeneralSettingId = 0; if (Request.QueryString["p2"] == null) { GeneralSettingId = 0; } else { GeneralSettingId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.GeneralSettings objGeneralSettings = new HelpMe.Entities.GeneralSettings(); objGeneralSettings.GeneralSettingId = GeneralSettingId; objGeneralSettings.CreditPoint = Convert.ToString(txtCreditPost.Text); objGeneralSettings.ShareApp = Convert.ToString(txtshareapp.Text); objGeneralSettings.SharePost = Convert.ToString(txtsharepost.Text); objGeneralSettings.AppMode = Convert.ToString(cblAppMode.SelectedValue); int ReturnValue; BeanHelper.GeneralSettingsBean.objGeneralSettings = objGeneralSettings; if (GeneralSettingId == 0) { ReturnValue = BeanHelper.GeneralSettingsBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.GeneralSettingsBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (GeneralSettingId == 0) { lblErrorMsg.Text = "General Settings Saved Successfully."; } else { lblErrorMsg.Text = "General Settings Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("General Settings"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int iProductId = 0; if (Request.QueryString["p2"] == null) { iProductId = 0; } else { iProductId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.Product objProduct = new HelpMe.Entities.Product(); objProduct.ProductId = iProductId; objProduct.ProductName = txtProductName.Text.Trim().Replace("'", "''").Trim(); objProduct.Description = Convert.ToString(txtDescription.Text); objProduct.ProductImage = Convert.ToString(lblProductimage.Text); objProduct.Point = txtPoint.Text == "" ? Convert.ToInt32("0") : Convert.ToInt32(txtPoint.Text); int ReturnValue; BeanHelper.ProductBean.ObjProduct = objProduct; if (iProductId == 0) { ReturnValue = BeanHelper.ProductBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.ProductBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (iProductId == 0) { lblErrorMsg.Text = "Product Saved Successfully."; } else { lblErrorMsg.Text = "Product Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("Product"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int ProductRedeemId = 0; if (Request.QueryString["p2"] == null) { ProductRedeemId = 0; } else { ProductRedeemId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.ProductRedeem objobjProduct = new HelpMe.Entities.ProductRedeem(); objobjProduct.ProductId = Convert.ToInt64(ddlProduct.SelectedValue); objobjProduct.ClientId = Convert.ToInt64(ddlClient.SelectedValue); objobjProduct.RedeemPoint = Convert.ToInt32(txtRedeemPoint.Text); int ReturnValue; BeanHelper.ProductRedeemBean.ObjProductRedeem = objobjProduct; if (ProductRedeemId == 0) { ReturnValue = BeanHelper.ProductRedeemBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.ProductRedeemBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (ProductRedeemId == 0) { lblErrorMsg.Text = "Product Redeem Saved Successfully."; } else { lblErrorMsg.Text = "Product Redeem Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("Product Redeem"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int iAboutUsId = 0; string SQry = string.Empty; if (Request.QueryString["p2"] == null) { iAboutUsId = 0; } else { iAboutUsId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } if (iAboutUsId == 0) { SQry = @"INSERT INTO [dbo].[tblAboutUs]([Remarks])VALUES ('" + Convert.ToString(txtremarks.Text) + "')"; } else { SQry = @"update tblAboutUs set Remarks='" + Convert.ToString(txtremarks.Text) + "',CreatedOn=(getdate()) where AboutUsId=" + iAboutUsId + ""; } BeanHelper.DBHelper.ExecuteNonQuery(SQry); if (iAboutUsId == 0) { lblErrorMsg.Text = "About Us Saved Successfully."; } else { lblErrorMsg.Text = "About Us Updated Successfully."; } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("AboutUs"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!GlobalFunctions.ValidateSession()) { Response.Redirect("~/index.aspx", false); return; } Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Email Settings - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); try { if (Request.QueryString["p2"] != null) { HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString(); } } catch (Exception) { Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("Email Settings"), false); } if (!IsPostBack) { FillCombo(); if (Request.QueryString["p2"] != null) { DisplayData(); } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!GlobalFunctions.ValidateSession()) { Response.Redirect("~/index.aspx", false); return; } Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Job Post Info - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); try { if (Request.QueryString["p2"] != null) { HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString(); } } catch (Exception) { Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("Jobpost"), false); } if (!IsPostBack) { if (Request.QueryString["p2"] != null) { TitleCaption.Text = "Job Post Information"; ArrayList coldata = new ArrayList(); ArrayList coltype = new ArrayList(); #region Job Post Offer ViewState["SearchCondition_JobPostOffer"] = "vwJobPostOfferGet Where JobPostId = " + ConversionHelper.ConvertToString(HtmlSerializer.HtmlToObject(Request.QueryString["p2"])); ViewState["OrderBy_JobPostOffer"] = " Order By [JobPostOfferId] ASC"; ViewState["SelectedField_JobPostOffer"] = "JobPostOfferId,JobPostId,ClientId, FirstName, LastName, EmailId, JobTitle, JobDescription, OfferAmount"; DataTable dtJobPostOffer = BeanHelper.SearchBean.GetData(ViewState["SearchCondition_JobPostOffer"].ToString() + ViewState["OrderBy_JobPostOffer"].ToString(), ViewState["SelectedField_JobPostOffer"].ToString()); coldata = new ArrayList(); coltype = new ArrayList(); for (int i = 0; i < dtJobPostOffer.Columns.Count; i++) { coldata.Add(dtJobPostOffer.Columns[i].ColumnName); coltype.Add(dtJobPostOffer.Columns[i].DataType.Name); } ViewState["Columns_EduInfo"] = coldata; ViewState["ColumnsType_EduInfo"] = coltype; GlobalFunctions.SetPaging(ref grdJobPostOffer); grdJobPostOffer.DataSource = dtJobPostOffer; grdJobPostOffer.DataBind(); lblRecord_JobPostOffer.Text = "Job Post Offer Info. : " + (dtJobPostOffer.Rows.Count.ToString()) + " Record(s)"; ViewState["PDFColWidth_EduInfo"] = new float[] { 17, 17, 17, 17, 16, 16 }; #endregion #region Job Post View ViewState["SearchCondition_JobPostView"] = "vwJobPostViewGet Where JobPostId = " + ConversionHelper.ConvertToString(HtmlSerializer.HtmlToObject(Request.QueryString["p2"])); ViewState["OrderBy_JobPostView"] = " Order By [JobPostViewId] ASC"; ViewState["SelectedField_JobPostView"] = "JobPostViewId,JobPostId,ClientId, FirstName, LastName, CreatedOn"; DataTable dtJobPostView = BeanHelper.SearchBean.GetData(ViewState["SearchCondition_JobPostView"].ToString() + ViewState["OrderBy_JobPostView"].ToString(), ViewState["SelectedField_JobPostView"].ToString()); coldata = new ArrayList(); coltype = new ArrayList(); for (int i = 0; i < dtJobPostView.Columns.Count; i++) { coldata.Add(dtJobPostView.Columns[i].ColumnName); coltype.Add(dtJobPostView.Columns[i].DataType.Name); } ViewState["Columns_EduInfo"] = coldata; ViewState["ColumnsType_EduInfo"] = coltype; GlobalFunctions.SetPaging(ref grdJobPostView); grdJobPostView.DataSource = dtJobPostView; grdJobPostView.DataBind(); lblRecord_JobPostView.Text = "Job Post View Info. : " + (dtJobPostView.Rows.Count.ToString()) + " Record(s)"; ViewState["PDFColWidth_EduInfo"] = new float[] { 17, 17, 17, 17, 16, 16 }; #endregion } } } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { try { string section; if (!GlobalFunctions.ValidateSession()) { Response.Redirect("~/index.aspx", false); return; } try { section = HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString(); } catch (Exception) { Response.Redirect("~/Dashboard.aspx", false); } this.Form.DefaultButton = this.btnSearch.UniqueID.ToString(); section = HtmlSerializer.HtmlToObject(Request.QueryString["p2"].ToString()).ToString(); #region Switch Case switch (section) { #region Administration case "UserRole": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - User Role - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "User": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - User Setup - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Email Settings": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Email Settings - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "General Settings": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - General Settings - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Category": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Category - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Product": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Product - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Package": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Package - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Client": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Client - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Job Post": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Job Post - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Subscription": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Subscription - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Product Redeem": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Product Redeem - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "Notification": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Notification - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; case "AboutUs": Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - About Us - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); break; #endregion } #endregion if (!IsPostBack) { txtSearch.Focus(); #region Page Selection switch (section) { #region Administration case "UserRole": chkArchived.Visible = false; ViewState["SelectedView"] = "vwUserRoleGet"; ViewState["ReturnPage"] = "~/UserRole.aspx?p1=1"; ViewState["AddPage"] = "~/UserRole.aspx?p1=1"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [User Role] ASC"; ViewState["SelectedField"] = "[UserRoleId],[User Role],[Description],[Status]"; TitleCaption.Text = "User Role"; ViewState["PDFColWidth"] = new float[] { 40, 30, 30 }; break; case "User": chkArchived.Visible = false; ViewState["SelectedView"] = "vwLoginGet"; ViewState["ReturnPage"] = "~/UserMaster.aspx?p1=1"; ViewState["AddPage"] = "~/UserMaster.aspx?p1=1"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString() + " Where IsActive = " + ConversionHelper.ConvertToString(ddlStatus.SelectedValue); ViewState["OrderBy"] = " Order By [User Name] ASC"; ViewState["SelectedField"] = "LoginId,[User Name],[User Role],[Status]"; TitleCaption.Text = "User Setup"; ViewState["PDFColWidth"] = new float[] { 40, 30, 30 }; break; case "Email Settings": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwEmailSettingsGet"; ViewState["ReturnPage"] = "~/EmailSettings.aspx?p1=1"; ViewState["AddPage"] = "~/EmailSettings.aspx?p1=1"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [LoginName] ASC"; ViewState["SelectedField"] = "[EmailSettingsId],[LoginId],[LoginName],[SMTPServer],[SMTPPort],[EnableSSL]"; TitleCaption.Text = "Email Settings"; ViewState["PDFColWidth"] = new float[] { 40, 30, 30 }; break; case "General Settings": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "[vwGeneralSettings]"; ViewState["ReturnPage"] = "~/GeneralSettings.aspx?p1=1"; ViewState["AddPage"] = "~/GeneralSettings.aspx?p1=1"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [GeneralSettingId] ASC"; ViewState["SelectedField"] = "GeneralSettingId, CreditPoint, ShareApp, SharePost, AppModeDisp"; TitleCaption.Text = "General Settings"; ViewState["PDFColWidth"] = new float[] { 40, 30, 30 }; break; case "Category": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwCategoryGet"; ViewState["ReturnPage"] = "~/Category.aspx?p1=2"; ViewState["AddPage"] = "~/Category.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [CategoryId] ASC"; ViewState["SelectedField"] = "[CategoryId],[Category Name],[CategoryPoints],[ColorCode],[Status],[Is Free]"; TitleCaption.Text = "Category"; ViewState["PDFColWidth"] = new float[] { 40, 15, 15, 15, 15 }; break; case "Product": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwProductGet"; ViewState["ReturnPage"] = "~/Product.aspx?p1=2"; ViewState["AddPage"] = "~/Product.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [ProductId] ASC"; ViewState["SelectedField"] = "[ProductId],[ProductName],[Point],[ProductImage],[Description]"; TitleCaption.Text = "Product"; ViewState["PDFColWidth"] = new float[] { 40, 20, 20, 20 }; break; case "Package": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwPackageGet"; ViewState["ReturnPage"] = "~/Package.aspx?p1=2"; ViewState["AddPage"] = "~/Package.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [PackageId] ASC"; ViewState["SelectedField"] = "[PackageId],[PackageName],[CreditPost],[CreditPoint],[Amount],[Description]"; TitleCaption.Text = "Package"; ViewState["PDFColWidth"] = new float[] { 40, 15, 15, 15, 15 }; break; case "Client": ddlStatus.Visible = false; chkArchived.Visible = false; btnAdd.Visible = false; btnAddData.Visible = false; ViewState["SelectedView"] = "vwClientGet"; ViewState["ReturnPage"] = "~/ClientInfo.aspx?p1=2"; ViewState["AddPage"] = "~/ClientInfo.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [ClientId] ASC"; ViewState["SelectedField"] = "[ClientId],[FirstName],[LastName],[GenderDisp],[Address1],[Address2],[CityName],[POBox],[StateName],[CountryName],[PhoneNo],[EmailId],[Rating],[Points],[HelpMe],[Offered],[Status]"; TitleCaption.Text = "Client"; ViewState["PDFColWidth"] = new float[] { 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6 }; break; case "Job Post": ddlStatus.Visible = true; chkArchived.Visible = false; btnAdd.Visible = false; btnAddData.Visible = false; ViewState["SelectedView"] = "vwJobPostGet"; ViewState["ReturnPage"] = "~/SearchJobPost.aspx?p1=2"; ViewState["AddPage"] = "~/SearchJobPost.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [JobPostId] ASC"; ViewState["SelectedField"] = "[JobPostId],[JobTitle],[JobDescription],[FirstName],[LastName],[CategoryName],[JobPostingPoints],[JobPostingAmount],[JobAmount],[JobHour],[JobAmount],[PaymentTime],[PaymentId],[PaymentStatus],[PaymentResponse],[IsFree],[EmailId],[JobActualHour],[TotalPayment],[RefundAmount],[DeductionAmount],[HelperAmount],[StripeDeductionAmount]"; TitleCaption.Text = "Job Post"; ViewState["PDFColWidth"] = new float[] { 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6 }; break; case "Subscription": chkArchived.Visible = false; btnAdd.Visible = false; btnAddData.Visible = false; ddlStatus.Visible = false; ViewState["SelectedView"] = "vwSubscriptionGet"; ViewState["ReturnPage"] = "~/Subscription.aspx?p1=2"; ViewState["AddPage"] = "~/Subscription.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [SubscriptionId] ASC"; ViewState["SelectedField"] = "[SubscriptionId],[PackageName],[FirstName],[LastName],[CreditPost],[CreditPoint],[PaymentAmount],[PaymentTime],[PaymentId],[PaymentStatus],[PaymentResponse]"; TitleCaption.Text = "Subscription"; ViewState["PDFColWidth"] = new float[] { 10, 10, 10, 10, 10, 10, 10, 10, 10, 10 }; break; case "Product Redeem": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwProductRedeemGet"; ViewState["ReturnPage"] = "~/ProductRedeem.aspx?p1=2"; ViewState["AddPage"] = "~/ProductRedeem.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [ProductRedeemId] ASC"; ViewState["SelectedField"] = "[ProductRedeemId],[FirstName],[LastName],[ProductName],[RedeemPoint]"; TitleCaption.Text = "Product Redeem"; ViewState["PDFColWidth"] = new float[] { 40, 20, 20, 20 }; break; case "Notification": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwNotificationGet"; ViewState["ReturnPage"] = "~/Notification.aspx?p1=2"; ViewState["AddPage"] = "~/Notification.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [NotificationId] ASC"; ViewState["SelectedField"] = "[NotificationId],[FirstName],[LastName],[AppHeading],[Title],[Remarks]"; TitleCaption.Text = "Notification"; ViewState["PDFColWidth"] = new float[] { 40, 15, 15, 15, 15 }; break; case "AboutUs": ddlStatus.Visible = false; chkArchived.Visible = false; ViewState["SelectedView"] = "vwAboutUsGet"; ViewState["ReturnPage"] = "~/AboutUs.aspx?p1=2"; ViewState["AddPage"] = "~/AboutUs.aspx?p1=2"; ViewState["DefaultCondition"] = string.Empty; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString(); ViewState["OrderBy"] = " Order By [AboutUsId] ASC"; ViewState["SelectedField"] = "[AboutUsId],[Remarks]"; TitleCaption.Text = "About Us"; ViewState["PDFColWidth"] = new float[] { 40, 15, 15, 15, 15 }; break; #endregion } #endregion DataTable data = BeanHelper.SearchBean.GetData(ViewState["SearchCondition"].ToString() + ViewState["OrderBy"].ToString(), ViewState["SelectedField"].ToString()); // Convert Id to HTMLObject DataColumn Col = data.Columns.Add("IdEnc", System.Type.GetType("System.String")); Col.SetOrdinal(1); for (int i = 0; i < data.Rows.Count; i++) { data.Rows[i][1] = HtmlSerializer.ObjectToHTML(data.Rows[i][0].ToString()); } ArrayList coldata = new ArrayList(); ArrayList coltype = new ArrayList(); ArrayList datakeycol = new ArrayList(); for (int i = 0; i < data.Columns.Count; i++) { if (data.Columns[i].ColumnName != "IdEnc") { coldata.Add(data.Columns[i].ColumnName); coltype.Add(data.Columns[i].DataType.Name); } if (data.Columns[i].ColumnName.ToUpper().IndexOf("ID") != -1) { if (i < 2) { datakeycol.Add(data.Columns[i].ColumnName); } } } int intHyperField = 1; for (int i = 0; i < data.Columns.Count; i++) { if (data.Columns[i].ColumnName.ToUpper().IndexOf("ID") == -1 || data.Columns[i].ColumnName.ToUpper() == "EMAILID") { if (intHyperField == 1) { HyperLinkField hlfHyperMain = new HyperLinkField(); hlfHyperMain.HeaderText = data.Columns[i].ColumnName; hlfHyperMain.DataTextField = data.Columns[i].ColumnName; hlfHyperMain.SortExpression = data.Columns[i].ColumnName; hlfHyperMain.ItemStyle.CssClass = "bluelink"; hlfHyperMain.DataNavigateUrlFields = (String[])datakeycol.ToArray(typeof(string)); hlfHyperMain.DataNavigateUrlFormatString = ViewState["ReturnPage"] + "&p2={1}"; intHyperField = intHyperField + 1; grddata.Columns.Add(hlfHyperMain); } else { BoundField boundField = new BoundField(); boundField.DataField = data.Columns[i].ColumnName; boundField.HeaderText = data.Columns[i].ColumnName; boundField.SortExpression = data.Columns[i].ColumnName; boundField.HtmlEncode = true; if (data.Columns[i].DataType.Name == "Decimal") { boundField.DataFormatString = "{0:n2}"; } else if (data.Columns[i].DataType.Name == "DateTime") { boundField.DataFormatString = "{0:dd/MM/yyyy hh:mm:ss:tt}"; } intHyperField = intHyperField + 1; grddata.Columns.Add(boundField); } } } //switch (section) //{ // case "Tender": // ButtonField btn = new ButtonField(); // //btn.Text = "Yes"; // btn.Text = "<i class='glyphicon glyphicon-ok-circle' ></i>"; // btn.CommandName = "StatusYes"; // btn.ButtonType = ButtonType.Link; // btn.HeaderText = "Is Submit"; // grddata.Columns.Add(btn); // ViewState["IsSubmitColumnIndex"] = grddata.Columns.Count - 1; // break; //} //if (section == "Client" || section == "Package" || section == "File Upload") //{ // ButtonField btn = new ButtonField(); // btn.Text = "Delete"; // btn.CommandName = "DeleteRecord"; // btn.ButtonType = ButtonType.Link; // btn.HeaderText = "Delete"; // grddata.Columns.Add(btn); // ViewState["deletebuttonColumnIndex"] = grddata.Columns.Count - 1; //} grddata.DataKeyNames = (string[])datakeycol.ToArray(typeof(string)); ViewState["Columns"] = coldata; ViewState["ColumnsType"] = coltype; GlobalFunctions.SetPaging(ref grddata); grddata.DataSource = data; grddata.DataBind(); txtSearch.Focus(); lblRecord.Text = (data.Rows.Count.ToString()) + " Record(s) found."; if (data.Rows.Count > 0) { btnExportExcel.Visible = true; btnExportPDF.Visible = true; } else { btnExportExcel.Visible = false; btnExportPDF.Visible = false; } } } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int iNotificationId = 0; if (Request.QueryString["p2"] == null) { iNotificationId = 0; } else { iNotificationId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.Notification objNotification = new HelpMe.Entities.Notification(); objNotification.NotificationId = iNotificationId; objNotification.ClientId = Convert.ToInt32(ddlClient.SelectedValue); objNotification.NotificationType = Convert.ToInt32(ddlType.SelectedValue); objNotification.Remarks = Convert.ToString(txtMessage.Text); objNotification.Title = Convert.ToString(txtTitle.Text); string strparamete = string.Empty; if (Convert.ToString(txtKeyParameter1.Text) != "") { if (strparamete == "") { strparamete = strparamete + Convert.ToString(txtKeyParameter1.Text).Trim(); } else { strparamete = Convert.ToString(txtKeyParameter1.Text).Trim(); } } else { strparamete = Convert.ToString(txtKeyParameter1.Text).Trim(); } if (Convert.ToString(txtKeyParameter2.Text) != "") { if (strparamete == "") { strparamete = strparamete + Convert.ToString(txtKeyParameter2.Text).Trim(); } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter2.Text).Trim(); } } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter2.Text).Trim(); } if (Convert.ToString(txtKeyParameter3.Text) != "") { if (strparamete == "") { strparamete = strparamete + Convert.ToString(txtKeyParameter3.Text).Trim(); } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter3.Text).Trim(); } } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter3.Text).Trim(); } if (Convert.ToString(txtKeyParameter4.Text) != "") { if (strparamete == "") { strparamete = strparamete + Convert.ToString(txtKeyParameter4.Text).Trim(); } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter4.Text).Trim(); } } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter4.Text).Trim(); } if (Convert.ToString(txtKeyParameter5.Text) != "") { if (strparamete == "") { strparamete = strparamete + Convert.ToString(txtKeyParameter5.Text).Trim(); } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter5.Text).Trim(); } } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter5.Text).Trim(); } if (Convert.ToString(txtKeyParameter6.Text) != "") { if (strparamete == "") { strparamete = strparamete + Convert.ToString(txtKeyParameter6.Text).Trim(); } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter6.Text).Trim(); } } else { strparamete = strparamete + "|" + Convert.ToString(txtKeyParameter6.Text).Trim(); } objNotification.KeyParameter = strparamete; if (iNotificationId == 0) { string SQryInsert = @"INSERT INTO [dbo].[tblNotification] ([ClientId],[AppHeading],[Title],[Remarks],[AppIconPath],[ImagePath],[NotificationType],[IsSent],[CreatedOn],[KeyParameter]) VALUES (" + objNotification.ClientId + ",'UHelpMe','" + objNotification.Title + "','" + objNotification.Remarks + "','',''," + objNotification.NotificationType + ",1,GETDATE(),'" + strparamete + "')"; BeanHelper.DBHelper.ExecuteNonQuery(SQryInsert); } else { string SQry = @"update tblNotification set ClientId=" + objNotification.ClientId + ",Title='" + objNotification.Title + "',NotificationType=" + objNotification.NotificationType + ",KeyParameter='" + strparamete + "',Remarks='" + objNotification.Remarks + "' where NotificationId=" + iNotificationId + ""; BeanHelper.DBHelper.ExecuteNonQuery(SQry); } Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("Notification"), false); } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void lnkCancel_Click(object sender, EventArgs e) { Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("Notification"), false); }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int ESettingID = 0; if (Request.QueryString["p2"] == null) { ESettingID = 0; } else { ESettingID = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.EmailSetting objSettings = new HelpMe.Entities.EmailSetting(); objSettings.EmailSettingsId = ESettingID; if (ddlUserName.SelectedIndex == 0) { objSettings.LoginId = 0; } else { objSettings.LoginId = Int32.Parse(ddlUserName.SelectedValue.ToString()); } objSettings.SMTPServer = txtSMTPServer.Text.Trim().Replace("'", "''").Trim(); objSettings.SMTPUserName = txtSMTPUserName.Text.Trim().Replace("'", "''").Trim(); objSettings.SMTPPassword = txtSMTPpwd.Text.Trim().Replace("'", "''").Trim(); objSettings.SMTPPort = int.Parse(txtSMTPport.Text.Trim().Replace("'", "''").Trim()); if (chkSSL.Checked == true) { objSettings.EnableSSL = true; } else { objSettings.EnableSSL = false; } int ReturnValue; BeanHelper.EmailSettingsBean.EmailSetting = objSettings; if (ESettingID == 0) { ReturnValue = BeanHelper.EmailSettingsBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.EmailSettingsBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (ESettingID == 0) { lblErrorMsg.Text = "Email Settings Saved Successfully."; } else { lblErrorMsg.Text = "Email Settings Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=1&p2=" + HtmlSerializer.ObjectToHTML("Email Settings"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { int iClientId = 0; if (Request.QueryString["p2"] == null) { iClientId = 0; } else { iClientId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } HelpMe.Entities.Client objClient = new HelpMe.Entities.Client(); objClient.ClientId = iClientId; objClient.FirstName = Convert.ToString(txtfirstname.Text.Trim()).Replace("'", "''").Trim(); objClient.LastName = Convert.ToString(txtlastname.Text); objClient.Address1 = Convert.ToString(txtAddress1.Text); objClient.Address2 = Convert.ToString(txtAddress2.Text); if (ddlCity.SelectedValue != null || ddlCity.SelectedValue != "") { objClient.City = Convert.ToInt64(ddlCity.SelectedValue); } if (ddlState.SelectedValue != null || ddlState.SelectedValue != "") { objClient.State = Convert.ToInt64(ddlState.SelectedValue); } if (ddlCountry.SelectedValue != null || ddlCountry.SelectedValue != "" || ddlCountry.SelectedValue != "-- Select Country --") { objClient.Country = Convert.ToInt64(ddlCountry.SelectedValue); } objClient.POBox = Convert.ToString(txtPOBox.Text); objClient.Address1 = Convert.ToString(txtEmailId.Text); objClient.EmailId = Convert.ToString(txtEmailId.Text); objClient.PhoneNo = Convert.ToString(txtPhoneNo.Text); objClient.IsActive = ChkIsActive.Checked == true ? 1 : 0; if (txtCreditPoint.Text == null || txtCreditPoint.Text == "") { txtCreditPoint.Text = "0"; } objClient.CreditPoint = Convert.ToInt32(txtCreditPoint.Text); objClient.Gender = Convert.ToInt32(rdogender.SelectedValue); objClient.IsClientProfile = ChkIsClientProfile.Checked == true ? 1 : 0; int ReturnValue; BeanHelper.ClientBean.ObjClient = objClient; if (iClientId == 0) { ReturnValue = BeanHelper.ClientBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.I); } else { ReturnValue = BeanHelper.ClientBean.ExecuteData(HelpMe.CommonEnums.HelpMeOperations.U); } if (ReturnValue > 0) { if (iClientId == 0) { lblErrorMsg.Text = "Client Saved Successfully."; } else { lblErrorMsg.Text = "Client Updated Successfully."; } } Response.Redirect("~/Search.aspx?p1=2&p2=" + HtmlSerializer.ObjectToHTML("Client"), false); } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }