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