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;
}
}