private void UpdateChecklIst()
{
m_lGridId = 0;
if (m_bAdd == false)
{
m_lGridId = Convert.ToInt32(grdViewDoc.GetRowCellValue(grdViewDoc.FocusedRowHandle, "CheckListId"));
}
oChkLstBo = new CheckListBO()
{
CheckListId = m_lGridId, CheckListName = (grdViewDoc.GetFocusedRowCellValue("CheckListName").ToString()), TypeName = m_sType
};
if (m_bAdd == true)
{
m_bAns = true;
oChkLstBo.SortOrder = grdViewDoc.RowCount;
int iCId = BankBL.InsertCheckList(oChkLstBo);
grdViewDoc.SetRowCellValue(grdViewDoc.FocusedRowHandle, "CheckListId", iCId);
grdViewDoc.SetRowCellValue(grdViewDoc.FocusedRowHandle, "SysDefault", false);
grdViewDoc.SetRowCellValue(grdViewDoc.FocusedRowHandle, "SortOrder", oChkLstBo.SortOrder);
//CommFun.InsertLog(DateTime.Now, "Check List-Add", "N", "Add Check List", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Check List-Add", "N", "Add Check List", m_lGridId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
m_bAns = false;
}
else
{
BankBL.UpdateCheckList(oChkLstBo);
//CommFun.InsertLog(DateTime.Now, "Check List-Edit", "E", "Edit Check List", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Check List-Edit", "E", "Edit Check List", m_lGridId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
public void UpdateExtra()
{
string sql = "";
SqlCommand cmd;
try
{
if (ExtraItemId == 0)
{
sql = String.Format("INSERT INTO ExtraItemMaster(ExtraItemTypeId,ItemCode,ItemDescription,UnitId,ExtraRate) VALUES({0}, '{1}', '{2}','{3}','{4}' ) SELECT SCOPE_IDENTITY();", Convert.ToInt32(cboItemType.EditValue), textItemCode.Text, txtDescription.Text, Convert.ToInt32(cboUnit.EditValue), Convert.ToDecimal(txtRate.Text));
cmd = new SqlCommand(sql, BsfGlobal.OpenCRMDB());
ExtraItemId = Convert.ToInt32(cmd.ExecuteScalar().ToString());
//CommFun.InsertLog(DateTime.Now, "ExtraItem Register-Add", "N", "Add ExtraItem Register", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "ExtraItem Register-Add", "N", "Add ExtraItem Register", ExtraItemId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
else
{
sql = String.Format("UPDATE ExtraItemMaster SET ExtraItemTypeId={0}, ItemCode='{1}',ItemDescription='{2}',UnitId='{3}', ExtraRate='{4}' WHERE ExtraItemId={5}", Convert.ToInt32(cboItemType.EditValue), textItemCode.Text, txtDescription.Text, Convert.ToInt32(cboUnit.EditValue), Convert.ToDecimal(txtRate.Text), ExtraItemId);
cmd = new SqlCommand(sql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "ExtraItem Register-Edit", "E", "Edit ExtraItem Register", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "ExtraItem Register-Edit", "E", "Edit ExtraItem Register", ExtraItemId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
catch (Exception e)
{
throw e;
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("ExtraItem Register-Delete") == false)
{
MessageBox.Show("You don't have Rights to ExtraItem Register-Delete");
return;
}
try
{
if (grdExtraView.FocusedRowHandle >= 0)
{
string sql;
if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
sql = String.Format("DELETE FROM ExtraItemMaster where ExtraItemId={0}", Convert.ToInt32(grdExtraView.GetFocusedRowCellValue("ExtraItemId")));
CommFun.CRMExecute(sql);
grdExtraView.DeleteRow(grdExtraView.FocusedRowHandle);
//CommFun.InsertLog(DateTime.Now, "ExtraItem Register-Delete", "D", "Delete ExtraItem Register", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "ExtraItem Register-Delete", "D", "Delete ExtraItem Register", Convert.ToInt32(grdExtraView.GetFocusedRowCellValue("ExtraItemId")), 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (DGvTransView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Bank-Delete") == false)
{
MessageBox.Show("You don't have Rights to Bank-Delete");
return;
}
int iBranchId = Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("BranchId"));
if (BankBL.BankFound(iBranchId) == false)
{
if (MessageBox.Show("Do You want to Delete?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
BankBL.DeleteBankBranch(iBranchId);
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
//CommFun.InsertLog(DateTime.Now, "Bank Master-Delete", "D", "Delete Bank Master", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Bank Master-Delete", "D", "Delete Bank Master", iBranchId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
else
{
MessageBox.Show("Bank Details Used, Can't Delete Row", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Lead-Delete") == false)
{
MessageBox.Show("You don't have Rights to Lead-Delete");
return;
}
try
{
if (DGvTransView.FocusedRowHandle >= 0)
{
if (Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("LeadId")) == 0)
{
string sql = string.Empty;
sql = "DELETE FROM LeadRegister WHERE LeadId=" + Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("LeadId")) + " ";
CommFun.CRMExecute(sql);
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
//CommFun.InsertLog(DateTime.Now, "Lead Details-Delete", "D", "Delete Lead Details", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Lead Details-Delete", "D", "Delete Lead Details", Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("LeadId")), 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
else
{
MessageBox.Show("Already Converted Can't Delete", "CRM");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Post-Followup-Delete") == false)
{
MessageBox.Show("You don't have Rights to Post-Followup-Delete");
return;
}
if (grdViewCall.FocusedRowHandle < 0)
{
return;
}
try
{
int iEntryId = Convert.ToInt32(grdViewCall.GetFocusedRowCellValue("EntryId"));
if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
CallSheetEntryBL.DeleteFollowUp(iEntryId);
grdViewCall.DeleteRow(grdViewCall.FocusedRowHandle);
BsfGlobal.InsertLog(DateTime.Now, "Post-Followup-Delete", "D", "Post-Followup", iEntryId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool InsertSerOrderBill(DataTable dtComPList, DataTable argQTrans)
{
int iFRegId = 0;
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
//sSql = String.Format("INSERT INTO FlatType(ProjId,Typename,Area,USLandArea,LandRate,LandAmount,Rate,BaseAmt,AdvAmount,OtherCostAmt,TotalCarPark,NetAmt,PayTypeId,Remarks) Values({0},'{1}',{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},'{13}') SELECT SCOPE_IDENTITY(); ", OUnitDirBO.ProjId, OUnitDirBO.TypeName, OUnitDirBO.Area, OUnitDirBO.USLandArea, OUnitDirBO.LandRate, OUnitDirBO.LandAmount, OUnitDirBO.Rate, OUnitDirBO.BaseAmt, OUnitDirBO.AdvAmount, OUnitDirBO.OtherCostAmt, OUnitDirBO.TotalCarpark, OUnitDirBO.NetAmt, OUnitDirBO.PayTypeId, OUnitDirBO.Remarks);
sSql = String.Format("INSERT INTO SerOrderBillReg(Billdate,BillRefNo,CostcentreID,FlatID,GrossAmt,NetAmt,Narration,QuoteRegId,QualifierAmt) Values('{0}','{1}',{2},{3},'{4}','{5}','{6}',{7},'{8}') SELECT SCOPE_IDENTITY()", ServiceOrderBillBO.Billdate, ServiceOrderBillBO.BillRefNo, ServiceOrderBillBO.CostcentreID, ServiceOrderBillBO.FlatID, ServiceOrderBillBO.GrossAmt, ServiceOrderBillBO.NetAmt, ServiceOrderBillBO.Narration, ServiceOrderBillBO.QuoteRegId, ServiceOrderBillBO.QualifierAmt);
cmd = new SqlCommand(sSql, conn, tran);
iFRegId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
if (dtComPList.Rows.Count > 0)
{
for (int k = 0; k < dtComPList.Rows.Count; k++)
{
sSql = String.Format("INSERT INTO SerOrderBillTrans(BillRegId,ServiceID,Amount) values({0},{1},'{2}')", iFRegId, (dtComPList.Rows[k]["ServiceID"]), dtComPList.Rows[k]["Amount"]);
//CommFun.CRMExecute(sSql);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
//Bill Qualifier
for (int u = 0; u < argQTrans.Rows.Count; u++)
{
sSql = "Insert Into ServiceOrderBillRateQ (BillRegId,QualifierId,Expression,ExpPer,Add_Less_Flag,SurCharge,EDCess,Amount,ExpValue,ExpPerValue,SurValue,EdValue) " +
"Values (" + iFRegId + "," + argQTrans.Rows[u]["QualifierId"].ToString() + ",'" + argQTrans.Rows[u]["Expression"].ToString() + "'," + argQTrans.Rows[u]["ExpPer"].ToString() + ",'" + argQTrans.Rows[u]["Add_Less_Flag"].ToString() + "'," + argQTrans.Rows[u]["SurCharge"].ToString() + "," + argQTrans.Rows[u]["EDCess"].ToString() + "," + argQTrans.Rows[u]["Amount"].ToString() + "," + argQTrans.Rows[u]["ExpValue"].ToString() + "," + argQTrans.Rows[u]["ExpPerValue"].ToString() + "," + argQTrans.Rows[u]["SurValue"].ToString() + "," + argQTrans.Rows[u]["EdValue"].ToString() + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
}
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "CRM-ServiceBill-Add", "N", "CRM-ServiceBill", iFRegId, ServiceOrderBillBO.CostcentreID, 0, BsfGlobal.g_sCRMDBName, ServiceOrderBillBO.BillRefNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
public static bool UpdateRentDetails(int argTransId, DataTable dtGrid)
{
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = String.Format("UPDATE RentDetail SET RefNo='{0}', TenantId='{1}', CostCentreId={2},FlatId={3}, RegDate='{4}', StartDate='{5}',EndDate='{6}',Rent='{7}',RentDuration='{8}',Advance='{9}' ,IntRate={10},IntDuration='{11}',Terms='{12}',RenewType='{13}',GracePriod={14},RentType='{15}',NetRent='{16}',AgreementNo='{17}' WHERE RentId={18}", RentDetBO.RefNo, RentDetBO.TenantId, RentDetBO.CostCentreId, RentDetBO.FlatId, RentDetBO.RegDate, RentDetBO.StartDate, RentDetBO.EndDate, RentDetBO.Rent, RentDetBO.RentDuration, RentDetBO.Advance, RentDetBO.IntRate, RentDetBO.IntDuration, RentDetBO.Terms, RentDetBO.RenewType, RentDetBO.GracePriod, RentDetBO.RentType, RentDetBO.NetRent, RentDetBO.AgreementNo, RentDetBO.RentId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = String.Format("UPDATE RentAgreementTrans SET RefNo='{0}',RegDate='{1}',StartDate='{2}',EndDate='{3}',Rent='{4}',NetRent='{5}',RentDuration='{6}',Advance='{7}',IntRate='{8}',IntDuration='{9}',Terms='{10}',RenewType='{11}',GracePriod='{12}',RentType='{13}' WHERE RentTransId={14} ", RentDetBO.RefNo, RentDetBO.RegDate, RentDetBO.StartDate, RentDetBO.EndDate, RentDetBO.Rent, RentDetBO.NetRent, RentDetBO.RentDuration, RentDetBO.Advance, RentDetBO.IntRate, RentDetBO.IntDuration, RentDetBO.Terms, RentDetBO.RenewType, RentDetBO.GracePriod, RentDetBO.RentType, argTransId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = String.Format("DELETE FROM RentSchTrans WHERE RentTransId={0}", argTransId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (dtGrid.Rows.Count > 0)
{
for (int a = 0; a < dtGrid.Rows.Count; a++)
{
sSql = String.Format("INSERT INTO Rentschtrans(RentTransId,Date,Rent) values({0},'{1:dd-MMM-yyyy}',{2})", argTransId, Convert.ToDateTime(dtGrid.Rows[a]["Date"]), dtGrid.Rows[a]["Amount"]);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Rent-Edit", "E", "Rent", RentDetBO.RentId, RentDetBO.CostCentreId, 0, BsfGlobal.g_sCRMDBName, RentDetBO.RefNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
public static void InsertAllotment(int argCCId, int argFlatId, int argBuyerId, decimal argNetAmt, decimal argPaidAmt, decimal argPenaltyAmt, decimal argBalAmt, DateTime argDate,
string argCancelType, string argRemarks, int argBlockId, string argFlatNo, DataTable dtChk, bool argChkSend, string argCCName)
{
SqlConnection conn = new SqlConnection();
conn = BsfGlobal.OpenCRMDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
string sSql = "INSERT INTO dbo.AllotmentCancel(CostCentreId,FlatId,BuyerId,NetAmount,PaidAmount,PenaltyAmt,BalanceAmount,CancelDate,AllotType,Remarks) VALUES " +
" (" + argCCId + "," + argFlatId + "," + argBuyerId + "," + argNetAmt + "," + argPaidAmt + "," + argPenaltyAmt + "," + argBalAmt + ", " +
" '" + string.Format("{0:dd/MMM/yyyy}", Convert.ToDateTime(CommFun.IsNullCheck(argDate, CommFun.datatypes.VarTypeDate))) + "', " +
" '" + argCancelType + "','" + argRemarks + "') SELECT SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sSql, conn, tran);
int iCancelId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
sSql = string.Format("Select * from dbo.FlatCarPark Where CostCentreId={0} AND FlatId={1}", argCCId, argFlatId);
cmd = new SqlCommand(sSql, conn, tran);
DataTable dt = new DataTable();
SqlDataReader dreader = cmd.ExecuteReader();
dt.Load(dreader);
dreader.Close();
cmd.Dispose();
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
sSql = string.Format("Insert into dbo.CancelledCarPark(CancelId, CostCentreId, FlatId, TypeId, TotalCP) Values({0}, {1}, {2}, {3}, {4})",
iCancelId, argCCId, argFlatId, Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["TypeId"], CommFun.datatypes.vartypenumeric)),
Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["TotalCP"], CommFun.datatypes.vartypenumeric)));
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
CRM.BusinessLayer.UnitDirBL.InsertFlatCheckList(dtChk, argFlatId, "C", argChkSend, argCCId, argFlatNo);
string sStr = "Flat No-" + argFlatNo + " in " + argCCName + " is Cancelled";
BsfGlobal.InsertAlert("CRM-Flat-Cancel", sStr, argCCId, BsfGlobal.g_sCRMDBName);
tran.Commit();
BsfGlobal.InsertLog(DateTime.Now, "Flat-Cancellation-Create", "N", "Flat-Cancellation", iCancelId, argCCId, 0,
BsfGlobal.g_sCRMDBName, argFlatNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Dispose();
conn.Close();
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (grdPBRegView.FocusedRowHandle >= 0)
{
if (BsfGlobal.FindPermission("Progress Bill-Delete") == false)
{
MessageBox.Show("You don't have Rights to Progress Bill-Delete");
return;
}
int iProgRegId = Convert.ToInt32(grdPBRegView.GetRowCellValue(grdPBRegView.FocusedRowHandle, "ProgRegId"));
int iCCId = Convert.ToInt32(grdPBRegView.GetRowCellValue(grdPBRegView.FocusedRowHandle, "CostCentreId"));
bool bAns = ProgBillBL.GetApprFound(iProgRegId, iCCId);
if (bAns == true)
{
MessageBox.Show("Bill Approved, Do not Delete");
return;
}
bAns = ProgBillBL.GetReceiptRaised(iProgRegId, iCCId);
if (bAns == true)
{
MessageBox.Show("Receipt Raised, Could not Delete");
return;
}
DialogResult Result;
Result = MessageBox.Show("Do you Want to Delete?", "CRM", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (Result == DialogResult.Yes)
{
if (m_sBussinessType == "B")
{
ProgBillBL.DeletePBillMaster(iProgRegId);
grdPBRegView.DeleteRow(grdPBRegView.FocusedRowHandle);
grdPBTransView.DeleteRow(grdPBTransView.FocusedRowHandle);
BsfGlobal.InsertLog(DateTime.Now, "Progress Bill-Delete", "D", "Progress Bill", iProgRegId, iCCId, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId, 0, 0);
}
else
{
ProgBillBL.DeletePlotPBillMaster(iProgRegId);
grdPBRegView.DeleteRow(grdPBRegView.FocusedRowHandle);
grdPBTransView.DeleteRow(grdPBTransView.FocusedRowHandle);
BsfGlobal.InsertLog(DateTime.Now, "Plot-Progress-Bill-Delete", "D", "Plot Progress Bill", iProgRegId, iCCId, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId, 0, 0);
}
}
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public static bool InsertSerOrderDetails(DataTable dtComPList, DataTable argQTrans)
{
int iFRegId = 0;
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = String.Format("INSERT INTO ServiceQuoteReg(SDate,RefNo,CostcentreID,FlatID,GrossAmt,NetAmt,Remarks,LeadId,QualifierAmt) Values('{0}','{1}',{2},{3},'{4}','{5}','{6}',{7},'{8}') SELECT SCOPE_IDENTITY()", ServiceOrderBO.SDate, ServiceOrderBO.RefNo, ServiceOrderBO.CostcentreID, ServiceOrderBO.FlatID, ServiceOrderBO.GrossAmt, ServiceOrderBO.NetAmt, ServiceOrderBO.Remarks, ServiceOrderBO.BuyerId, ServiceOrderBO.QualifierAmt);
cmd = new SqlCommand(sSql, conn, tran);
iFRegId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
if (dtComPList.Rows.Count > 0)
{
for (int k = 0; k < dtComPList.Rows.Count; k++)
{
sSql = String.Format("INSERT INTO serQuoteTrans(RegisterID,ServiceID,Amount) values({0},{1},'{2}')", iFRegId, (dtComPList.Rows[k]["ServiceID"]), dtComPList.Rows[k]["Amount"]);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
//Bill Qualifier
for (int u = 0; u < argQTrans.Rows.Count; u++)
{
sSql = "Insert Into ServiceQuoteRateQ (BillRegId,QualifierId,Expression,ExpPer,Add_Less_Flag,SurCharge,EDCess,Amount,ExpValue,ExpPerValue,SurValue,EdValue) " +
"Values (" + iFRegId + "," + argQTrans.Rows[u]["QualifierId"].ToString() + ",'" + argQTrans.Rows[u]["Expression"].ToString() + "'," + argQTrans.Rows[u]["ExpPer"].ToString() + ",'" + argQTrans.Rows[u]["Add_Less_Flag"].ToString() + "'," + argQTrans.Rows[u]["SurCharge"].ToString() + "," + argQTrans.Rows[u]["EDCess"].ToString() + "," + argQTrans.Rows[u]["Amount"].ToString() + "," + argQTrans.Rows[u]["ExpValue"].ToString() + "," + argQTrans.Rows[u]["ExpPerValue"].ToString() + "," + argQTrans.Rows[u]["SurValue"].ToString() + "," + argQTrans.Rows[u]["EdValue"].ToString() + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
}
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Service-Quote-Add", "N", "ServiceQuote", iFRegId, ServiceOrderBO.CostcentreID, 0, BsfGlobal.g_sCRMDBName, ServiceOrderBO.RefNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
public static bool InsertRentDetails(DataTable dt)
{
int iFTypeId = 0;
int iTransId = 0;
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = String.Format("INSERT INTO RentDetail(RefNo,TenantId,CostCentreId,FlatId,RegDate,StartDate,EndDate,Rent,RentDuration,Advance,IntRate,IntDuration,Terms,RenewType,GracePriod,RentType,NetRent,AgreementNo) Values('{0}','{1}',{2},{3},'{4}','{5}','{6}', {7},'{8}',{9},{10},'{11}','{12}','{13}',{14},'{15}','{16}','{17}') SELECT SCOPE_IDENTITY()", RentDetBO.RefNo, RentDetBO.TenantId, RentDetBO.CostCentreId, RentDetBO.FlatId, RentDetBO.RegDate, RentDetBO.StartDate, RentDetBO.EndDate, RentDetBO.Rent, RentDetBO.RentDuration, RentDetBO.Advance, RentDetBO.IntRate, RentDetBO.IntDuration, RentDetBO.Terms, RentDetBO.RenewType, RentDetBO.GracePriod, RentDetBO.RentType, RentDetBO.NetRent, RentDetBO.AgreementNo);
cmd = new SqlCommand(sSql, conn, tran);
iFTypeId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
sSql = String.Format("INSERT INTO RentAgreementTrans(RentId,RefNo,RegDate,StartDate,EndDate,Rent,NetRent,RentDuration,Advance,IntRate,IntDuration,Terms,RenewType,GracePriod,RentType) Values ({0},'{1}','{2}','{3}','{4}','{5}','{6}', '{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}') SELECT SCOPE_IDENTITY()", iFTypeId, RentDetBO.RefNo, RentDetBO.RegDate, RentDetBO.StartDate, RentDetBO.EndDate, RentDetBO.Rent, RentDetBO.NetRent, RentDetBO.RentDuration, RentDetBO.Advance, RentDetBO.IntRate, RentDetBO.IntDuration, RentDetBO.Terms, RentDetBO.RenewType, RentDetBO.GracePriod, RentDetBO.RentType);
cmd = new SqlCommand(sSql, conn, tran);
iTransId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
if (dt.Rows.Count > 0)
{
for (int k = 0; k < dt.Rows.Count; k++)
{
sSql = String.Format("INSERT INTO Rentschtrans(RentTransId,Date,Rent) values({0},'{1:dd-MMM-yyyy}',{2})", iTransId, Convert.ToDateTime(dt.Rows[k]["Date"]), dt.Rows[k]["Amount"]);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Rent-Add", "N", "Rent", iFTypeId, RentDetBO.CostCentreId, 0, BsfGlobal.g_sCRMDBName, RentDetBO.RefNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
private void barButtonItem4_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (grdPBTransView.FocusedRowHandle >= 0)
{
if (BsfGlobal.FindPermission("Progress Bill-Delete") == false)
{
MessageBox.Show("You don't have Rights to Progress Bill-Delete");
return;
}
string sApprove = CommFun.IsNullCheck(grdPBTransView.GetFocusedRowCellValue("Approve"), CommFun.datatypes.vartypestring).ToString();
if (sApprove == "P" || sApprove == "Y")
{
MessageBox.Show("Bill Approved, Do not Delete");
return;
}
DialogResult Result;
Result = MessageBox.Show("Do you Want to Delete?", "CRM", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (Result == DialogResult.Yes)
{
int iPBillId = Convert.ToInt32(grdPBTransView.GetRowCellValue(grdPBTransView.FocusedRowHandle, "PBillId"));
int iCCId = Convert.ToInt32(grdPBTransView.GetRowCellValue(grdPBTransView.FocusedRowHandle, "CostCentreId"));
if (m_sBussinessType == "B")
{
ProgBillBL.DeletePBill(iPBillId);
grdPBTransView.DeleteRow(grdPBTransView.FocusedRowHandle);
//CommFun.InsertLog(DateTime.Now, "Progress Bill-Delete", "D", "Progress Bill", BsfGlobal.g_lUserId, Convert.ToInt32(gridView1.GetFocusedRowCellValue("RegisterId")), Convert.ToInt32(gridView1.GetFocusedRowCellValue("CostCentreId")), 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Progress Bill-Delete", "D", "Progress Bill", iProgRegId, iCCId, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId, 0, 0);
}
else
{
ProgBillBL.DeletePlotPBill(iPBillId);
grdPBTransView.DeleteRow(grdPBTransView.FocusedRowHandle);
//CommFun.InsertLog(DateTime.Now, "Plot-Progress-Bill-Delete", "D", "Plot Progress Bill ", BsfGlobal.g_lUserId, Convert.ToInt32(gridView1.GetFocusedRowCellValue("RegisterId")), Convert.ToInt32(gridView1.GetFocusedRowCellValue("CostCentreId")), 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Plot-Progress-Bill-Delete", "D", "Plot Progress Bill", iProgRegId, iCCId, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId, 0, 0);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Extra Bill-Delete") == false)
{
MessageBox.Show("You don't have Rights to Extra Bill-Delete");
return;
}
try
{
int iCCId = Convert.ToInt32(CommFun.IsNullCheck(grdBillView.GetFocusedRowCellValue("CostCentreId"), CommFun.datatypes.vartypenumeric));
int iBillRegId = Convert.ToInt32(CommFun.IsNullCheck(grdBillView.GetFocusedRowCellValue("BillRegId"), CommFun.datatypes.vartypenumeric));
BsfGlobal.OpenCRMDB();
string sSql = String.Format("Select COUNT(*) FROM dbo.ReceiptTrans WHERE BillRegId={0} AND CostCentreId={1}", iBillRegId, iCCId);
SqlCommand cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
int i_Count = Convert.ToInt32(CommFun.IsNullCheck(cmd.ExecuteScalar(), CommFun.datatypes.vartypenumeric));
cmd.Dispose();
BsfGlobal.g_CRMDB.Close();
if (i_Count > 0)
{
MessageBox.Show("Receipt Raised, Couldnot Delete", "CRM", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
sSql = String.Format("DELETE FROM ExtraBillRegister WHERE BillRegId={0}", iBillRegId);
CommFun.CRMExecute(sSql);
sSql = String.Format("DELETE FROM ExtraBillTrans WHERE BillRegId={0}", iBillRegId);
CommFun.CRMExecute(sSql);
sSql = String.Format("DELETE FROM ExtraBillRateQ WHERE BillRegId={0}", iBillRegId);
CommFun.CRMExecute(sSql);
sSql = String.Format("DELETE FROM ExtraBillRateQAbs WHERE BillRegId={0}", iBillRegId);
CommFun.CRMExecute(sSql);
grdBillView.DeleteRow(grdBillView.FocusedRowHandle);
BsfGlobal.InsertLog(DateTime.Now, "ExtraBill-Delete", "D", "Delete ExtraBill Register",
Convert.ToInt32(CommFun.IsNullCheck(grdBillView.GetFocusedRowCellValue("BillRegId"), CommFun.datatypes.vartypenumeric)),
iCCId, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
MessageBox.Show("Deleted", "CRM", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteRegister(int argRegId, int argCCId, string argVouNo)
{
string sSql = "";
bool bSuccess = false;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
sSql = String.Format("DELETE FROM dbo.MaintenanceDet WHERE MaintenanceId={0}", argRegId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "DELETE FROM dbo.MaintenanceQualifier WHERE MainTransId In(Select TransId From MaintenanceSchTrans Where MaintenanceId=" + argRegId + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = String.Format("DELETE FROM dbo.MaintenanceSchTrans WHERE MaintenanceId={0}", argRegId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
//BsfGlobal.InsertLog(DateTime.Now, "Rent-Delete", "D", "Rent", RegId, argCostId, 0, BsfGlobal.g_sCRMDBName, argVouNo, BsfGlobal.g_lUserId);
tran.Commit();
bSuccess = true;
BsfGlobal.InsertLog(DateTime.Now, "CRM-Maintenance-Bill-Delete", "D", "CRM-Maintenance-Bill", argRegId, MaintenanceBO.CostCentreId, 0,
BsfGlobal.g_sCRMDBName, MaintenanceBO.RefNo, BsfGlobal.g_lUserId);
tran.Dispose();
}
catch (Exception ce)
{
tran.Rollback();
System.Windows.Forms.MessageBox.Show(ce.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ce.Message, ce.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
return(bSuccess);
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdViewDoc.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Check List-Delete") == false)
{
MessageBox.Show("You don't have Rights to Check List-Delete");
return;
}
m_lGridId = Convert.ToInt32(grdViewDoc.GetRowCellValue(grdViewDoc.FocusedRowHandle, "CheckListId"));
if (m_lGridId != 0)
{
if (Convert.ToBoolean(grdViewDoc.GetFocusedRowCellValue("SysDefault")) == true)
{
MessageBox.Show("CheckList Used, Do not Delete"); return;
}
if (BankBL.DocuFound(m_lGridId) == false)
{
DialogResult reply = MessageBox.Show("Do you want Delete?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (reply == DialogResult.Yes)
{
BankBL.DeleteChekList(m_lGridId);
grdViewDoc.DeleteRow(grdViewDoc.FocusedRowHandle);
DataTable dt = new DataTable();
dt = grdDoc.DataSource as DataTable;
UpdateSortOrder(dt);
int iOrder = 0;
for (int i = 0; i < grdViewDoc.RowCount; i++)
{
iOrder = i + 1;
grdViewDoc.SetRowCellValue(i, "SortOrder", iOrder);
}
//CommFun.InsertLog(DateTime.Now, "Check List-Delete", "D", "Delete Check List", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Check List-Delete", "D", "Delete Check List", m_lGridId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
else
{
MessageBox.Show("CheckList Used, Do not Delete");
}
}
}
public static bool DeleteSerOrderBillRegister(int RegId, int argCostId, string argVouNo)
{
string sSql = "";
bool bSuccess = false;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
sSql = String.Format("DELETE FROM SerOrderBillReg WHERE RegBillId={0}", RegId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = String.Format("DELETE FROM SerOrderBillTrans WHERE BillRegId={0}", RegId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = String.Format("DELETE FROM ServiceOrderBillRateQ WHERE BillRegId={0}", RegId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
BsfGlobal.InsertLog(DateTime.Now, "CRM-ServiceBill-Delete", "D", "CRM-ServiceBill", RegId, argCostId, 0, BsfGlobal.g_sCRMDBName, argVouNo, BsfGlobal.g_lUserId);
tran.Commit();
bSuccess = true;
tran.Dispose();
}
catch (Exception ce)
{
tran.Rollback();
System.Windows.Forms.MessageBox.Show(ce.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ce.Message, ce.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
return(bSuccess);
}
private void cmdOK_Click(object sender, EventArgs e)
{
try
{
string check_userName = UserBL.GetColumn(String.Format("SELECT UserName FROM Users WHERE UserName='******'", txtUser.Text.Trim()));
string check_pwd = UserBL.GetColumn(String.Format("SELECT ISNULL(Password,'') FROM Users WHERE UserName='******'", txtUser.Text.Trim()));
if ((check_userName != ""))
{
//UidBool = check_userName.CompareTo(txtUser.Text.Trim());
if (check_pwd != "")
{
check_pwd = UserBL.Decrypt(check_pwd);
}
txtPassword.Text = check_pwd;
pwdBool = check_pwd.CompareTo(txtPassword.Text.Trim());
if ((UidBool == 0) && (pwdBool == 0))
{
Cursor.Current = Cursors.WaitCursor;
BsfGlobal.g_sUserName = txtUser.Text.Trim();
BsfGlobal.g_lUserId = Convert.ToInt32(UserBL.GetColumn(String.Format("SELECT UserId FROM Users WHERE UserName='******'", txtUser.Text.Trim())));
BsfGlobal.CheckPowerUser(BsfGlobal.g_lUserId);
BsfGlobal.GetPermission(BsfGlobal.g_lUserId);
CommFun.g_iCurrencyDigit = 2;
BsfGlobal.InsertLog(DateTime.Now, "Login", "S", "Login", 0, 0, 0, BsfGlobal.g_sWorkFlowDBName, "", BsfGlobal.g_lUserId);
//Application.Run(new frmNewMain());
frmHomeScreen HomePage = new frmHomeScreen();
Hide();
ShowInTaskbar = false;
HomePage.Show();
Cursor.Current = Cursors.Default;
}
else
{
MessageBox.Show("Incorrect Password");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool InsertTenantDetails()
{
int iFTypeId = 0;
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
string sSql = String.Format("INSERT INTO TenantRegister(TenantName,Address1,Address2,CityId,StateId,CountryId,Pincode,Mobile,PhoneRes,Email, EmpPlace,Designation,OffAddress,OffPhone,OffEmail,Commands,CostCentreId,BlockId,FlatId,TransDate,RefNo) VALUES('{0}', '{1}', '{2}','{3}','{4}', '{5}','{6}','{7}','{8}', '{9}','{10}','{11}', '{12}','{13}','{14}','{15}',{16},{17},{18},'{19}','{20}' ) SELECT SCOPE_IDENTITY()", TenantDetBO.TenantName, TenantDetBO.Address1, TenantDetBO.Address2, TenantDetBO.City, TenantDetBO.State, TenantDetBO.Country, TenantDetBO.Pincode, TenantDetBO.Mobile, TenantDetBO.PhoneRes, TenantDetBO.Email, TenantDetBO.EmpPlace, TenantDetBO.Designation, TenantDetBO.OffAddress, TenantDetBO.OffPhone, TenantDetBO.OffEmail, TenantDetBO.Commands, TenantDetBO.CostCentreId, TenantDetBO.BlockId, TenantDetBO.FlatId, TenantDetBO.TransDate, TenantDetBO.RefNo);
cmd = new SqlCommand(sSql, conn, tran);
iFTypeId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
//sSql1 = "INSERT INTO TenantTrans(CostCentreId,BlockId,UnitId,TenantId) values( " + TenantDetBO.CostCentreId + ", " + TenantDetBO.BlockId + ", " + TenantDetBO.UnitId + ", " + iFTypeId + ")";
// //CommFun.CRMExecute(sSql);
// cmd = new SqlCommand(sSql1, conn, tran);
// cmd.ExecuteNonQuery();
// cmd.Dispose();
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Tenant-Add", "N", "Tenant", iFTypeId, TenantDetBO.CostCentreId, 0, BsfGlobal.g_sCRMDBName, TenantDetBO.RefNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
public static bool UpdateTenantDetails()
{
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = String.Format("UPDATE TenantRegister SET TenantName='{0}', Address1='{1}',Address2='{2}',CityId='{3}', StateId='{4}',CountryId='{5}',Pincode='{6}',Mobile='{7}',PhoneRes='{8}', Email='{9}',EmpPlace='{10}',Designation='{11}', OffAddress='{12}',OffPhone='{13}',OffEmail='{14}',Commands='{15}',CostCentreId={16},BlockId={17},FlatId={18},TransDate='{19}',RefNo='{20}' WHERE TenantId={21}", TenantDetBO.TenantName, TenantDetBO.Address1, TenantDetBO.Address2, TenantDetBO.City, TenantDetBO.State, TenantDetBO.Country, TenantDetBO.Pincode, TenantDetBO.Mobile, TenantDetBO.PhoneRes, TenantDetBO.Email, TenantDetBO.EmpPlace, TenantDetBO.Designation, TenantDetBO.OffAddress, TenantDetBO.OffPhone, TenantDetBO.OffEmail, TenantDetBO.Commands, TenantDetBO.CostCentreId, TenantDetBO.BlockId, TenantDetBO.FlatId, TenantDetBO.TransDate, TenantDetBO.RefNo, TenantDetBO.TenantId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
//sSql = String.Format("UPDATE TenantTrans SET CostCentreId='{0}', BlockId='{1}',UnitId='{2}' WHERE TenantId={3}", TenantDetBO.CostCentreId, TenantDetBO.BlockId, TenantDetBO.UnitId, TenantDetBO.TenantId);
//cmd = new SqlCommand(sSql, conn, tran);
// cmd.ExecuteNonQuery();
// cmd.Dispose();
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Tenant-Edit", "E", "Tenant", TenantDetBO.TenantId, TenantDetBO.CostCentreId, 0, BsfGlobal.g_sCRMDBName, TenantDetBO.RefNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "Asset", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
public static bool InsertCompDetails(string argAlert)
{
int iIRegId = 0;
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = String.Format("INSERT INTO dbo.Complaint_Entry(CostCentreId,FlatId,LeadId,TenantId,TransDate,NatureId,ExecutiveId,AttDate,Remarks,complaintNo,ChargeType,ExeAttnId,AttnRemarks) Values({0},{1},{2},{3},'{4}', {5},{6},'{7}','{8}','{9}','{10}',{11},'{12}') SELECT SCOPE_IDENTITY()", ComplaintDetBO.CostCentreId, ComplaintDetBO.FlatId, ComplaintDetBO.BuyerId, ComplaintDetBO.TenantId, ComplaintDetBO.TransDate, ComplaintDetBO.NatureId, ComplaintDetBO.ExecutiveId, ComplaintDetBO.AttDate, ComplaintDetBO.Remarks, ComplaintDetBO.complaintNo, ComplaintDetBO.ChargeTYpe, ComplaintDetBO.ExeAttnId, ComplaintDetBO.AttnRemarks);
cmd = new SqlCommand(sSql, conn, tran);
iIRegId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Complaint-Entry-Add", "N", "ComplaintEntry", iIRegId, ComplaintDetBO.CostCentreId, 0, BsfGlobal.g_sCRMDBName, ComplaintDetBO.complaintNo, BsfGlobal.g_lUserId);
BsfGlobal.InsertAlert("CRM-Complaint-Alert", argAlert, ComplaintDetBO.CostCentreId, BsfGlobal.g_sCRMDBName);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdBrokerView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Broker Details-Delete") == false)
{
MessageBox.Show("You don't have Rights to Broker-Delete");
return;
}
try
{
int i_BrokerId = Convert.ToInt32(grdBrokerView.GetFocusedRowCellValue("BrokerId"));
if (UnitDirBL.BrokerFound(i_BrokerId) == false)
{
if (MessageBox.Show("Do You want to Delete Row?", "Information", MessageBoxButtons.OKCancel, MessageBoxIcon.Stop) == DialogResult.OK)
{
string sql;
sql = "DELETE FROM BrokerDet WHERE BrokerId=" + i_BrokerId + "";
CommFun.CRMExecute(sql);
grdBrokerView.DeleteRow(grdBrokerView.FocusedRowHandle);
BsfGlobal.InsertLog(DateTime.Now, "Broker Details-Delete", "D", "Delete Broker Details", i_BrokerId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
else
{
MessageBox.Show("Broker Details Used, Can't Delete Row", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateCompDetails()
{
//const int iFTypeId = 0;
bool bUpdate;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = String.Format("UPDATE dbo.Complaint_Entry SET CostCentreId={0},FlatId={1}, LeadId={2},TransDate='{3}', NatureId={4},ExecutiveId={5}, AttDate='{6}',Remarks='{7}',complaintNo='{8}', TenantId={9},ExeAttnId={10},AttnRemarks='{11}',ChargeTYpe='{12}' WHERE ComplaintId={13}", ComplaintDetBO.CostCentreId, ComplaintDetBO.FlatId, ComplaintDetBO.BuyerId, ComplaintDetBO.TransDate, ComplaintDetBO.NatureId, ComplaintDetBO.ExecutiveId, ComplaintDetBO.AttDate, ComplaintDetBO.Remarks, ComplaintDetBO.complaintNo, ComplaintDetBO.TenantId, ComplaintDetBO.ExeAttnId, ComplaintDetBO.AttnRemarks, ComplaintDetBO.ChargeTYpe, ComplaintDetBO.ComplaintId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
tran.Commit();
bUpdate = true;
BsfGlobal.InsertLog(DateTime.Now, "Complaint-Entry-Modify", "E", "ComplaintEntry", ComplaintDetBO.ComplaintId, ComplaintDetBO.CostCentreId, 0, BsfGlobal.g_sCRMDBName, ComplaintDetBO.complaintNo, BsfGlobal.g_lUserId);
}
catch (Exception ex)
{
tran.Rollback();
bUpdate = false;
System.Windows.Forms.MessageBox.Show(ex.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bUpdate);
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (grdCallSheetView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Pre-Followup-Delete") == false)
{
MessageBox.Show("You don't have Rights to Pre-Followup-Delete");
return;
}
try
{
bool bFinalised = CallSheetEntryBL.GetFinalisedFlat(Convert.ToInt32(grdCallSheetView.GetFocusedRowCellValue("EntryId")), Convert.ToInt32(grdCallSheetView.GetFocusedRowCellValue("LeadId")));
if (bFinalised == true)
{
MessageBox.Show("Cannot Delete Finalized Entry", "Followup", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Do You Want Delete?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
string sql = string.Empty;
sql = "DELETE FROM CallSheet WHERE EntryId=" + Convert.ToInt32(grdCallSheetView.GetFocusedRowCellValue("EntryId")) + " ";
CommFun.CRMExecute(sql);
grdCallSheetView.DeleteRow(grdCallSheetView.FocusedRowHandle);
BsfGlobal.InsertLog(DateTime.Now, "Pre-Followup-Delete", "D", "Pre-Followup", Convert.ToInt32(grdCallSheetView.GetFocusedRowCellValue("EntryId")), 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void UpdateData(string sType, string argDesc, int argId, int rowno)
{
string sSql = string.Empty;
SqlCommand cmd;
int identity;
if (sType == "C")
{
bool bAns = UnitDirBL.FoundCallType(argId, argDesc, sType);
if (bAns == true)
{
MessageBox.Show("Already Exists"); DGvTransView.CancelUpdateCurrentRow(); return;
}
if (argId == 0)
{
sSql = String.Format("INSERT INTO CallType(Description) Values('{0}') SELECT SCOPE_IDENTITY();", argDesc);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
identity = Convert.ToInt16(cmd.ExecuteScalar().ToString());
cmd.Dispose();
//DGvTransView.SetRowCellValue(DGvTransView.FocusedRowHandle, "CallTypeId", identity);
//DGvTransView.SetRowCellValue(DGvTransView.FocusedRowHandle, "SysDefault", false);
sSql = String.Format("Update CallType Set SortID={0} Where CallTypeId= {0}", identity);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Add", "N", "Add Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Add", "N", "Add Followup Setup", identity, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
getData("CallType");
}
else
{
if (argId <= 4)
{
MessageBox.Show("Cant Changes"); return;
}
else
{
sSql = String.Format("Update CallType SET Description='{0}',SortId={1} WHERE CallTypeId={2}", argDesc, rowno, argId);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Edit", "E", "Edit Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Edit", "E", "Edit Followup Setup", argId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
}
else if (sType == "N")
{
bool bAns = UnitDirBL.FoundCallType(argId, argDesc, sType);
if (bAns == true)
{
MessageBox.Show("Already Exists"); DGvTransView.CancelUpdateCurrentRow(); return;
}
if (argId == 0)
{
sSql = String.Format("INSERT INTO NatureMaster(Description) Values('{0}') SELECT SCOPE_IDENTITY(); ", argDesc);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
identity = Convert.ToInt16(cmd.ExecuteScalar().ToString());
cmd.Dispose();
//DGvTransView.SetRowCellValue(DGvTransView.FocusedRowHandle, "NatureId", identity);
//DGvTransView.SetRowCellValue(DGvTransView.FocusedRowHandle, "SysDefault", false);
sSql = String.Format("Update NatureMaster Set SortId={0} Where NatureId= {0}", identity);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Add", "N", "Add Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Add", "N", "Add Followup Setup", identity, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
getData("Nature");
}
else
{
sSql = String.Format("Update NatureMaster SET Description='{0}',SortId={1} WHERE NatureId={2}", argDesc, rowno, argId);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Edit", "E", "Edit Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Edit", "E", "Edit Followup Setup", argId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
else if (sType == "S")
{
bool bAns = UnitDirBL.FoundCallType(argId, argDesc, sType);
if (bAns == true)
{
MessageBox.Show("Already Exists"); DGvTransView.CancelUpdateCurrentRow(); return;
}
if (argId == 0)
{
sSql = String.Format("INSERT INTO StatusMaster(Description) Values('{0}') SELECT SCOPE_IDENTITY();", argDesc);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
identity = Convert.ToInt16(cmd.ExecuteScalar().ToString());
cmd.Dispose();
//DGvTransView.SetRowCellValue(DGvTransView.FocusedRowHandle, "StatusId", identity);
//DGvTransView.SetRowCellValue(DGvTransView.FocusedRowHandle, "SysDefault", false);
sSql = String.Format("Update StatusMaster Set SortId={0} Where StatusId= {0}", identity);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Add", "N", "Add Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Add", "N", "Add Followup Setup", identity, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
getData("Status");
}
else
{
sSql = String.Format("Update StatusMaster SET Description='{0}',SortId={1} WHERE StatusId={2}", argDesc, rowno, argId);
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Edit", "E", "Edit Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Edit", "E", "Edit Followup Setup", argId, 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (DGvTransView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Followup Setup-Delete") == false)
{
MessageBox.Show("You don't have Rights to Followup Setup-Delete");
return;
}
else
{
string sSql = ""; SqlCommand cmd;
RepositoryItemLookUpEdit cboCallType = barEditItem1.Edit as RepositoryItemLookUpEdit;
string sType = Convert.ToString(barEditItem1.EditValue);
if (m_sType == "C")
{
if (Convert.ToBoolean(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("SysDefault"), CommFun.datatypes.varTypeBoolean)) == true)
{
MessageBox.Show("Do not Delete, This is Default Value"); return;
}
else
{
int iTypeId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("CallTypeId"), CommFun.datatypes.vartypenumeric));
bool bAns = false;
sSql = "Select CallTypeID From CallSheet Where CallTypeID= " + iTypeId + " " +
"Union All " +
"Select CallTypeID From LeadRegister Where CallTypeID = " + iTypeId;
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sSql, BsfGlobal.OpenCRMDB());
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
bAns = true;
}
dt.Dispose();
sda.Dispose();
BsfGlobal.g_CRMDB.Close();
if (bAns == true)
{
MessageBox.Show("Do not Delete, Call Type Already Used"); return;
}
DialogResult result1 = MessageBox.Show("Do you want to Delete", "CallType Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
sSql = String.Format("DELETE FROM CallType WHERE CallTypeId={0}", Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("CallTypeId"), CommFun.datatypes.vartypenumeric)));
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
BsfGlobal.g_CRMDB.Close();
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
}
}
}
else if (m_sType == "N")
{
if (Convert.ToBoolean(DGvTransView.GetFocusedRowCellValue("SysDefault")) == true)
{
MessageBox.Show("Do not Delete, This is Default Value"); return;
}
int iTypeId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("NatureId"), CommFun.datatypes.vartypenumeric));
bool bAns = false;
sSql = "Select NatureID From CallSheet Where NatureID= " + iTypeId;
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sSql, BsfGlobal.OpenCRMDB());
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
bAns = true;
}
dt.Dispose();
sda.Dispose();
BsfGlobal.g_CRMDB.Close();
if (bAns == true)
{
MessageBox.Show("Do not Delete, Nature Already Used"); return;
}
DialogResult result1 = MessageBox.Show("Do you want to Delete", "Nature Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
sSql = String.Format("DELETE FROM NatureMaster WHERE NatureId={0}", CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("NatureId"), CommFun.datatypes.vartypenumeric));
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
BsfGlobal.g_CRMDB.Close();
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
}
}
else if (m_sType == "S")
{
if (Convert.ToBoolean(DGvTransView.GetFocusedRowCellValue("SysDefault")) == true)
{
MessageBox.Show("Do not Delete, This is Default Value"); return;
}
int iTypeId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("StatusId"), CommFun.datatypes.vartypenumeric));
bool bAns = false;
sSql = "Select StatusId From CallSheet Where StatusId= " + iTypeId;
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sSql, BsfGlobal.OpenCRMDB());
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
bAns = true;
}
dt.Dispose();
sda.Dispose();
BsfGlobal.g_CRMDB.Close();
if (bAns == true)
{
MessageBox.Show("Do not Delete, Status Already Used"); return;
}
DialogResult result1 = MessageBox.Show("Do you want to Delete", "Status Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
sSql = String.Format("DELETE FROM StatusMaster WHERE StatusId={0}", CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("StatusId"), CommFun.datatypes.vartypenumeric));
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
BsfGlobal.g_CRMDB.Close();
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
}
}
//CommFun.InsertLog(DateTime.Now, "Followup Setup-Delete", "D", "Delete Followup Setup", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Followup Setup-Delete", "D", "Delete Followup Setup", Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("StatusId"), CommFun.datatypes.vartypenumeric)), 0, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
}
}
public void Update(EnquiryBL oEnqBL)
{
SqlCommand cmd;
try
{
cmd = new SqlCommand("UpdateEnquiry", BsfGlobal.OpenCRMDB());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
if (oEnqBL.Enquiryid == 0)
{
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Enquiryid", oEnqBL.Enquiryid);
cmd.Parameters["@Enquiryid"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Buyer", oEnqBL.Buyer);
cmd.Parameters.AddWithValue("@AccountId", oEnqBL.Accountid);
cmd.Parameters.AddWithValue("@BuyerId", oEnqBL.Buyerid);
cmd.Parameters.AddWithValue("@CallTypeID", oEnqBL.CallTypeID);
cmd.Parameters.AddWithValue("@Projectid", oEnqBL.Projectid);
}
else
{
cmd.Parameters.AddWithValue("@Flag", 2);
cmd.Parameters.AddWithValue("@Enquiryid", oEnqBL.Enquiryid);
cmd.Parameters.AddWithValue("@AccountId", oEnqBL.Accountid);
cmd.Parameters.AddWithValue("@Buyer", oEnqBL.Buyer);
cmd.Parameters.AddWithValue("@BuyerId", oEnqBL.Buyerid);
cmd.Parameters.AddWithValue("@CallTypeID", oEnqBL.CallTypeID);
cmd.Parameters.AddWithValue("@Projectid", oEnqBL.Projectid);
}
cmd.Parameters.AddWithValue("@ProjTypeID", oEnqBL.Projtypeid);
cmd.Parameters.AddWithValue("@FlatID", oEnqBL.Flatid);
cmd.Parameters.AddWithValue("@EnqDate", oEnqBL.Enquirydate);
cmd.Parameters.AddWithValue("@Enquiryname", oEnqBL.Enquiryname);
cmd.Parameters.AddWithValue("@Profession", oEnqBL.Profession);
cmd.Parameters.AddWithValue("@Organization", oEnqBL.Organization);
cmd.Parameters.AddWithValue("@Nationality", oEnqBL.Nationality);
cmd.Parameters.AddWithValue("@Address1 ", oEnqBL.Address1);
cmd.Parameters.AddWithValue("@Address2", oEnqBL.Address2);
cmd.Parameters.AddWithValue("@City", oEnqBL.City);
cmd.Parameters.AddWithValue("@State", oEnqBL.State);
cmd.Parameters.AddWithValue("@Pincode", oEnqBL.Pincode);
cmd.Parameters.AddWithValue("@Phoneoff", oEnqBL.Phoneoff);
cmd.Parameters.AddWithValue("@Phoneres", oEnqBL.Phoneres);
cmd.Parameters.AddWithValue("@Mobile", oEnqBL.Mobile);
cmd.Parameters.AddWithValue("@Fax", oEnqBL.Fax);
cmd.Parameters.AddWithValue("@Email", oEnqBL.Email);
cmd.Parameters.AddWithValue("@Web", oEnqBL.Website);
cmd.Parameters.AddWithValue("@MaritalStatus", oEnqBL.Maritalstatus);
cmd.Parameters.AddWithValue("@EnquiryModeId", oEnqBL.Enquirymodeid);
cmd.Parameters.AddWithValue("@EnquirySubModeId", oEnqBL.Enquirysubmodeid);
cmd.Parameters.AddWithValue("@Executiveid", oEnqBL.Executiveid);
cmd.Parameters.AddWithValue("@Nextfollowupdate", oEnqBL.Nextfollowupdate);
cmd.Parameters.AddWithValue("@Remarks", oEnqBL.Remarks);
cmd.Parameters.AddWithValue("@Active", 1);
cmd.Parameters.AddWithValue("@Additionalinfo", oEnqBL.Additionalinfo);
cmd.Parameters.AddWithValue("@Employmentid ", oEnqBL.Employmentid);
cmd.Parameters.AddWithValue("@Apartmentid", oEnqBL.Apartmentid);
cmd.Parameters.AddWithValue("@Apartmentsizeid", oEnqBL.Apartmentsizeid);
cmd.Parameters.AddWithValue("@Apartmenttypeid", oEnqBL.Apartmenttypeid);
cmd.Parameters.AddWithValue("@Costpreferenceid", oEnqBL.Costpreferenceid);
cmd.Parameters.AddWithValue("@Guesthouseid", oEnqBL.Guesthouseid);
cmd.Parameters.AddWithValue("@Incomeid", oEnqBL.Incomeid);
cmd.Parameters.AddWithValue("@Religionid", oEnqBL.Religionid);
cmd.Parameters.AddWithValue("@StayId", oEnqBL.Stayid);
cmd.Parameters.AddWithValue("@Reasonid", oEnqBL.Reasonid);
cmd.Parameters.AddWithValue("@Freasonid", oEnqBL.Freasonid);
cmd.Parameters.AddWithValue("@Brokerage", Convert.ToBoolean(oEnqBL.Brokerage));
cmd.Parameters.AddWithValue("@BrokerId", oEnqBL.BrokerId);
cmd.Parameters.AddWithValue("@Commissionper", oEnqBL.Commissionper);
cmd.Parameters.AddWithValue("@Amount", oEnqBL.Amount);
cmd.Parameters.AddWithValue("@Birthdate", oEnqBL.Birthdate);
cmd.Parameters.AddWithValue("@Weddingdate", oEnqBL.Weddingdate);
cmd.Parameters.AddWithValue("@Country", oEnqBL.Country);
cmd.Parameters.AddWithValue("@Citizenship", oEnqBL.Nationality);
cmd.Parameters.AddWithValue("@NoofChild", oEnqBL.Noofchild);
cmd.Parameters.AddWithValue("@AchievementId", oEnqBL.Achievementid);
cmd.Parameters.AddWithValue("@Coappname", oEnqBL.Coappname);
cmd.Parameters.AddWithValue("@Coaddress1", oEnqBL.Coaddress1);
cmd.Parameters.AddWithValue("@Coaddress2", oEnqBL.Coaddress2);
cmd.Parameters.AddWithValue("@Coappcity", oEnqBL.Coappcity);
cmd.Parameters.AddWithValue("@CoFatHusname", oEnqBL.Coappfathusname);
cmd.Parameters.AddWithValue("@Age", oEnqBL.Age);
cmd.Parameters.AddWithValue("@Coappage", oEnqBL.Coappage);
cmd.Parameters.AddWithValue("@FatHusName", oEnqBL.Fathusname);
cmd.Parameters.AddWithValue("@Panno", oEnqBL.Panno);
cmd.Parameters.AddWithValue("@PAdd1", oEnqBL.Padrs1);
cmd.Parameters.AddWithValue("@PAdd2", oEnqBL.Padrs2);
cmd.Parameters.AddWithValue("@Pcity", oEnqBL.Pcity);
cmd.Parameters.AddWithValue("@PState", oEnqBL.Pstate);
cmd.Parameters.AddWithValue("@PCountry", oEnqBL.Pcountry);
cmd.Parameters.AddWithValue("@PpinCode", oEnqBL.Ppincode);
cmd.Parameters.AddWithValue("@BankName", oEnqBL.Bankname);
cmd.Parameters.AddWithValue("@LoanDetails", oEnqBL.Loandetails);
cmd.Parameters.AddWithValue("@Disqual", oEnqBL.Disqual);
cmd.Parameters.AddWithValue("@No_of_emp", oEnqBL.No_of_emp);
cmd.Parameters.AddWithValue("@AnnualIncome", oEnqBL.Annual_revenue);
cmd.Parameters.AddWithValue("@Industry", oEnqBL.Industry);
cmd.Parameters.AddWithValue("@Description", oEnqBL.Description);
cmd.Parameters.AddWithValue("@Created_UserId", oEnqBL.Created_UserId);
cmd.Parameters.AddWithValue("@Modified_UserId", oEnqBL.Modified_UserId);
cmd.Parameters.AddWithValue("@Modified_Date", DBNull.Value);
cmd.Parameters.AddWithValue("@EnqType", oEnqBL.LeadType);
cmd.Parameters.AddWithValue("@Prev", oEnqBL.PrevCust);
cmd.ExecuteNonQuery();
//CommFun.InsertLog(DateTime.Now, "Enquiry Details-Edit", "E", "Edit ENQUIRY Details", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.InsertLog(DateTime.Now, "Enquiry Details-Edit", "E", "Edit ENQUIRY Details", oEnqBL.Enquiryid, oEnqBL.Projectid, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId);
oEnqBL.Enquiryid = (int)cmd.Parameters["@Enquiryid"].Value;
if (oEnqBL.ChkPos.Items.Count > 0)
{
string sSql;
sSql = "DELETE FROM dbo.PossessDetail WHERE EnquiryId='" + oEnqBL.Enquiryid + "'";
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
cmd = new SqlCommand("UpdatePos", BsfGlobal.OpenCRMDB());
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < oEnqBL.ChkPos.CheckedItems.Count; i++)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@PossessId", Convert.ToInt32(((System.Data.DataRowView)(oEnqBL.ChkPos.Items[i])).Row.ItemArray[0]));
cmd.Parameters.AddWithValue("@EnqId", oEnqBL.Enquiryid);
cmd.Parameters.AddWithValue("@SortOrder", i + 1);
cmd.ExecuteNonQuery();
}
}
if (oEnqBL.ChkArea.Items.Count > 0)
{
string sSql;
sSql = "DELETE FROM dbo.AreaDetail WHERE EnquiryId='" + oEnqBL.Enquiryid + "'";
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
cmd = new SqlCommand("UpdateArea", BsfGlobal.OpenCRMDB());
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < oEnqBL.ChkArea.CheckedItems.Count; i++)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@AreaId", Convert.ToInt32(((System.Data.DataRowView)(oEnqBL.ChkArea.Items[i])).Row.ItemArray[0]));
cmd.Parameters.AddWithValue("@EnqId", oEnqBL.Enquiryid);
cmd.Parameters.AddWithValue("@SortOrder", i + 1);
cmd.ExecuteNonQuery();
}
}
if (oEnqBL.ChkFacility.Items.Count > 0)
{
string sSql;
sSql = "DELETE FROM dbo.FacilityDetail WHERE EnquiryId='" + oEnqBL.Enquiryid + "'";
cmd = new SqlCommand(sSql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
cmd = new SqlCommand("UpdateFacility", BsfGlobal.OpenCRMDB());
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < oEnqBL.ChkFacility.CheckedItems.Count; i++)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@FacilityId", Convert.ToInt32(((System.Data.DataRowView)(oEnqBL.ChkFacility.Items[i])).Row.ItemArray[0]));
cmd.Parameters.AddWithValue("@EnqId", oEnqBL.Enquiryid);
cmd.Parameters.AddWithValue("@SortOrder", i + 1);
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public static void UpdateCashDetails(int argCashRepId, DataTable dtPay, int argCCId, int argBuyerId, decimal argAmt, DateTime argDate, string argType)
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
string sSql = ""; int iPaySchId = 0; int iFlatId = 0;
decimal dNetAmt = 0, dArea = 0, dRate = 0, dBaseAmt = 0, dQualAmt = 0;
int iEntryId = 0; bool bAns = false;
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
if (dtPay != null)
{
sSql = "Delete From dbo.CashReceiptRegister Where CashReceiptId=" + argCashRepId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Delete From dbo.CashReceiptTrans Where CashReceiptId=" + argCashRepId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Select FlatId From dbo.FlatDetails Where CostCentreId=" + argCCId + " And LeadId=" + argBuyerId + "";
cmd = new SqlCommand(sSql, conn, tran);
SqlDataReader sdr = cmd.ExecuteReader();
DataTable dtFlat = new DataTable();
dtFlat.Load(sdr);
cmd.Dispose();
for (int n = 0; n < dtFlat.Rows.Count; n++)
{
DataTable dt = new DataTable();
dt = dtPay;
DataView dv = new DataView(dt);
dv.RowFilter = "FlatId=" + dtFlat.Rows[n]["FlatId"] + "";
dt = dv.ToTable();
sSql = "Insert Into dbo.CashReceiptRegister(CashDate,LeadId,CostCentreId,Amount)Values(" +
"'" + argDate.ToString("dd/MMM/yyyy") + "'," + argBuyerId + "," + argCCId + "," + argAmt + ")SELECT SCOPE_IDENTITY()";
cmd = new SqlCommand(sSql, conn, tran);
iEntryId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
for (int i = 0; i < dt.Rows.Count; i++)
{
//if (Convert.ToDecimal(dt.Rows[i]["CurrentAmount"]) > 0)
//{
iPaySchId = Convert.ToInt32(dt.Rows[i]["PaySchId"]);
iFlatId = Convert.ToInt32(dt.Rows[i]["FlatId"]);
dArea = Convert.ToDecimal(dt.Rows[i]["Area"]);
dRate = Convert.ToDecimal(dt.Rows[0]["Rate"]);
dBaseAmt = dArea * dRate;
dNetAmt = Convert.ToDecimal(dt.Rows[0]["NetAmt"]);
dQualAmt = Convert.ToDecimal(dt.Rows[i]["QualifierAmt"]);
sSql = "Insert Into dbo.CashReceiptTrans(CashReceiptId,FlatId,PaySchId,PBillId,PaySchAmount,PaySchNetAmount,CashAmount,FlatRate,FlatAmount)Values(" + iEntryId + ", " +
" " + iFlatId + "," + dt.Rows[i]["PaySchId"] + "," + dt.Rows[i]["PBillId"] + "," + dt.Rows[i]["Amount"] + "," + dt.Rows[i]["NetAmount"] + "," + dt.Rows[i]["CurrentAmount"] + "," + dRate + "," +
" " + dNetAmt + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Update PaymentScheduleFlat Set Amount=" + dt.Rows[i]["Amount"] + "-" + dt.Rows[i]["CurrentAmount"] + ",NetAmount=" + dt.Rows[i]["NetAmount"] + "-" + dt.Rows[i]["CurrentAmount"] + " Where PaymentSchId=" + iPaySchId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (argType == "PB")
{
sSql = "Update dbo.ProgressBillRegister Set BillAmount=" + dt.Rows[i]["Amount"] + "-" + dt.Rows[i]["CurrentAmount"] + ",NetAmount=" + dt.Rows[i]["NetAmount"] + "-" + dt.Rows[i]["CurrentAmount"] + " Where PaySchId=" + iPaySchId + " And PBillId=" + dt.Rows[i]["PBillId"] + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Update dbo.ProgressBillMaster Set NetAmount=NetAmount-" + dt.Rows[i]["CurrentAmount"] + " Where ProgRegId=" + dt.Rows[i]["ProgRegId"] + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
//}
}
decimal NetAmount = dNetAmt - argAmt;
decimal BaseAmount = dBaseAmt - argAmt;
decimal Rate = BaseAmount / dArea;
sSql = "Update dbo.FlatDetails Set Rate=" + Rate + ",BaseAmt=" + BaseAmount + ",NetAmt=" + NetAmount + " Where FlatId=" + iFlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Select * From dbo.PaymentScheduleFlat Where FlatId=" + iFlatId + " And TemplateId<>0";
cmd = new SqlCommand(sSql, conn, tran);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dtPS = new DataTable();
dtPS.Load(dr);
cmd.Dispose();
if (dtPS.Rows.Count > 0)
{
for (int x = 0; x < dtPS.Rows.Count; x++)
{
decimal dSchPer = decimal.Round(Convert.ToDecimal(dtPS.Rows[x]["Amount"]) / (NetAmount + dQualAmt) * 100, 6);
sSql = "Update dbo.PaymentScheduleFlat Set SchPercent=" + dSchPer + " Where PaymentSchId=" + dtPS.Rows[x]["PaymentSchId"] + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
sSql = "Select PaymentSchId,FlatId,TemplateId,CostCentreId,SchType,Description,SchDescId,StageId,OtherCostId,SchDate," +
" DateAfter, Duration,DurationType,SchPercent,Amount,PreStageTypeId,SortOrder,BillPassed,PaidAmount From dbo.PaymentScheduleFlat " +
" Where FlatId=" + iFlatId + " And TemplateId<>0 Order By SortOrder";
cmd = new SqlCommand(sSql, conn, tran);
SqlDataReader dr1 = cmd.ExecuteReader();
DataTable dtF = new DataTable();
dtF.Load(dr1);
cmd.Dispose();
if (dtF.Rows.Count > 0)
{
PaymentScheduleDL.UpdateCashBuyerScheduleQual(iFlatId, dtF, conn, tran);
}
}
// }
//}
tran.Commit();
bAns = true;
if (bAns == true)
{
BsfGlobal.InsertLog(DateTime.Now, "Buyer-Receipt-Cash-Edit", "E", "", iEntryId, argCCId, 0, BsfGlobal.g_sCRMDBName, "", BsfGlobal.g_lUserId, argAmt, 0);
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
internal static void UpdateBuyerDet(string argMode, FinalizationBO BOFIN, DataTable dtFinal, string argFlatNo, bool argChkSend)
{
SqlConnection conn = new SqlConnection();
String sSql = "";
SqlCommand cmd = null;
string ValidUpto = "", FinalDate = "";
conn = BsfGlobal.OpenCRMDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (argMode == "E")
{
ValidUpto = string.Format("{0:dd/MMM/yyyy}", BOFIN.DE_ValidUpto);
FinalDate = string.Format("{0:dd/MMM/yyyy}", BOFIN.DE_Final);
if (ValidUpto != "01/Jan/0001")
{
sSql = "Update dbo.BuyerDetail Set Status='" + BOFIN.s_Status + "'," +
" CustomerType='" + BOFIN.s_CustomerType + "', PaymentOption='" + BOFIN.s_PaymentOption + "'," +
" BrokerId=" + BOFIN.i_BrokerId + ",BrokerComm=" + BOFIN.d_BrokerComm + ",BrokerAmount=" + BOFIN.d_BrokerAmt + "," +
" ValidUpto='" + ValidUpto + "',FinaliseDate='" + FinalDate + "',PostSaleExecId=" + BOFIN.i_PostExecId + ", " +
" Advance=" + BOFIN.d_AdvAmt + " Where FlatId=" + BOFIN.i_FlatId + " AND CostCentreId=" + BOFIN.i_CostCentreId + "";
}
else
{
ValidUpto = null;
sSql = "Update dbo.BuyerDetail Set Status='" + BOFIN.s_Status + "'," +
" CustomerType='" + BOFIN.s_CustomerType + "', PaymentOption='" + BOFIN.s_PaymentOption + "'," +
" BrokerId=" + BOFIN.i_BrokerId + ",BrokerComm=" + BOFIN.d_BrokerComm + ",BrokerAmount=" + BOFIN.d_BrokerAmt + "," +
" ValidUpto='" + ValidUpto + "',FinaliseDate='" + FinalDate + "',PostSaleExecId=" + BOFIN.i_PostExecId + ", " +
" Advance=" + BOFIN.d_AdvAmt + " Where FlatId=" + BOFIN.i_FlatId + " AND CostCentreId=" + BOFIN.i_CostCentreId + "";
}
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Update dbo.FollowUp Set ExecutiveId=" + BOFIN.i_PostExecId + "" +
" Where FlatId=" + BOFIN.i_FlatId + " AND CostCentreId=" + BOFIN.i_CostCentreId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Update dbo.PaymentScheduleFlat Set SchDate='" + FinalDate + "'" +
" Where TemplateId=0 And FlatId=" + BOFIN.i_FlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Update dbo.PaymentScheduleFlat Set SchDate='" + FinalDate + "'" +
" Where TemplateId=-1 And FlatId=" + BOFIN.i_FlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
SqlDataReader sdr, sdr1, sdr2; DataTable dt, dt1; int iStgId = 0, iTemplateId = 0;
int iDateAfter = 0, iDuration = 0; string sDurType = ""; DateTime SchDate; int iSortOrder = 0;
DateTime StartDate = DateTime.Now; DateTime EndDate = DateTime.Now; int ipre = 0;
sSql = "Select TemplateId,PreStageTypeId from dbo.PaymentScheduleFlat Where FlatId=" + BOFIN.i_FlatId + " And PreStageTypeId=-1";
cmd = new SqlCommand(sSql, conn, tran);
sdr = cmd.ExecuteReader();
dt = new DataTable();
dt.Load(sdr); cmd.Dispose();
if (dt.Rows.Count > 0)
{
iStgId = Convert.ToInt32(dt.Rows[0]["PreStageTypeId"]);
iTemplateId = Convert.ToInt32(dt.Rows[0]["TemplateId"]);
}
dt.Dispose();
sSql = "Select SortOrder From dbo.PaymentScheduleFlat Where FlatId=" + BOFIN.i_FlatId + " And TemplateId=" + iTemplateId + "";
cmd = new SqlCommand(sSql, conn, tran);
sdr2 = cmd.ExecuteReader();
dt1 = new DataTable();
dt1.Load(sdr2); cmd.Dispose();
dt1.Dispose();
if (dt1.Rows.Count > 0)
{
iSortOrder = Convert.ToInt32(dt1.Rows[0]["SortOrder"]);
}
sSql = "select StartDate,EndDate From ProjectInfo Where CostCentreId= " + BOFIN.i_CostCentreId;
cmd = new SqlCommand(sSql, conn, tran);
dt = new DataTable();
sdr = cmd.ExecuteReader();
dt.Load(sdr);
dt.Dispose();
if (dt.Rows.Count > 0)
{
StartDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["StartDate"], CommFun.datatypes.VarTypeDate));
EndDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["EndDate"], CommFun.datatypes.VarTypeDate));
}
sSql = "Update dbo.PaymentScheduleFlat Set SchDate='" + FinalDate + "'" +
" Where TemplateId=" + iTemplateId + " And FlatId=" + BOFIN.i_FlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Update dbo.PaymentScheduleFlat Set SchDate='" + FinalDate + "'" +
" Where TemplateId=0 And FlatId=" + BOFIN.i_FlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (iStgId == -1)
{
if (iStgId == -1)
{
sSql = "Select A.PreStageTypeId,A.CostCentreId,A.TemplateId,A.DateAfter,A.Duration,A.Durationtype from dbo.PaymentScheduleFlat A" +
" Left Join dbo.ProgressBillRegister B On A.FlatId=B.FlatId " +
" Where A.FlatId=" + BOFIN.i_FlatId + " And A.SortOrder>=" + iSortOrder + "" +
" And A.PaymentSchId Not In " +
" (Select PaySchId From dbo.ProgressBillRegister Where FlatId=" + BOFIN.i_FlatId + ") Order By A.SortOrder";
}
cmd = new SqlCommand(sSql, conn, tran);
sdr1 = cmd.ExecuteReader();
dt = new DataTable();
dt.Load(sdr1);
cmd.Dispose();
for (int i = 0; i < dt.Rows.Count; i++)
{
iTemplateId = Convert.ToInt32(dt.Rows[i]["TemplateId"]);
ipre = Convert.ToInt32(dt.Rows[i]["PreStageTypeId"]);
iDateAfter = Convert.ToInt32(dt.Rows[i]["DateAfter"]);
iDuration = Convert.ToInt32(dt.Rows[i]["Duration"]);
sDurType = dt.Rows[i]["DurationType"].ToString();
if (ipre == -1)
{
}
else if (ipre == -2)
{
}
else if (ipre == -3)
{
}
else if (ipre == 0)
{
}
else
{
iTemplateId = ipre;
}
sSql = "Select SchDate From dbo.PaymentScheduleFlat Where CostCentreId=" + dt.Rows[i]["CostCentreId"] + " And FlatId=" + BOFIN.i_FlatId + "" +
" And TemplateId=" + iTemplateId + "";
cmd = new SqlCommand(sSql, conn, tran);
DataTable dtDate = new DataTable();
sdr = cmd.ExecuteReader();
dtDate.Load(sdr);
dtDate.Dispose();
if (ipre == -1)
{
SchDate = Convert.ToDateTime(CommFun.IsNullCheck(FinalDate, CommFun.datatypes.VarTypeDate));
}
else if (ipre == -2)
{
SchDate = StartDate;
}
else if (ipre == -3)
{
SchDate = EndDate;
}
else
{
SchDate = Convert.ToDateTime(CommFun.IsNullCheck(dtDate.Rows[0]["SchDate"], CommFun.datatypes.VarTypeDate));
}
if (sDurType == "D")
{
if (iDateAfter == 0)
{
SchDate = SchDate.AddDays(iDuration);
}
else
{
SchDate = SchDate.AddDays(-iDuration);
}
}
else if (sDurType == "M")
{
if (iDateAfter == 0)
{
SchDate = SchDate.AddMonths(iDuration);
}
else
{
SchDate = SchDate.AddDays(-iDuration);
}
}
sSql = "Update dbo.PaymentScheduleFlat Set SchDate='" + string.Format(Convert.ToDateTime(SchDate).ToString("dd-MMM-yyyy")) + "'" +
" Where TemplateId=" + dt.Rows[i]["TemplateId"] + " And FlatId=" + BOFIN.i_FlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
UnitDirDL.InsertFlatChk(dtFinal, BOFIN.i_FlatId, "F", argChkSend, argFlatNo, BOFIN.i_CostCentreId, conn, tran);
sSql = "Select AdvAmount From dbo.FlatDetails Where FlatId=" + BOFIN.i_FlatId + "";
cmd = new SqlCommand(sSql, conn, tran);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dtA = new DataTable();
dtA.Load(dr);
cmd.Dispose();
if (dtA.Rows.Count > 0)
{
decimal dAdvAmt = Convert.ToDecimal(dtA.Rows[0]["AdvAmount"]);
if (dAdvAmt != Convert.ToDecimal(BOFIN.d_AdvAmt))
{
sSql = "Update FlatDetails Set AdvAmount=" + BOFIN.d_AdvAmt + " WHERE FlatId=" + BOFIN.i_FlatId + " ";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
PaymentScheduleDL.InsertFlatScheduleI(BOFIN.i_FlatId, conn, tran);
dtA.Dispose();
cmd.Dispose();
}
}
}
//PaymentScheduleDL.InsertFlatScheduleI(BOFIN.i_FlatId, conn, tran);
//FlatDetailsDL.UpdateFlatQualAmt(BOFIN.i_, BOFIN.i_FlatId, conn, tran);
tran.Commit();
if (argMode == "E")
{
BsfGlobal.InsertLog(DateTime.Now, "Flat-Finalisation-Modify", "N", "Flat Finalisation", BOFIN.i_FlatId, BOFIN.i_CostCentreId, 0, BsfGlobal.g_sCRMDBName, argFlatNo, BsfGlobal.g_lUserId, BOFIN.d_AdvAmt, 0);
}
else
{
BsfGlobal.InsertLog(DateTime.Now, "Flat-Finalisation-Create", "C", "Flat Finalisation", BOFIN.i_FlatId, BOFIN.i_CostCentreId, 0, BsfGlobal.g_sCRMDBName, argFlatNo, BsfGlobal.g_lUserId, BOFIN.d_AdvAmt, 0);
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
public static bool DeleteRentAgreementRegister(int RegId, int argCostId, string argVouNo, int RegTransId, string argType)
{
int iRegTransId = 0;
string sRefNo = "";
string sRegDate, sStDate, sEndDate;
string sRentDuration = "";
string sIntDuration = "";
string sTerms = "";
string sRenewType = "";
decimal dGPriod = 0;
string sRentType = "";
// DateTime RegDate,StDate, EndDate;
decimal dRent = 0;
decimal dNetRent = 0;
decimal dAdvance = 0;
decimal dIntRate = 0;
string sSql = "";
bool bSuccess = false;
DataTable dtTran, dtUpTran;
SqlDataReader sdr, sdrT;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
sSql = String.Format("DELETE FROM RentAgreementTrans WHERE RentTransId={0}", RegTransId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (argType == "Renewal" || argType == "Cancel")
{
dtTran = new DataTable();
sSql = "SELECT Max(RentTransId) MaxNo FROM RentAgreementTrans WHERE RentId=" + RegId + "";
cmd = new SqlCommand(sSql, conn, tran);
sdr = cmd.ExecuteReader();
dtTran.Load(sdr);
cmd.Dispose();
if (dtTran.Rows.Count > 0)
{
for (int a = 0; a < dtTran.Rows.Count; a++)
{
iRegTransId = Convert.ToInt32(CommFun.IsNullCheck(dtTran.Rows[a]["MaxNo"], CommFun.datatypes.vartypenumeric));
}
}
dtTran.Dispose();
dtUpTran = new DataTable();
sSql = "SELECT * FROM RentAgreementTrans WHERE RentTransId=" + iRegTransId + "";
cmd = new SqlCommand(sSql, conn, tran);
sdrT = cmd.ExecuteReader();
dtUpTran.Load(sdrT);
cmd.Dispose();
if (dtUpTran.Rows.Count > 0)
{
for (int b = 0; b < dtUpTran.Rows.Count; b++)
{
sRefNo = dtUpTran.Rows[b]["RefNo"].ToString();
sRegDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtUpTran.Rows[b]["RegDate"].ToString(), CommFun.datatypes.VarTypeDate));
sStDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtUpTran.Rows[b]["StartDate"].ToString(), CommFun.datatypes.VarTypeDate));
sEndDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtUpTran.Rows[b]["EndDate"].ToString(), CommFun.datatypes.VarTypeDate));
//RegDate = Convert.ToDateTime(dtUpTran.Rows[b]["RegDate"].ToString());
//StDate = Convert.ToDateTime(dtUpTran.Rows[b]["StartDate"].ToString());
//EndDate = Convert.ToDateTime(dtUpTran.Rows[b]["EndDate"].ToString());
dRent = Convert.ToDecimal(dtUpTran.Rows[b]["Rent"].ToString());
dNetRent = Convert.ToDecimal(dtUpTran.Rows[b]["NetRent"].ToString());
sRentDuration = dtUpTran.Rows[b]["RentDuration"].ToString();
dAdvance = Convert.ToDecimal(dtUpTran.Rows[b]["Advance"].ToString());
dIntRate = Convert.ToDecimal(dtUpTran.Rows[b]["IntRate"].ToString());
sIntDuration = dtUpTran.Rows[b]["IntDuration"].ToString();
sTerms = dtUpTran.Rows[b]["Terms"].ToString();
sRenewType = dtUpTran.Rows[b]["RenewType"].ToString();
dGPriod = Convert.ToDecimal(dtUpTran.Rows[b]["GracePriod"].ToString());
sRentType = dtUpTran.Rows[b]["RentType"].ToString();
sSql = "UPDATE RentDetail SET RefNo='" + sRefNo + "',RegDate='" + sRegDate + "',StartDate='" + sStDate + "',EndDate='" + sEndDate + "'," +
" Rent='" + dRent + "',NetRent='" + dNetRent + "',RentDuration='" + sRentDuration + "',Advance='" + dAdvance + "',IntRate='" + dIntRate + "',IntDuration='" + sIntDuration + "'," +
" Terms='" + sTerms + "',RenewType='" + sRenewType + "',GracePriod='" + dGPriod + "',RentType='" + sRentType + "' WHERE RentId=" + RegId + " ";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
dtUpTran.Dispose();
}
else
{
sSql = String.Format("DELETE FROM RentDetail WHERE RentId={0}", RegId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
sSql = String.Format("DELETE FROM RentSchTrans WHERE RentTransId={0}", RegTransId);
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
BsfGlobal.InsertLog(DateTime.Now, "Rent-Delete", "D", "Rent", RegId, argCostId, 0, BsfGlobal.g_sCRMDBName, argVouNo, BsfGlobal.g_lUserId);
tran.Commit();
bSuccess = true;
tran.Dispose();
}
catch (Exception ce)
{
tran.Rollback();
System.Windows.Forms.MessageBox.Show(ce.Message, "PMS", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BsfGlobal.CustomException(ce.Message, ce.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
return(bSuccess);
}
