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 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 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 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 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 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 DisplayData() { try { if (Request.QueryString["p2"] != null) { Int64 iAboutUsId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); DataTable dt = BeanHelper.DBHelper.FillTable(@"Select AboutUsId, Remarks, CreatedOn, EndDate from [dbo].[tblAboutUs] where AboutUsId=" + iAboutUsId + " and EndDate is null"); if (dt.Rows.Count > 0) { txtremarks.Text = Convert.ToString(dt.Rows[0]["Remarks"]); } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
private void FillNotification() { try { int iNotificationId = 0; if (Request.QueryString["p2"] == null) { iNotificationId = 0; } else { iNotificationId = int.Parse(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()); } string strQur = @"select [ClientId],[Remarks] ,[NotificationType],[KeyParameter],Title from [dbo].[tblNotification] where NotificationId=" + iNotificationId + ""; DataTable dtNotification = BeanHelper.DBHelper.FillTable(strQur); if (dtNotification.Rows.Count > 0) { ddlType.SelectedValue = Convert.ToString(dtNotification.Rows[0]["NotificationType"]); ddlClient.SelectedValue = Convert.ToString(dtNotification.Rows[0]["ClientId"]); txtMessage.Text = Convert.ToString(dtNotification.Rows[0]["Remarks"]); txtTitle.Text = Convert.ToString(dtNotification.Rows[0]["Title"]); string[] split = dtNotification.Rows[0]["KeyParameter"].ToString().Split('|'); if (split.Length <= 6) { txtKeyParameter1.Text = Convert.ToString(split[0]); txtKeyParameter2.Text = Convert.ToString(split[1]); txtKeyParameter3.Text = Convert.ToString(split[2]); txtKeyParameter4.Text = Convert.ToString(split[3]); txtKeyParameter5.Text = Convert.ToString(split[4]); txtKeyParameter6.Text = Convert.ToString(split[5]); } } } catch (Exception ex) { dvMsg.Visible = true; lblMsg.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 DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.LoginBean.GetDataUser(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { txtUserName.Text = Convert.ToString(dt.Rows[0]["LoginName"]); txtPassword.Text = GlobalFunctions.Decrypt(Convert.ToString(dt.Rows[0]["LoginPassword"])); txtPassword.Attributes.Add("value", GlobalFunctions.Decrypt(Convert.ToString(dt.Rows[0]["LoginPassword"]))); ddlUserRole.SelectedValue = Convert.ToString(dt.Rows[0]["UserRoleId"]); ChkIsActive.Checked = Convert.ToBoolean(dt.Rows[0]["IsActive"]); } } } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.CategoryBean.GetDataCategory(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { string FileName1 = string.Empty; string Path = string.Empty; string FileName2 = string.Empty; txtCategoryName.Text = Convert.ToString(dt.Rows[0]["CategoryName"]); txtCategoryPoints.Text = Convert.ToString(dt.Rows[0]["CategoryPoints"]); txtColorCode.Text = Convert.ToString(dt.Rows[0]["ColorCode"]).Substring(1, 6); FileName1 = Convert.ToString(dt.Rows[0]["Icon1"]); Path = Server.MapPath("~/images/" + FileName1); if (File.Exists(Path)) { imgPicture1.ImageUrl = "~/images/" + FileName1; } else { imgPicture1.ImageUrl = "../Content/images/icons/Noimge.jpg"; } aImage1.HRef = "~/images/" + FileName1; lblPhoto1.Text = FileName1; if (string.IsNullOrEmpty(lblPhoto1.Text)) { btnUploadImage1.Visible = true; btnClearImage1.Visible = false; aImage1.Visible = false; } else { btnUploadImage1.Visible = false; btnClearImage1.Visible = true; aImage1.Visible = true; } // For Icon 2 FileName2 = Convert.ToString(dt.Rows[0]["Icon2"]); lblPhoto2.Text = FileName2; if (string.IsNullOrEmpty(lblPhoto2.Text)) { btnUploadImage2.Visible = true; btnClearImage2.Visible = false; aImage2.Visible = false; } else { btnUploadImage2.Visible = false; btnClearImage2.Visible = true; aImage2.Visible = true; } Path = Server.MapPath("~/images/" + FileName2); if (File.Exists(Path)) { imgPicture2.ImageUrl = "~/images/" + FileName2; } else { imgPicture2.ImageUrl = "../Content/images/icons/Noimge.jpg"; } aImage2.HRef = "~/images/" + FileName2; if (Convert.ToInt32(dt.Rows[0]["IsActive"]) == 1) { chkIsActive.Checked = true; } else { chkIsActive.Checked = false; } if (Convert.ToInt32(dt.Rows[0]["IsFree"]) == 1) { chkIsFree.Checked = true; } else { chkIsFree.Checked = false; } } } } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.PackageBean.GetDataPackage(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { txtPackageName.Text = Convert.ToString(dt.Rows[0]["PackageName"]); txtDescription.Text = Convert.ToString(dt.Rows[0]["Description"]); txtCreditPost.Text = Convert.ToString(dt.Rows[0]["CreditPost"]); txtCreditPoint.Text = Convert.ToString(dt.Rows[0]["CreditPoint"]); txtAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]); } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
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 DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.UserRoleBean.GetDataRole(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { txtUserRoleName.Text = Convert.ToString(dt.Rows[0]["UserRoleName"]); txtUserRoleDesc.Text = Convert.ToString(dt.Rows[0]["UserRoleDesc"]); ChkIsActive.Checked = Convert.ToBoolean(dt.Rows[0]["IsActive"]); FillUserRights(); string sQry = @"Select URR.UserRoleId, URR.MenuName, URR.IsView, URR.IsSave, URR.IsUpdate, URR.IsDelete, URR.IsPrint From tblUserRights URR Inner Join tblDefaultForms DF On URR.MenuName = DF.MenuName Where URR.UserRoleId = " + ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString()) + @" Order By URR.MenuName "; DataTable dttblUserRights = BeanHelper.DBHelper.FillTable(sQry); if (dttblUserRights != null) { foreach (RepeaterItem rptItem in rpt_Forms.Items) { dttblUserRights.DefaultView.RowFilter = "MenuName = '" + Convert.ToString(((HiddenField)rptItem.FindControl("hfMenuName")).Value) + "'"; if (dttblUserRights.DefaultView.ToTable() != null && dttblUserRights.DefaultView.ToTable().Rows.Count > 0) { ((CheckBox)rptItem.FindControl("cbView")).Checked = Convert.ToInt32(dttblUserRights.DefaultView.ToTable().Rows[0]["IsView"]) == 1 ? true : false; ((CheckBox)rptItem.FindControl("cbSave")).Checked = Convert.ToInt32(dttblUserRights.DefaultView.ToTable().Rows[0]["IsSave"]) == 1 ? true : false; ((CheckBox)rptItem.FindControl("cbUpdate")).Checked = Convert.ToInt32(dttblUserRights.DefaultView.ToTable().Rows[0]["IsUpdate"]) == 1 ? true : false; ((CheckBox)rptItem.FindControl("cbDelete")).Checked = Convert.ToInt32(dttblUserRights.DefaultView.ToTable().Rows[0]["IsDelete"]) == 1 ? true : false; ((CheckBox)rptItem.FindControl("cbPrint")).Checked = Convert.ToInt32(dttblUserRights.DefaultView.ToTable().Rows[0]["IsPrint"]) == 1 ? true : false; } dttblUserRights.DefaultView.RowFilter = string.Empty; } } } } } catch (Exception ex) { dvMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.ProductRedeemBean.GetData(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { ddlClient.SelectedValue = Convert.ToString(dt.Rows[0]["ClientId"]); ddlProduct.SelectedValue = Convert.ToString(dt.Rows[0]["ProductId"]); txtRedeemPoint.Text = Convert.ToString(dt.Rows[0]["RedeemPoint"]); } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void FindSearchAndBind() { try { StringBuilder strwhere = new StringBuilder(); string searchtext = txtSearch.Text.Replace("'", string.Empty).Trim(); string mainstrwhere = string.Empty; string section = string.Empty; try { section = HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString(); } catch (Exception) { Response.Redirect("~/Dashboard.aspx", false); } if (!string.IsNullOrEmpty(searchtext) && (ViewState["Columns"] != null) && (ViewState["ColumnsType"] != null)) { ArrayList coldata = (ArrayList)ViewState["Columns"]; ArrayList coltype = (ArrayList)ViewState["ColumnsType"]; for (int i = 0; i < coldata.Count; i++) { if (((string)coltype[i]) == "DateTime") { if (strwhere.Length == 0) { strwhere.Append("Convert(Varchar(10), [" + ((string)coldata[i]) + "], 103) Like '%" + searchtext + "%'"); strwhere.Append(" Or Convert(Varchar(8), [" + ((string)coldata[i]) + "], 108) Like '%" + searchtext + "%'"); } else { strwhere.Append(" Or Convert(Varchar(10), [" + ((string)coldata[i]) + "], 103) Like '%" + searchtext + "%'"); strwhere.Append(" Or Convert(Varchar(8), [" + ((string)coldata[i]) + "], 108) Like '%" + searchtext + "%'"); } } else { if (strwhere.Length == 0) { strwhere.Append("[" + ((string)coldata[i]) + "] Like '%" + searchtext + "%'"); } else { strwhere.Append(" Or [" + ((string)coldata[i]) + "] Like '%" + searchtext + "%'"); } } } } string sWhere = "1 = 1"; if (section == "UserRole" || section == "Client") { if (ConversionHelper.ConvertToString(ddlStatus.SelectedValue) != "2") { sWhere = " IsActive = " + ConversionHelper.ConvertToString(ddlStatus.SelectedValue); } } if (section == "Job Post") { if (ConversionHelper.ConvertToString(ddlIsHire.SelectedValue) == "0") { sWhere = " IsHire = 0"; } else if (ConversionHelper.ConvertToString(ddlIsHire.SelectedValue) == "1") { sWhere = " IsHire = 1"; } else if (ConversionHelper.ConvertToString(ddlIsHire.SelectedValue) == "2") { sWhere = " IsHire = 2 And IsStripePaymentDone = 0"; } else if (ConversionHelper.ConvertToString(ddlIsHire.SelectedValue) == "3") { sWhere = " IsHire = 2 And IsStripePaymentDone = 1"; } } if (!string.IsNullOrEmpty(strwhere.ToString())) { sWhere = sWhere + " And ( " + strwhere.ToString() + " )"; } mainstrwhere = ViewState["SelectedView"].ToString() + " Where" + sWhere; ViewState["SearchCondition"] = mainstrwhere.ToString(); BindGrid(); } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
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(); Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Job Post - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); if (!IsPostBack) { txtSearch.Focus(); ddlStatus.Visible = false; btnCancelsearch.Visible = false; btnExportExcel.Visible = false; btnExportPDF.Visible = false; btnSearch.Visible = false; ddlIsHire.Visible = true; ViewState["SelectedView"] = "vwJobPostGet"; ViewState["ReturnPage"] = "~/SearchJobPost.aspx?p1=2"; ViewState["SearchCondition"] = ViewState["SelectedView"].ToString() + " Where IsHire = 0"; ViewState["OrderBy"] = " Order By [JobPostId] ASC"; ViewState["SelectedField"] = @"JobPostId,ClientId,JobTitle,JobDescription,JobPhoto,IsFree,CategoryId,JobPostingPoints,JobPostingAmount,Latitude,Longitude,Altitude,JobTimeFlag,JobHour,JobDoneTime,JobAmount,JobAmountFlag,PaymentTime,PaymentId,PaymentStatus, PaymentResponse,CreatedOn,EndDate,Latitude_1,Longitude_1,Altitude_1,FirstName,LastName,CategoryName,EmailId,IsHire,TotalPayment,RefundAmount,DeductionAmount,HelperAmount,StripeDeductionAmount,IsStripePaymentDone,HelpSeeker_StripeAccountId,Helper_StripeAccountId,HelpSeekerName,HelperName"; TitleCaption.Text = "Job Post"; ViewState["PDFColWidth"] = new float[] { 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7 }; DataTable data = BeanHelper.SearchBean.GetData(ViewState["SearchCondition"].ToString() + ViewState["OrderBy"].ToString(), ViewState["SelectedField"].ToString()); ArrayList coldata = new ArrayList(); ArrayList coltype = 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); } } ViewState["Columns"] = coldata; ViewState["ColumnsType"] = coltype; grddata.AllowPaging = true; grddata.PageSize = 10; 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; btnSearch.Visible = true; btnCancelsearch.Visible = true; } else { btnExportExcel.Visible = false; btnExportPDF.Visible = false; btnSearch.Visible = false; btnCancelsearch.Visible = false; } } } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
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 DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.SubscriptionBean.GetData(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { txtFirstName.Text = Convert.ToString(dt.Rows[0]["FirstName"]); txtLastName.Text = Convert.ToString(dt.Rows[0]["LastName"]); txtPackageName.Text = Convert.ToString(dt.Rows[0]["PackageName"]); txtCreditPost.Text = Convert.ToString(dt.Rows[0]["CreditPost"]); txtCreditPoint.Text = Convert.ToString(dt.Rows[0]["CreditPoint"]); txtPaymentAmount.Text = Convert.ToString(dt.Rows[0]["PaymentAmount"]); txtPaymentTime.Text = Convert.ToString(dt.Rows[0]["PaymentTime"]); txtPaymentId.Text = Convert.ToString(dt.Rows[0]["PaymentId"]); txtPaymentStatus.Text = Convert.ToString(dt.Rows[0]["PaymentStatus"]); txtPaymentResponse.Text = Convert.ToString(dt.Rows[0]["PaymentResponse"]); } } } catch (Exception ex) { dvMsg.Visible = true; lblMsg.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() + " - Client Information " + ConfigurationManager.AppSettings["Version"].ToString(); if (!IsPostBack) { TitleCaption.Text = "Client Information"; ArrayList coldata = new ArrayList(); ArrayList coltype = new ArrayList(); #region Subscription ViewState["SearchCondition_SubscriptionGet"] = "[vwSubscriptionGet] Where ClientId = " + ConversionHelper.ConvertToString(HtmlSerializer.HtmlToObject(Request.QueryString["p2"])); ViewState["OrderBy_SubscriptionGet"] = " Order By [SubscriptionId] ASC"; ViewState["SelectedField_SubscriptionGet"] = "[SubscriptionId],[PackageName],[FirstName],[LastName],[CreditPost],[CreditPoint],[PaymentAmount],[PaymentTime],[PaymentId],[PaymentStatus],[PaymentResponse]"; DataTable dtSubscriptionGet = BeanHelper.SearchBean.GetData(ViewState["SearchCondition_SubscriptionGet"].ToString() + ViewState["OrderBy_SubscriptionGet"].ToString(), ViewState["SelectedField_SubscriptionGet"].ToString()); coldata = new ArrayList(); coltype = new ArrayList(); for (int i = 0; i < dtSubscriptionGet.Columns.Count; i++) { coldata.Add(dtSubscriptionGet.Columns[i].ColumnName); coltype.Add(dtSubscriptionGet.Columns[i].DataType.Name); } ViewState["Columns_SubscriptionGet"] = coldata; ViewState["ColumnsType_SubscriptionGet"] = coltype; GlobalFunctions.SetPaging(ref grdSubscriptionGet); grdSubscriptionGet.DataSource = dtSubscriptionGet; grdSubscriptionGet.DataBind(); lblRecord_Subscription.Text = "Subscription Info. : " + (dtSubscriptionGet.Rows.Count.ToString()) + " Record(s)"; ViewState["PDFColWidth_Subscription"] = new float[] { 10, 10, 10, 10, 10, 10, 10, 10, 10, 10 }; #endregion #region ProductRedeem ViewState["SearchCondition_ProductRedeem"] = "vwProductRedeemGet Where ClientId = " + ConversionHelper.ConvertToString(HtmlSerializer.HtmlToObject(Request.QueryString["p2"])); ViewState["OrderBy_ProductRedeem"] = " Order By [ProductRedeemId] ASC"; ViewState["SelectedField_ProductRedeem"] = "[ProductRedeemId],[FirstName],[LastName],[ProductName],[RedeemPoint]"; DataTable dtProductRedeem = BeanHelper.SearchBean.GetData(ViewState["SearchCondition_ProductRedeem"].ToString() + ViewState["OrderBy_ProductRedeem"].ToString(), ViewState["SelectedField_ProductRedeem"].ToString()); coldata = new ArrayList(); coltype = new ArrayList(); for (int i = 0; i < dtProductRedeem.Columns.Count; i++) { coldata.Add(dtProductRedeem.Columns[i].ColumnName); coltype.Add(dtProductRedeem.Columns[i].DataType.Name); } ViewState["Columns_ProductRedeem"] = coldata; ViewState["ColumnsType_ProductRedeem"] = coltype; GlobalFunctions.SetPaging(ref grdProductRedeemGet); grdProductRedeemGet.DataSource = dtProductRedeem; grdProductRedeemGet.DataBind(); lblRecord_ProductRedeemGet.Text = "Product Redeem Info. : " + (dtProductRedeem.Rows.Count.ToString()) + " Record(s)"; ViewState["PDFColWidth_ProductRedeem"] = new float[] { 40, 20, 20, 20 }; #endregion } } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
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(); Page.Title = ConfigurationManager.AppSettings["ProjectTitle"].ToString() + " - Search - Client - Version : " + ConfigurationManager.AppSettings["Version"].ToString(); if (!IsPostBack) { txtSearch.Focus(); 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,Gender,GenderDisp,Address1,Address2,City,POBox,State,Country,PhoneNo,EmailId,Password,Status,IsActive,CreatedOn,EndDate,AcTokenId,RegisteredBy,CityName, StateName,CountryName,Latitude,Longitude,Altitude,CreditPoint,ProfilePic,IsClientProfile,Rating,Points,HelpMe,Offered,Radious,BirthDate,IsBankInformation,BusinessTaxId,PersonalIdNumber, BankAccountNumber,RoutingNumber,LegalDocument,StripeAccountId,IsStripeConnectVerified,PaymentMethod,PaymentMethodDisp"; TitleCaption.Text = "Client"; ViewState["PDFColWidth"] = new float[] { 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6 }; DataTable data = BeanHelper.SearchBean.GetData(ViewState["SearchCondition"].ToString() + ViewState["OrderBy"].ToString(), ViewState["SelectedField"].ToString()); ArrayList coldata = new ArrayList(); ArrayList coltype = 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); } } ViewState["Columns"] = coldata; ViewState["ColumnsType"] = coltype; grddata.AllowPaging = true; grddata.PageSize = 10; 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 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 DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.ProductBean.GetData(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { string FileName1 = string.Empty; string Path = string.Empty; txtProductName.Text = Convert.ToString(dt.Rows[0]["ProductName"]); txtDescription.Text = Convert.ToString(dt.Rows[0]["Description"]); txtPoint.Text = Convert.ToString(dt.Rows[0]["Point"]); FileName1 = Convert.ToString(dt.Rows[0]["ProductImage"]); Path = Server.MapPath("~/images/Product/" + FileName1); if (File.Exists(Path)) { imgProduct.ImageUrl = "~/images/Product/" + FileName1; } else { imgProduct.ImageUrl = "../Content/images/icons/Noimge.jpg"; } aImage1.HRef = "~/images/Product/" + FileName1; lblProductimage.Text = FileName1; if (string.IsNullOrEmpty(lblProductimage.Text)) { divshowproduct.Style.Add("Display", "none"); btnProductimage.Visible = true; btnClearImage.Visible = false; } else { divshowproduct.Style.Add("Display", "block"); btnProductimage.Visible = false; btnClearImage.Visible = true; fuproductimage.Visible = false; } } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void grddata_RowDataBound(object sender, GridViewRowEventArgs e) { try { GridView gridView = (GridView)sender; if (ViewState["SortCol"] != null) { int cellIndex = -1; foreach (DataControlField field in gridView.Columns) { if (field.SortExpression == ViewState["SortCol"].ToString()) { cellIndex = gridView.Columns.IndexOf(field); break; } } if (cellIndex > -1) { if (e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[cellIndex].CssClass += (ViewState["SortDir"].ToString() == "ASC" ? " sortascheader" : " sortdescheader"); } } } if (e.Row.RowType == DataControlRowType.DataRow) { string section = HtmlSerializer.HtmlToObject(Request.QueryString["p2"].ToString()).ToString(); if (section == "IssueAllocation") { DateTimeFormatInfo dtfrom = new DateTimeFormatInfo(); dtfrom.ShortDatePattern = "dd/MM/yyyy"; dtfrom.DateSeparator = "/"; DataRowView drvCurrent = (DataRowView)e.Row.DataItem; if (Convert.ToDateTime(drvCurrent["Resolve By Date"].ToString(), dtfrom) < DateTime.Now) { e.Row.BackColor = Color.FromArgb(255, 182, 193); e.Row.ForeColor = Color.White; } } } if (e.Row.RowType == DataControlRowType.DataRow) { if (ViewState["IsSubmitColumnIndex"] != null) { int deletebuttonColumnIndex = (int)ViewState["IsSubmitColumnIndex"]; LinkButton button = e.Row.Cells[deletebuttonColumnIndex].Controls[0] as LinkButton; if (e.Row.Cells[2].Text != null && e.Row.Cells[2].Text == "Yes") { button.CommandName = "StatusNo"; //button.Text = e.Row.Cells[2].Text; button.Text = "<i class='glyphicon glyphicon-ok-circle' ></i>"; button.CssClass = "btn1 btn-success"; } else { button.CommandName = "StatusYes"; //button.Text = e.Row.Cells[2].Text; button.Text = "<i class='glyphicon glyphicon-remove' ></i>"; button.CssClass = "btn1 btn-danger"; } } } if (e.Row.RowType == DataControlRowType.DataRow) { if (ViewState["deletebuttonColumnIndex"] != null) { int deletebuttonColumnIndex = (int)ViewState["deletebuttonColumnIndex"]; LinkButton button = e.Row.Cells[deletebuttonColumnIndex].Controls[0] as LinkButton; if (button != null && button.CommandName == "DeleteRecord") { button.OnClientClick = "if (!confirm('Are you sure you want to delete this record?')) return false;"; } } } } catch (Exception ex) { Messagesection.Visible = true; Message.Text = ex.Message; LogManager.Log(ex); } }
protected void DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.EmailSettingsBean.GetEmailSettings(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { ddlUserName.SelectedValue = Convert.ToString(dt.Rows[0]["LoginId"]); txtSMTPServer.Text = Convert.ToString(dt.Rows[0]["SMTPServer"]); txtSMTPUserName.Text = Convert.ToString(dt.Rows[0]["SMTPUserName"]); txtSMTPpwd.Text = Convert.ToString(dt.Rows[0]["SMTPPassword"]); txtSMTPport.Text = Convert.ToString(dt.Rows[0]["SMTPPort"]); if (Convert.ToBoolean(dt.Rows[0]["EnableSSL"]) == true) { chkSSL.Checked = true; } else { chkSSL.Checked = false; } } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
protected void DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.GeneralSettingsBean.GetDataGeneralSettings(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { txtCreditPost.Text = Convert.ToString(dt.Rows[0]["CreditPoint"]); txtshareapp.Text = Convert.ToString(dt.Rows[0]["ShareApp"]); txtsharepost.Text = Convert.ToString(dt.Rows[0]["SharePost"]); cblAppMode.SelectedValue = Convert.ToString(dt.Rows[0]["AppMode"]); } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }
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 DisplayData() { try { if (Request.QueryString["p2"] != null) { DataTable dt = BeanHelper.ClientBean.GetData(ConversionHelper.ConvertToInt32(HtmlSerializer.HtmlToObject(Request.QueryString["p2"]).ToString())); if (dt.Rows.Count > 0) { txtfirstname.Text = Convert.ToString(dt.Rows[0]["FirstName"]); txtlastname.Text = Convert.ToString(dt.Rows[0]["LastName"]); txtAddress1.Text = Convert.ToString(dt.Rows[0]["Address1"]); txtAddress2.Text = Convert.ToString(dt.Rows[0]["Address2"]); ddlCountry.SelectedValue = Convert.ToString(dt.Rows[0]["Country"]); ddlState.SelectedValue = Convert.ToString(dt.Rows[0]["State"]); ddlCity.SelectedValue = Convert.ToString(dt.Rows[0]["City"]); txtPOBox.Text = Convert.ToString(dt.Rows[0]["POBox"]); txtEmailId.Text = Convert.ToString(dt.Rows[0]["EmailId"]); txtPhoneNo.Text = Convert.ToString(dt.Rows[0]["PhoneNo"]); txtpassword.Text = Convert.ToString(dt.Rows[0]["Password"]); txtCreditPoint.Text = Convert.ToString(dt.Rows[0]["CreditPoint"]); if (Convert.ToInt32(dt.Rows[0]["Gender"]) == 1) { rdogender.SelectedValue = "1"; } else { rdogender.SelectedValue = "2"; } if (Convert.ToInt32(dt.Rows[0]["IsActive"]) == 1) { ChkIsActive.Checked = true; } else { ChkIsActive.Checked = false; } if (Convert.ToInt32(dt.Rows[0]["IsClientProfile"]) == 1) { ChkIsClientProfile.Checked = true; } else { ChkIsClientProfile.Checked = false; } ddlCountry_SelectedIndexChanged(null, null); } } } catch (Exception ex) { dvMsg.Visible = true; lblErrorMsg.Text = ex.Message; } }