public bool UpdateSendStatus(int MemberCode)
{
try
{
strSql = " UPDATE tbl_membermaster SET Married=0 WHERE MemberCode=" + MemberCode;
int Res = objDb.ExecuteNonQuery(strSql);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex.Message));
this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMarriedConfirmation.btnSendEmail_Click() " + ex.ToString());
return(false);
}
}
private void btnSaveSettings_Click(object sender, EventArgs e)
{
try
{
string strPartnerData = "";
for (int i = 0; i < chkPMaritalStatus.CheckedItems.Count; i++)
{
strPartnerData += ((System.Data.DataRowView)(chkPMaritalStatus.CheckedItems[i])).Row.ItemArray[0] + ",";
}
strPartnerData = strPartnerData.TrimEnd(',');
strSql = "UPDATE tbl_membermaster SET AgeDiff=" + txtAgeDiff.Text + ", MStatus_Preference='" + strPartnerData + "' WHERE ProfileId='" + txtProfileId.Text + "'";
if (objDb.ExecuteNonQuery(strSql) > 0)
{
MessageBox.Show("Setting Updated", "Setting", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtAgeDiff.Text = "";
txtProfileId.Text = "";
for (int i = 0; i < chkPMaritalStatus.Items.Count; i++)
{
chkPMaritalStatus.SetItemCheckState(i, CheckState.Unchecked);
}
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void funSave()
{
try
{
this.objGlobal.strvalues = "";
this.objGlobal.strfields = "";
this.objGlobal.strUpdate = "";
if (ChecckValidation())
{
if (this.IsEdit)
{
this.objGlobal.UpdateFields(this);
}
else
{
this.objGlobal.SaveFields(this);
}
if (chkIsDefault.Checked)
{
if (txtEmailSettingId.Text != "")
{
strSQL = "UPDATE tbl_EmailSettings set IsDefault=0 where EmailSettingId!=" + txtEmailSettingId.Text;
}
else
{
strSQL = "UPDATE tbl_EmailSettings set IsDefault=0 ";
}
objdb.ExecuteNonQuery(strSQL);
}
this.Intcout = this.objGlobal.SaveMasterRecords(this.strMasterTable, "EmailSettingId", this.txtEmailSettingId.Text, "", this.IsEdit);
if (this.Intcout > 0)
{
//Global.strMasterString = this.txtName.Text;
//this.objtransaction2.Commit();
this.objGlobal.showMessage("Email Setting", "success", this.IsEdit, this.txtFromEmail);
((frmMain)base.MdiParent).setToolbarPositions(ToolbarPositions.eTPOk);
((frmMain)base.MdiParent).setControlState(false, true, this);
this.TpLast = ToolbarPositions.eTPOk;
((frmMain)base.MdiParent).setToolbarPositions(this.TpLast);
this.IsEdit = false;
}
else
{
//this.objtransaction2.Rollback();
this.objGlobal.showMessage("Email Setting", "", this.IsEdit, this.txtFromEmail);
}
}
else
{
objGlobal.showMessage("Email Setting", "", IsEdit, txtFromEmail);
txtFromEmail.Focus();
}
}
catch (Exception exception)
{
MessageBox.Show(Convert.ToString(exception.Message));
this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmEmailSetting.funSave() " + exception.ToString());
}
}
public bool SaveDetails(int PackageId)
{
try
{
if (IsEdit)
{
PackageId = Convert.ToInt32(txtPackageId.Text);
strSQL = "Delete from tbl_package_details where Package_Id = " + PackageId;
objDb.ExecuteNonQuery(strSQL);
}
int Res = 0;
for (int cnt = 0; cnt < dgvDetails.Rows.Count; cnt++)
{
if (Convert.ToString(dgvDetails[(int)CI.MembershipName, cnt].Value) != "")
{
string MembershipName = Convert.ToString(dgvDetails[(int)CI.MembershipName, cnt].Value);
double Amount = Convert.ToDouble(dgvDetails[(int)CI.Amount, cnt].Value);
string Remark = Convert.ToString(dgvDetails[(int)CI.Description, cnt].Value);
strSQL = "INSERT INTO tbl_Package_Details (Package_Details_Id,Package_Id,Membership_name,Amount,Remark)VALUES";
strSQL += "(" + (cnt + 1) + "," + PackageId + ",'" + MembershipName.Trim() + "'," + Amount + ",'" + Remark + "')";
Res = objDb.ExecuteNonQuery(strSQL);
}
}
if (chkIsDefault.Checked)
{
strSQL = "UPDATE tbl_Package SET IsDefault=0 WHERE Package_Id!=" + PackageId;
objDb.ExecuteNonQuery(strSQL);
}
if (Res <= 0)
{
return(false);
}
return(true);
}
catch (Exception exception)
{
MessageBox.Show(Convert.ToString(exception.Message));
this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmStateCity.SaveDetails() " + exception.ToString());
return(false);
}
}
private void btnStart_Click(object sender, EventArgs e)
{
try
{
string strSql = " select * from tbl_ProfilevisitLog where isnull(flag,0)=0 ";
DataTable dtDetails = objDb.GetDataTable(strSql);
if (dtDetails.Rows.Count > 0)
{
richTextBox1.Text = "Total Count :" + dtDetails.Rows.Count;
richTextBox1.Text += Environment.NewLine;
for (int cnt = 0; cnt < dtDetails.Rows.Count; cnt++)
{
int MemberCode = Convert.ToInt32(dtDetails.Rows[cnt]["MemberCode"]);
string VisitProfileId = Convert.ToString(dtDetails.Rows[cnt]["VisitProfileId"]);
string[] VisitProfileId_arr = VisitProfileId.Split(',');
richTextBox1.Text += "Member Code :" + MemberCode;
richTextBox1.Text += Environment.NewLine;
if (VisitProfileId_arr.Length > 0)
{
richTextBox1.Text += "Total Profile :" + VisitProfileId_arr.Length;
richTextBox1.Text += Environment.NewLine;
for (int icnt = 0; icnt < VisitProfileId_arr.Length; icnt++)
{
strSql = " INSERT INTO tbl_ProfilevisitLog_new (MemberCode,ProfileId) VALUES (";
strSql += MemberCode + ",'" + VisitProfileId_arr[icnt] + "')";
objDb.ExecuteNonQuery(strSql);
}
richTextBox1.Text += "Profile transferd :" + MemberCode;
richTextBox1.Text += Environment.NewLine;
strSql = " UPDATE tbl_ProfilevisitLog SET flag=1 WHERE MemberCode=" + MemberCode;
objDb.ExecuteNonQuery(strSql);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int InsertSearchLog(string SearchVal, string SearchName, DateTime SearchDatetime, int UserId)
{
try
{
string strSql = " INSERT INTO tbl_MemberSearchListLog (SearchVal,SearchName,SearchDatetime,UserId) VALUES (";
strSql += "'" + SearchVal + "','" + SearchName + "','" + SearchDatetime.ToString("dd-MMM-yyyy HH:mm:ss") + "'," + UserId + " )";
return(objdb.ExecuteNonQuery(strSql));
}
catch (Exception ex)
{
throw ex;
return(0);
}
}
public void funDelete()
{
try
{
strSQL = "Delete from " + strMasterTable + " where Template_Id =" + txtTemplateId.Text;
Intcout = objDb.ExecuteNonQuery(strSQL);
if (this.Intcout > 0)
{
this.objGlobal.showMessage("Template", "success", this.IsEdit, this.txtTemplateName);
((frmMain)base.MdiParent).setToolbarPositions(ToolbarPositions.eTPOk);
((frmMain)base.MdiParent).setControlState(false, true, this);
this.TpLast = ToolbarPositions.eTPOk;
((frmMain)base.MdiParent).setToolbarPositions(this.TpLast);
this.IsEdit = false;
}
}
catch (Exception exception)
{
MessageBox.Show(Convert.ToString(exception.Message));
this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmSMSTemplateMaster.funDelete() " + exception.ToString());
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtMobileNo.Text == "")
{
MessageBox.Show("Please Enter Mobile number1", "Mobile Number1 validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMobileNo.Focus();
return;
}
else
{
if (Convert.ToInt32(ddlMobileNo_Rel.SelectedValue) <= 0)
{
MessageBox.Show("Please Select Mobile Number 1 Relation", "Mobile Number 1 validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
ddlMobileNo_Rel.Focus();
return;
}
}
if (txtMobileNo1.Text == "")
{
MessageBox.Show("Please Enter Mobile number2", "Mobile Number2 validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMobileNo1.Focus();
return;
}
else
{
if (Convert.ToInt32(ddlMobileNo1_Rel.SelectedValue) <= 0)
{
MessageBox.Show("Please Select Mobile Number 2 Relation", "Mobile Number 2 validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
ddlMobileNo_Rel.Focus();
return;
}
}
if (txtLandlineNo.Text != "")
{
if (Convert.ToInt32(ddlMobileNo2_Rel.SelectedValue) <= 0)
{
MessageBox.Show("Please Select Mobile Number 3 Relation", "Mobile Number 3 validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
ddlMobileNo2_Rel.Focus();
return;
}
}
if (txtLandlineNo1.Text != "")
{
if (Convert.ToInt32(ddlLandlineNo1_Rel.SelectedValue) <= 0)
{
MessageBox.Show("Please Select Mobile Number 4 Relation", "Mobile Number 4 validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
ddlLandlineNo1_Rel.Focus();
return;
}
}
if (lblMemberCode.Text != "")
{
strSql = " UPDATE tbl_membermaster SET MobileNo='" + txtMobileNo.Text.Trim() + "' , MobileNo_Rel='" + ddlMobileNo_Rel.Text + "'";
if (txtMobileNo1.Text.Trim() != "")
{
strSql += " , MobileNo1='" + txtMobileNo1.Text.Trim() + "' , MobileNo1_Rel='" + ddlMobileNo1_Rel.Text + "'";
}
if (txtLandlineNo.Text.Trim() != "")
{
strSql += " , LandlineNo='" + txtLandlineNo.Text.Trim() + "' , MobileNo2_Rel='" + ddlMobileNo2_Rel.Text + "'";
}
if (txtLandlineNo1.Text.Trim() != "")
{
strSql += " , LandlineNo1='" + txtLandlineNo1.Text.Trim() + "' , LandlineNo1_Rel='" + ddlLandlineNo1_Rel.Text + "'";
}
strSql += " WHERE MemberCode=" + lblMemberCode.Text;
int Res = objDb.ExecuteNonQuery(strSql);
if (Res > 0)
{
MessageBox.Show(txtProfileId.Text + " Contact Details Updated", "Mobile Number 4 validation", MessageBoxButtons.OK, MessageBoxIcon.Information);
lblMemberCode.Text = "";
txtLandlineNo.Text = "";
txtLandlineNo1.Text = "";
txtMobileNo.Text = "";
txtMobileNo1.Text = "";
txtProfileId.Text = "";
FillGrid();
}
}
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex.Message));
}
}