public void UpdateData()
{
try
{
DataTable dtM = new DataTable();
DataTable dtA = new DataTable();
dtA = m_dt.GetChanges(DataRowState.Added);
dtM = m_dt.GetChanges(DataRowState.Modified);
if (dtA != null)
{
for (int i = 0; i < dtA.Rows.Count; i++)
{
ComplaintDetBL.InsertCompliantMaater(dtA.Rows[i]["NatureComplaint"].ToString());
//sql = String.Format("INSERT INTO Nature_Complaint (NatureComplaint) VALUES('{0}')", dtA.Rows[i]["NatureComplaint"]);
// CommFun.CRMExecute(sql);
}
}
if (dtM != null)
{
for (int i = 0; i < dtM.Rows.Count; i++)
{
ComplaintDetBL.UpdateCompliantMaater(dtM.Rows[i]["NatureComplaint"].ToString(), Convert.ToInt32(dtM.Rows[i]["ComplaintId"]));
//sql = String.Format("UPDATE Nature_Complaint SET NatureComplaint='{0}' WHERE ComplaintId={1} ", dtM.Rows[i]["NatureComplaint"], dtM.Rows[i]["ComplaintId"]);
// CommFun.CRMExecute(sql);
}
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void FillData()
{
try
{
m_dt = new DataTable();
m_dt = ComplaintDetBL.Populate_ComplaintRegister(Convert.ToDateTime(dtpFrmDate.EditValue), Convert.ToDateTime(dtpToDate.EditValue));
DGvTrans.DataSource = m_dt;
DGvTransView.PopulateColumns();
DGvTransView.Columns["ComplaintId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
DGvTransView.Columns["ComplaintNo"].Width = 75;
DGvTransView.Columns["CostCentreName"].Width = 100;
DGvTransView.Columns["AttendedBy"].Width = 100;
DGvTransView.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
DGvTransView.Columns["TransDate"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["DateAttented"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["Approve"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["ComplaintNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["ComplaintNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["FlatNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["FlatNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["TransDate"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["TransDate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["DateAttented"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["DateAttented"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["Approve"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.OptionsCustomization.AllowFilter = true;
DGvTransView.OptionsBehavior.AllowIncrementalSearch = true;
DGvTransView.OptionsView.ShowAutoFilterRow = true;
DGvTransView.OptionsView.ShowViewCaption = false;
DGvTransView.OptionsView.ShowFooter = false;
DGvTransView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
DGvTransView.OptionsSelection.InvertSelection = false;
DGvTransView.OptionsView.ColumnAutoWidth = true;
DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
DGvTransView.FocusedRowHandle = 0;
DGvTransView.FocusedColumn = DGvTransView.VisibleColumns[0];
DGvTransView.Appearance.FocusedCell.BackColor = Color.Teal;
DGvTransView.Appearance.FocusedCell.ForeColor = Color.White;
DGvTransView.Appearance.FocusedRow.ForeColor = Color.Black;
DGvTransView.Appearance.FocusedRow.BackColor = Color.White;
DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Complaint Master-Delete") == false)
{
MessageBox.Show("You don't have Rights to Complaint Master-Delete");
return;
}
int i_RegId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "ComplaintId"), CommFun.datatypes.vartypenumeric));
ComplaintDetBL.DeleteCompMaster(i_RegId);
FillData();
}
public void GetData()
{
try
{
GetComplaint();
DataTable dtPpro = new DataTable();
dtPpro = ComplaintDetBL.PopulateProject(BsfGlobal.g_lUserId);
cboProj.Properties.DataSource = CommFun.AddSelectToDataTable(dtPpro);
cboProj.Properties.ForceInitialize();
cboProj.Properties.PopulateColumns();
cboProj.Properties.DisplayMember = "CostCentreName";
cboProj.Properties.ValueMember = "CostCentreId";
cboProj.Properties.Columns["CostCentreId"].Visible = false;
cboProj.Properties.ShowFooter = false;
cboProj.Properties.ShowHeader = false;
cboProj.ItemIndex = 0;
DataTable dtExe = new DataTable();
dtExe = ComplaintDetBL.PopulateExecutive();
cboExec.Properties.DataSource = CommFun.AddSelectToDataTable(dtExe);
cboExec.Properties.PopulateColumns();
cboExec.Properties.DisplayMember = "ExecName";
cboExec.Properties.ValueMember = "ExecId";
cboExec.Properties.Columns["ExecId"].Visible = false;
cboExec.Properties.Columns["Sel"].Visible = false;
cboExec.Properties.ShowFooter = false;
cboExec.Properties.ShowHeader = false;
cboExec.ItemIndex = 0;
DataTable dtEmp = new DataTable();
dtEmp = ComplaintDetBL.PopulateEmployee();
cboAttnExec.Properties.DataSource = CommFun.AddSelectToDataTable(dtEmp);
cboAttnExec.Properties.PopulateColumns();
cboAttnExec.Properties.DisplayMember = "ExecName";
cboAttnExec.Properties.ValueMember = "ExecId";
cboAttnExec.Properties.Columns["ExecId"].Visible = false;
cboAttnExec.Properties.Columns["Sel"].Visible = false;
cboAttnExec.Properties.ShowFooter = false;
cboAttnExec.Properties.ShowHeader = false;
cboAttnExec.ItemIndex = 0;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void FillData()
{
try
{
m_dt = new DataTable();
m_dt = ComplaintDetBL.PopulateNatureComp();
DGVTrans.DataSource = m_dt;
DGvTransView.Columns["ComplaintId"].Visible = false;
DGvTransView.Columns["NatureComplaint"].BestFit();
m_dt.GetChanges();
m_dt.Dispose();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void FillData()
{
try
{
m_dtComp = new DataTable();
m_dtComp = ComplaintDetBL.Fill_ComplaintRegister(m_iComplaintId);
if (m_dtComp.Rows.Count > 0)
{
cboProj.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["CostCentreId"].ToString());
cboFlatNo.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["FlatId"].ToString());
cboExec.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["ExecutiveId"].ToString());
cboNature.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["NatureId"].ToString());
txtBuyer.Properties.ReadOnly = true;
txtBuyer.Tag = Convert.ToInt32(m_dtComp.Rows[0]["LeadId"].ToString());
txtRemarks.Text = m_dtComp.Rows[0]["Remarks"].ToString();
dtCompDate.EditValue = Convert.ToDateTime(m_dtComp.Rows[0]["TransDate"].ToString());
m_dOldDate = Convert.ToDateTime(dtCompDate.EditValue);
textCmpNo.Text = m_dtComp.Rows[0]["complaintNo"].ToString();
textCmpNo.Properties.ReadOnly = true;
dtAttendDate.EditValue = Convert.ToDateTime(m_dtComp.Rows[0]["AttDate"].ToString());
cboAttnExec.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["ExeAttnId"].ToString());
txtAttnRemark.Text = m_dtComp.Rows[0]["AttnRemarks"].ToString();
m_sExtracharge = m_dtComp.Rows[0]["ChargeType"].ToString();
if (m_sExtracharge == "N")
{
radioGroup1.SelectedIndex = 0;
}
else
{
radioGroup1.SelectedIndex = 1;
}
if (m_dtComp.Rows[0]["Approve"].ToString() == "Y")
{
btnSave.Enabled = false;
}
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void ChangeGridValue(int argEntryId)
{
DataTable dt = new DataTable();
dt = ComplaintDetBL.Populate_ComplaintRegisterChange(argEntryId);
int iRowId = frmComplaintRegister.m_oGridMasterView.FocusedRowHandle;
if (dt.Rows.Count > 0)
{
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "TransDate", Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["TransDate"], CommFun.datatypes.VarTypeDate)).ToString("dd/MM/yyyy"));
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "ComplaintNo", CommFun.IsNullCheck(dt.Rows[0]["ComplaintNo"], CommFun.datatypes.vartypestring).ToString());
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "CostCentreName", CommFun.IsNullCheck(dt.Rows[0]["CostCentreName"], CommFun.datatypes.vartypestring).ToString());
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "FlatNo", CommFun.IsNullCheck(dt.Rows[0]["FlatNo"], CommFun.datatypes.vartypestring).ToString());
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "NatureComplaint", CommFun.IsNullCheck(dt.Rows[0]["NatureComplaint"], CommFun.datatypes.vartypestring).ToString());
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "AttendedBy", CommFun.IsNullCheck(dt.Rows[0]["AttendedBy"], CommFun.datatypes.vartypestring).ToString());
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "DateAttented", Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["DateAttented"], CommFun.datatypes.VarTypeDate)).ToString("dd/MM/yyyy"));
frmComplaintRegister.m_oGridMasterView.SetRowCellValue(iRowId, "Approve", CommFun.IsNullCheck(dt.Rows[0]["Approve"], CommFun.datatypes.vartypestring).ToString());
}
dt.Dispose();
}
public void GetComplaint()
{
try
{
DataTable dtNcom = new DataTable();
dtNcom = ComplaintDetBL.PopulateNature();
cboNature.Properties.DataSource = CommFun.AddSelectToDataTable(dtNcom);
cboNature.Properties.PopulateColumns();
cboNature.Properties.DisplayMember = "NatureComplaint";
cboNature.Properties.ValueMember = "ComplaintId";
cboNature.Properties.Columns["ComplaintId"].Visible = false;
cboNature.Properties.ShowFooter = false;
cboNature.Properties.ShowHeader = false;
cboNature.ItemIndex = 0;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (DGvTransView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Complaint-Entry-Delete") == false)
{
MessageBox.Show("You don't have Rights to ComplaintRegister-Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
try
{
int i_RegId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "ComplaintId"), CommFun.datatypes.vartypenumeric));
string m_sIssNo = "";
int m_iCCId1 = 0;
string Apv = "";
m_iCCId1 = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "CostCentreId"), CommFun.datatypes.vartypenumeric));
m_sIssNo = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "ComplaintNo"), CommFun.datatypes.vartypestring));
Apv = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "Approve"), CommFun.datatypes.vartypestring));
if (Apv == "Y")
{
MessageBox.Show("Already Approved, Do Not Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (ComplaintDetBL.DeleteCompRegister(i_RegId, m_iCCId1, m_sIssNo) == true)
{
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
}
//CommFun.InsertLog(DateTime.Now, "ComplaintRegister-Delete", "D", "Delete ComplaintRegister", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public frmComplaintEntry()
{
oComtBL = new ComplaintDetBL();
InitializeComponent();
}
public void UpdateData()
{
try
{
if (radioGroup1.SelectedIndex == 0)
{
m_sExtracharge = "N";
}
else
{
m_sExtracharge = "Y";
}
if (cboProj.EditValue != null && cboNature.EditValue != null && Convert.ToInt32(cboNature.EditValue) > 0 && textCmpNo.Text != null && textCmpNo.Text != string.Empty)
{
if (m_iComplaintId == 0)
{
string sAlert = "";
sAlert = cboNature.Text + " at " + cboProj.Text + " Flat No : " + cboFlatNo.Text;
//// --- Mail Sent to Tenant while Entering the complaint Entry -----
//Body = "<table style='background-color: #FFFFCC'><tr><td colspan='2' align='center' style='font-size: 20px; color: Maroon; border-style:groove;'>";
//Body += "<b> Complaint Entry Register</b></td></tr><tr><td colspan='2'></td></tr><tr style='width: 600px; height: 25px;'><td style='width: 200px;'>Project Name : ";
//Body += "</td><td style='width: 300px;'><b><i>" + cboProj.Text + "</i></b></td> </tr><tr><td style='width: 200px;'>Flat No : </td><td style='width: 300px;'><b><i>" + cboFlatNo.Text + "</i></b></td></tr>";
//Body += "<tr style='width: 600px; height: 25px;'><td style='width: 200px;'>Tenant Name : ";
//Body += " </td><td style='width: 300px;'><b><i>" + txtTenant.Text + "</i></b></td> </tr><tr><td style='width: 200px;'>Complaint No : </td><td style='width: 300px;'><b><i>" + textCmpNo.Text + "</i></b></td></tr>";
//Body += "<tr><td style='width: 200px;'>Nature Of Complaint :</td>";
//Body += "<td style='width: 300px;'><b><i>" + cboNature.Text + "</i></b></td></tr><tr><td style='width: 200px;'>Attented By :</td><td style='width: 300px;'><b><i>" + cboExec.Text + "</i></b></td>";
//Body += "</tr><tr><td style='width: 200px;'>Date Attented By :</td><td style='width: 300px;'><b><i>" + dtAttendDate.Value + "</i></b></td></tr><tr><td colspan='2'></td></tr>";
//Body += "<tr><td colspan='2' align='right' style='font-size: 14px; color: Maroon;'><b>[email protected]</b></td></tr> <tr><td colspan='2' align='right' style='font-size: 14px; color: Maroon; border-style: solid;'><i>Micromen.com</i></td></tr></table>";
//string sqlEmail;
//DataTable CheckEmail;
//sqlEmail = String.Format("select TenantName,Email from TenantDet where TenantId={0}", txtTenant.Tag);
//CheckEmail = new DataTable();
//CheckEmail = CommFun.FillRecord(sqlEmail);
//if (CheckEmail.Rows.Count >= 1)
//{
// To = CheckEmail.Rows[0]["Email"].ToString();
//}
//// ---Mail End
if (m_sExtracharge == "Y" && cboFlatNo.EditValue != null)
{
// string sqlchk;
DataTable Check = new DataTable();
//sqlchk = String.Format("SELECT C.ComplaintId,C.CostCentreId,C.FlatId,C.LeadId,C.TenantId,C.NatureId, C.ExecutiveId,C.TransDate,C.AttDate DateAttented,E.EmployeeName AttendedBy,F.FlatNo,C1.CostCentreName, C.Remarks FROM Complaint_Entry C INNER JOIN FlatDetails F ON C.FlatId=F.FlatId INNER JOIN BuyerDetail B ON C.LeadId=B.LeadId INNER JOIN [{0}].dbo.OperationalCostCentre C1 ON C.CostCentreId=C1.CostCentreId INNER JOIN [{0}].dbo.Users E ON C.ExecutiveId=E.UserId where F.FlatId={1} and C.chargetype='Y' ORDER BY DateAttented", BsfGlobal.g_sWorkFlowDBName, cboFlatNo.EditValue);
Check = ComplaintDetBL.CompliantCheck(Convert.ToInt32(cboFlatNo.EditValue));
if (Check.Rows.Count >= 1)
{
MessageBox.Show("Already submit the complaint", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
else
{
oComtBO = new ComplaintDetBO();
ComplaintDetBO.CostCentreId = Convert.ToInt32(CommFun.IsNullCheck(cboProj.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.FlatId = Convert.ToInt32(CommFun.IsNullCheck(cboFlatNo.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.BuyerId = Convert.ToInt32(CommFun.IsNullCheck(txtBuyer.Tag, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.TransDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtCompDate.EditValue, CommFun.datatypes.VarTypeDate));
ComplaintDetBO.NatureId = Convert.ToInt32(CommFun.IsNullCheck(cboNature.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.ExecutiveId = Convert.ToInt32(CommFun.IsNullCheck(cboExec.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.AttDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtAttendDate.EditValue, CommFun.datatypes.VarTypeDate));
ComplaintDetBO.Remarks = CommFun.IsNullCheck(txtRemarks.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.complaintNo = CommFun.IsNullCheck(textCmpNo.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.ChargeTYpe = m_sExtracharge;
ComplaintDetBO.AttnRemarks = CommFun.IsNullCheck(txtAttnRemark.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.ExeAttnId = Convert.ToInt32(CommFun.IsNullCheck(cboAttnExec.EditValue, CommFun.datatypes.vartypenumeric));
bSuccess = ComplaintDetBL.InsertCompDetails(sAlert);
BsfGlobal.UpdateMaxNo(28, oVType, 0, 0);
// Body = "<table><tr><td colspan='2' align='center' style='font-size: 20px; color: Maroon; border-style:groove;'>";
// Body += "<b> Complaint Entry Register</b></td></tr><tr><td colspan='2'></td></tr><tr style='width: 600px; height: 25px;'><td style='width: 200px;'>Project Name : ";
// Body += "</td><td style='width: 300px;'><b><i>" + cboProj.Text + "</i></b></td> </tr><tr><td style='width: 200px;'>Flat No : </td><td style='width: 300px;'><b><i>" + cboFlatNo.Text + "</i></b></td></tr><tr><td style='width: 200px;'>Nature Of Complaint :</td>";
// Body += "<td style='width: 300px;'><b><i>" + cboNature.Text + "</i></b></td></tr><tr><td style='width: 200px;'>Attented By :</td><td style='width: 300px;'><b><i>" + cboExec.Text + "</i></b></td>";
// Body += "</tr><tr><td style='width: 200px;'>Date Attented By :</td><td style='width: 300px;'><b><i>" + dtAttendDate.Value + "</i></b></td></tr><tr><td colspan='2'></td></tr>";
//Body += "<tr><td colspan='2' align='right' style='font-size: 14px; color: Maroon;'><b>[email protected]</b></td></tr> <tr><td colspan='2' align='right' style='font-size: 14px; color: Maroon;'><i>Micromen.com</i></td></tr></table>";
//----- Mail Deliver---
// SendMail("Retrieve Complaint Entry", Body, true, "*****@*****.**", To, CC, BCC, "smtp.gmail.com", 587, "*****@*****.**", "micromen");
}
}
else
{
oComtBO = new ComplaintDetBO();
ComplaintDetBO.CostCentreId = Convert.ToInt32(CommFun.IsNullCheck(cboProj.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.FlatId = Convert.ToInt32(CommFun.IsNullCheck(cboFlatNo.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.BuyerId = Convert.ToInt32(CommFun.IsNullCheck(txtBuyer.Tag, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.TransDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtCompDate.EditValue, CommFun.datatypes.VarTypeDate));
ComplaintDetBO.NatureId = Convert.ToInt32(CommFun.IsNullCheck(cboNature.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.ExecutiveId = Convert.ToInt32(CommFun.IsNullCheck(cboExec.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.AttDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtAttendDate.EditValue, CommFun.datatypes.VarTypeDate));
ComplaintDetBO.Remarks = CommFun.IsNullCheck(txtRemarks.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.complaintNo = CommFun.IsNullCheck(textCmpNo.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.ChargeTYpe = m_sExtracharge;
ComplaintDetBO.AttnRemarks = CommFun.IsNullCheck(txtAttnRemark.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.ExeAttnId = Convert.ToInt32(CommFun.IsNullCheck(cboAttnExec.EditValue, CommFun.datatypes.vartypenumeric));
bSuccess = ComplaintDetBL.InsertCompDetails(sAlert);
BsfGlobal.UpdateMaxNo(28, oVType, 0, 0);
//----- Mail Deliver---
//SendMail("Retrieve Complaint Entry", Body, true, "*****@*****.**", To, CC, BCC, "smtp.gmail.com", 587, "*****@*****.**", "micromen");
}
}
else
{
oComtBO = new ComplaintDetBO();
ComplaintDetBO.ComplaintId = m_iComplaintId;
ComplaintDetBO.CostCentreId = Convert.ToInt32(CommFun.IsNullCheck(cboProj.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.FlatId = Convert.ToInt32(CommFun.IsNullCheck(cboFlatNo.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.BuyerId = Convert.ToInt32(CommFun.IsNullCheck(txtBuyer.Tag, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.TransDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtCompDate.EditValue, CommFun.datatypes.VarTypeDate));
ComplaintDetBO.NatureId = Convert.ToInt32(CommFun.IsNullCheck(cboNature.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.ExecutiveId = Convert.ToInt32(CommFun.IsNullCheck(cboExec.EditValue, CommFun.datatypes.vartypenumeric));
ComplaintDetBO.AttDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtAttendDate.EditValue, CommFun.datatypes.VarTypeDate));
ComplaintDetBO.Remarks = CommFun.IsNullCheck(txtRemarks.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.complaintNo = CommFun.IsNullCheck(textCmpNo.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.ChargeTYpe = m_sExtracharge;
ComplaintDetBO.AttnRemarks = CommFun.IsNullCheck(txtAttnRemark.Text, CommFun.datatypes.vartypestring).ToString();
ComplaintDetBO.ExeAttnId = Convert.ToInt32(CommFun.IsNullCheck(cboAttnExec.EditValue, CommFun.datatypes.vartypenumeric));
if (Convert.ToDateTime(ComplaintDetBO.TransDate) != Convert.ToDateTime(dtCompDate.EditValue))
{
oVType = new BsfGlobal.VoucherType();
if (oVType.PeriodWise == true)
{
if (BsfGlobal.CheckPeriodChange(Convert.ToDateTime(ComplaintDetBO.TransDate), Convert.ToDateTime(dtCompDate.EditValue)) == true)
{
oVType = BsfGlobal.GetVoucherNo(28, Convert.ToDateTime(dtCompDate.EditValue), 0, 0);
textCmpNo.Text = oVType.VoucherNo;
BsfGlobal.UpdateMaxNo(28, oVType, 0, 0);
}
}
}
bSuccess = ComplaintDetBL.UpdateCompDetails();
}
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
