private void frmExecTargetReg_Load(object sender, EventArgs e) { CommFun.SetMyGraphics(); if (BsfGlobal.g_sUnPermissionMode == "H" || BsfGlobal.g_sUnPermissionMode == "D") { CheckPermission(); } deFrom.EditValue = Convert.ToDateTime(DateTime.Now.AddMonths(-1)); deTo.EditValue = Convert.ToDateTime(DateTime.Now); PopulateTargetReg(); }
private void frmRentReceivable_Load(object sender, EventArgs e) { CommFun.m_sFuncName = BsfGlobal.GetFunctionalName("Flat"); //if (BsfGlobal.FindPermission("Rent Receivable-View") == false) //{ // MessageBox.Show("You don't have Rights to Rent Receivable-View"); // return; //} CommFun.SetMyGraphics(); FillGrid(); }
public void GetComplaint() { string sql = string.Empty; sql = "Select ExtraItemTypeId,ExtraItemTypeName from ExtraItemTypeMaster"; cboItemType.Properties.DataSource = CommFun.AddSelectToDataTable(CommFun.FillRecord(sql)); cboItemType.Properties.PopulateColumns(); cboItemType.Properties.DisplayMember = "ExtraItemTypeName"; cboItemType.Properties.ValueMember = "ExtraItemTypeId"; cboItemType.Properties.Columns["ExtraItemTypeId"].Visible = false; cboItemType.ItemIndex = 0; }
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 btnStatus_ItemClick(object sender, ItemClickEventArgs e) { if (grdViewReceipt.GetFocusedRow() == null) { return; } int iRegId = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "ReceiptId"), CommFun.datatypes.vartypenumeric)); string sRefNo = CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "ReceiptNo"), CommFun.datatypes.vartypestring).ToString(); BsfForm.frmLogHistory frm = new BsfForm.frmLogHistory(); frm.Execute(iRegId, "Buyer Receipt", "Buyer-Receipt-Approve", sRefNo, BsfGlobal.g_sCRMDBName); }
private void frmExtraBillReg_Load(object sender, EventArgs e) { CommFun.SetMyGraphics(); if (BsfGlobal.g_sUnPermissionMode == "H" || BsfGlobal.g_sUnPermissionMode == "D") { CheckPermission(); } t_panel = panelControl1; dtpFrmDate.EditValue = Convert.ToDateTime(DateTime.Now.AddMonths(-1)); dtpToDate.EditValue = Convert.ToDateTime(DateTime.Now); PopulateData(); }
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e) { if (DGvTransView.FocusedRowHandle < 0) { return; } if (BsfGlobal.FindPermission("Tenant-Delete") == false) { MessageBox.Show("You don't have Rights to TenantRegister-Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } try { if (DGvTransView.FocusedRowHandle >= 0) { DataTable dtTen = new DataTable(); int i_RegId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "TenantId"), CommFun.datatypes.vartypenumeric)); int m_iCCId1 = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "CostCentreId"), CommFun.datatypes.vartypenumeric)); string Apv = ""; string m_sIssNo = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "RefNo"), 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; } dtTen = TenantDetBL.CheckTenant(i_RegId); if (dtTen.Rows.Count > 0) { MessageBox.Show("Do Not Delete. Tenant Already Used.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } else { if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (TenantDetBL.DeleteTenantRegister(i_RegId, m_iCCId1, m_sIssNo) == true) { DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle); } //CommFun.InsertLog(DateTime.Now, "TenantRegister-Delete", "D", "Delete TenantRegister", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName); } } } } catch (Exception ex) { BsfGlobal.CustomException(ex.Message, ex.StackTrace); } }
private void PopulateProsAndBuyer() { if (b_FormLoad == true) { return; } int iLCCId = Convert.ToInt32(CommFun.IsNullCheck(cboPCostCentre.EditValue, CommFun.datatypes.vartypenumeric)); int iBCCId = Convert.ToInt32(CommFun.IsNullCheck(cboBCostCentre.EditValue, CommFun.datatypes.vartypenumeric)); DataSet ds = ClientBL.GetProsAndBuyer(iLCCId, iBCCId, m_sCCTransId); if (ds == null) { return; } grdPros.DataSource = ds.Tables[0]; ProsView.PopulateColumns(); ProsView.Columns["LeadId"].Visible = false; ProsView.Columns["LeadType"].Visible = false; ProsView.Columns["LeadId"].OptionsColumn.ShowInCustomizationForm = false; ProsView.Columns["LeadType"].OptionsColumn.ShowInCustomizationForm = false; ProsView.Appearance.HeaderPanel.Font = new Font(ProsView.Appearance.HeaderPanel.Font, FontStyle.Bold); ProsView.OptionsSelection.InvertSelection = true; ProsView.OptionsSelection.EnableAppearanceHideSelection = false; ProsView.Appearance.FocusedRow.ForeColor = Color.White; ProsView.Appearance.FocusedRow.BackColor = Color.Teal; ProsView.FocusedRowHandle = 0; ProsView.Focus(); grdBuyer.DataSource = ds.Tables[1]; BuyerView.PopulateColumns(); BuyerView.Columns["LeadId"].Visible = false; BuyerView.Columns["FlatId"].Visible = false; BuyerView.Columns["LeadType"].Visible = false; BuyerView.Columns["CostCentreId"].Visible = false; BuyerView.Columns["LeadId"].OptionsColumn.ShowInCustomizationForm = false; BuyerView.Columns["FlatId"].OptionsColumn.ShowInCustomizationForm = false; BuyerView.Columns["LeadType"].OptionsColumn.ShowInCustomizationForm = false; BuyerView.Columns["Name"].Group(); BuyerView.ExpandAllGroups(); BuyerView.Appearance.HeaderPanel.Font = new Font(BuyerView.Appearance.HeaderPanel.Font, FontStyle.Bold); BuyerView.OptionsSelection.InvertSelection = true; BuyerView.OptionsSelection.EnableAppearanceHideSelection = false; BuyerView.Appearance.FocusedRow.BackColor = Color.Teal; BuyerView.Appearance.FocusedRow.ForeColor = Color.White; BuyerView.FocusedRowHandle = 0; }
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; } }
private void gridView1_ShowingEditor(object sender, CancelEventArgs e) { int iFieldId = Convert.ToInt32(CommFun.IsNullCheck(gridView1.GetFocusedRowCellValue("FieldId"), CommFun.datatypes.vartypenumeric)); if (iFieldId == 1 || iFieldId == 2 || iFieldId == 3) { e.Cancel = true; } else { e.Cancel = false; } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (grdCancelView.GetFocusedRow() == null) { return; } int iRegId = Convert.ToInt32(CommFun.IsNullCheck(grdCancelView.GetRowCellValue(grdCancelView.FocusedRowHandle, "CancelId"), CommFun.datatypes.vartypenumeric)); string sRefNo = CommFun.IsNullCheck(grdCancelView.GetRowCellValue(grdCancelView.FocusedRowHandle, "FlatNo"), CommFun.datatypes.vartypestring).ToString(); BsfForm.frmLogHistory frm = new BsfForm.frmLogHistory(); frm.Execute(iRegId, "Flat-Cancellation", "Flat-Cancellation-Create", sRefNo, BsfGlobal.g_sCRMDBName); }
private void grdCarView_CustomDrawCardFieldValue(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e) { if (Convert.ToInt32(CommFun.IsNullCheck(grdChartView.GetRowCellValue(e.RowHandle, "FlatId"), CommFun.datatypes.vartypenumeric)) > 0) { e.Appearance.BackColor = System.Drawing.Color.ForestGreen; e.Appearance.ForeColor = System.Drawing.Color.White; } else { e.Appearance.BackColor = System.Drawing.Color.PaleGoldenrod; e.Appearance.ForeColor = System.Drawing.Color.Maroon; } }
private void frmProjReceivable_Load(object sender, EventArgs e) { //if (BsfGlobal.FindPermission("ProjwiseReceivable-View") == false) //{ // MessageBox.Show("You don't have Rights to ProjwiseReceivable-View"); // return; //} CommFun.SetMyGraphics(); //SetMyGraphics(); dxDate.EditValue = Convert.ToDateTime(DateTime.Today); dtAson = Convert.ToDateTime(dxDate.EditValue.ToString()); Fill_Project_Receivable(); }
private void grdCarView_DoubleClick(object sender, EventArgs e) { iBlockId = Convert.ToInt32(CommFun.IsNullCheck(cboBlock.EditValue, CommFun.datatypes.vartypenumeric)); iTypeId = Convert.ToInt32(CommFun.IsNullCheck(cboType.EditValue, CommFun.datatypes.vartypenumeric)); int iSlotNo = Convert.ToInt32(CommFun.IsNullCheck(grdChartView.GetFocusedRowCellValue("SlotNo"), CommFun.datatypes.vartypenumeric)); int iFlatId = Convert.ToInt32(CommFun.IsNullCheck(grdChartView.GetFocusedRowCellValue("FlatId"), CommFun.datatypes.vartypenumeric)); frmFlatSelection frm = new frmFlatSelection(); if (frm.Execute(m_iCCId, iBlockId, iTypeId, iSlotNo, iFlatId) == true) { PopulateGrid(); } }
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(); }
private void btnAddStageLevel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { using (frmStagePickList frm = new frmStagePickList() { StartPosition = FormStartPosition.CenterScreen }) { i_LevelId = Convert.ToInt32(CommFun.IsNullCheck(grdLevelView.GetRowCellValue(grdLevelView.FocusedRowHandle, "LevelId"), CommFun.datatypes.vartypenumeric)); frm.Exe(0, i_LevelId, m_icostCentreId); frm.ShowDialog(); FillStageLevel(); } }
void txtAmtEdit_DoubleClick(object sender, EventArgs e) { int iTempId = Convert.ToInt32(grdViewPayFlat.GetRowCellValue(grdViewPayFlat.FocusedRowHandle, "PaymentSchId").ToString()); int iPayTypeId = m_iPayTypeId; string sType = grdViewPayFlat.GetRowCellValue(grdViewPayFlat.FocusedRowHandle, "SchType").ToString(); DateTime dSchDate = Convert.ToDateTime(CommFun.IsNullCheck(grdViewPayFlat.GetRowCellValue(grdViewPayFlat.FocusedRowHandle, "SchDate"), CommFun.datatypes.VarTypeDate)); decimal dAmt = Convert.ToDecimal(grdViewPayFlat.GetRowCellValue(grdViewPayFlat.FocusedRowHandle, "Amount").ToString()); decimal dNetAmt = Convert.ToDecimal(grdViewPayFlat.GetRowCellValue(grdViewPayFlat.FocusedRowHandle, "NetAmount").ToString()); frmRecType frm = new frmRecType(); dNetAmt = frm.Execute(iTempId, "F", iPayTypeId, m_iCCId, sType, dSchDate, dAmt, dNetAmt, m_iFlatId, 0, "", false, 0); grdViewPayFlat.SetRowCellValue(grdViewPayFlat.FocusedRowHandle, "NetAmount", dNetAmt); }
void txtDEdit_DoubleClick(object sender, EventArgs e) { int iPaySchId = Convert.ToInt32(CommFun.IsNullCheck(grdViewPayFlat.GetFocusedRowCellValue("PaymentSchId"), CommFun.datatypes.vartypenumeric)); int iTempId = Convert.ToInt32(CommFun.IsNullCheck(grdViewPayFlat.GetFocusedRowCellValue("TemplateId"), CommFun.datatypes.vartypenumeric)); int i = grdViewPayFlat.FocusedRowHandle; frmDatePList frm = new frmDatePList(); if (frm.Execute(iTempId, iPaySchId, m_iCCId, m_iFlatId, "PayFlat") == true) { PopulatePaySchFlat(); grdViewPayFlat.FocusedRowHandle = i; } }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (BsfGlobal.FindPermission("Project UOM-Add") == false) { MessageBox.Show("You don't have Rights to Project UOM-Add"); return; } if (Convert.ToInt32(CommFun.IsNullCheck(cboUOM.EditValue, CommFun.datatypes.vartypenumeric)) > 0) { UnitDirBL.UpdateUOM(m_iCCId, Convert.ToInt32(cboUOM.EditValue)); } Close(); }
void btnView_Click(object sender, EventArgs e) { try { string sFileName = ""; sFileName = CommFun.IsNullCheck(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "DocPath"), CommFun.datatypes.vartypestring).ToString(); System.Diagnostics.Process.Start(sFileName); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void PopulateFlat() { DataTable dtF = new DataTable(); dtF = PMSReceiptBL.GetFlat(Convert.ToInt32(cboCostCentre.EditValue)); cboFlatNo.Properties.DataSource = CommFun.AddSelectToDataTable(dtF); cboFlatNo.Properties.DisplayMember = "FlatNo"; cboFlatNo.Properties.ValueMember = "FlatId"; cboFlatNo.Properties.PopulateColumns(); cboFlatNo.Properties.Columns["FlatId"].Visible = false; cboFlatNo.Properties.ShowHeader = false; cboFlatNo.Properties.ShowFooter = false; }
void txtAmtEdit_DoubleClick(object sender, EventArgs e) { bool b_Ans = false; frmCarParkDescription frm = new frmCarParkDescription(); frm.iSlots = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetFocusedRowCellValue("NoOfSlots"), CommFun.datatypes.vartypenumeric)); frm.Execute(m_iCCId, Convert.ToInt32(grdViewCar.GetFocusedRowCellValue("BlockId")), m_iTypeId); if (b_Ans = frm.b_OK == true) { int iNoOfSlots = frm.iSlots; grdViewCar.SetRowCellValue(grdViewCar.FocusedRowHandle, "NoOfSlots", iNoOfSlots); } }
private void frmTargetRegister_Load(object sender, EventArgs e) { CommFun.SetMyGraphics(); if (BsfGlobal.g_sUnPermissionMode == "H" || BsfGlobal.g_sUnPermissionMode == "D") { CheckPermission(); } t_panel = panelTargetReg; deTo.EditValue = Convert.ToDateTime(DateTime.Now.ToShortDateString()); barTargetReg.Visible = true; PopulateTargetReg(); FormClosed += new FormClosedEventHandler(frmTargetRegister_FormClosed); }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //string sMsg = PaymentScheduleBL.GetPaySchFlatValidate(m_iCCId, m_iFlatId); //if (sMsg == "Land") { MessageBox.Show("Mismatch Land Value"); return; } //if (sMsg == "Base") { MessageBox.Show("Mismatch Construction Value"); return; } //if (sMsg == "OtherCost") { MessageBox.Show("Mismatch OtherCost Value"); return; } //for (int x = 0; x < dtPaySchFlat.Rows.Count; x++) //{ // for (int i = 0; i < dtFlat.Rows.Count; i++) // { // if (Convert.ToInt32(dtFlat.Rows[i]["TemplateId"]) == Convert.ToInt32(dtPaySchFlat.Rows[x]["TemplateId"])) // { // dtFlat.Rows[i]["FlatId"] = m_iFlatId; // dtFlat.Rows[i]["SchDate"] = dtPaySchFlat.Rows[x]["SchDate"]; // dtFlat.Rows[i]["SchPercent"] = dtPaySchFlat.Rows[x]["SchPercent"]; // dTotal = dTotal + Convert.ToDecimal(dtFlat.Rows[i]["SchPercent"]); // } // } //} Cursor.Current = Cursors.WaitCursor; grdViewPayFlat.FocusedRowHandle = grdViewPayFlat.FocusedRowHandle + 1; decimal dTotal = Convert.ToDecimal(CommFun.IsNullCheck(grdViewPayFlat.Columns["SchPercent"].SummaryText, CommFun.datatypes.vartypenumeric)); if (dTotal != 100) { MessageBox.Show("Percentage should be 100"); return; } dtFlat = new DataTable(); dtFlat = PaymentScheduleBL.GetCommPaySchFlat(m_iCCId, m_iFlatId, m_iPayTypeId); if (bCheckBill == false) { if (m_bPayTypewise == true) { PaymentScheduleBL.UpdateFlatSchedule(m_iFlatId, dtFlat); } else { PaymentScheduleBL.UpdateFlatScheduleQual(m_iFlatId, dtFlat); } } //PaymentScheduleBL.UpdateFlatSchedule(m_iFlatId, dtFlat); PopulatePaySchFlat(); Close(); Cursor.Current = Cursors.Default; }
private void DGvTransView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { bool m_bAns = false; if (m_bAns == true) { DGvTransView.CancelUpdateCurrentRow(); return; } if (BsfGlobal.FindPermission("Followup Setup-Modify") == false) { MessageBox.Show("You don't have Rights to Followup Setup-Modify"); return; } if (CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue(DGvTransView.Columns[1].FieldName).ToString(), CommFun.datatypes.vartypestring).ToString().Trim() == "") { DGvTransView.CancelUpdateCurrentRow(); return; } m_bAns = true; if (DGvTransView.FocusedRowHandle >= 0) { int i = Convert.ToInt32(e.RowHandle.ToString()) + 1; if (Convert.ToBoolean(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("SysDefault"), CommFun.datatypes.varTypeBoolean)) == true) { DGvTransView.CancelUpdateCurrentRow(); return; } string s = CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue(DGvTransView.Columns[1].FieldName).ToString(), CommFun.datatypes.vartypestring).ToString(); int id = Convert.ToInt16(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue(DGvTransView.Columns[0].FieldName).ToString(), CommFun.datatypes.vartypenumeric)); //UpdateData(m_sType, CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue(DGvTransView.Columns[1].FieldName).ToString(), CommFun.datatypes.vartypestring).ToString(), Convert.ToInt16(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue(DGvTransView.Columns[0].FieldName).ToString(), CommFun.datatypes.vartypenumeric)), i); UpdateData(m_sType, s, id, i); } else { int i = 0;// Convert.ToInt16(GetPrevVisibleRow) + 1; if (Convert.ToBoolean(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("SysDefault"), CommFun.datatypes.varTypeBoolean)) == true) { DGvTransView.CancelUpdateCurrentRow(); return; } UpdateData(m_sType, DGvTransView.GetFocusedRowCellValue(DGvTransView.Columns[1].FieldName).ToString(), 0, i); } m_bAns = false; }
private void FillExec() { DataTable dt = new DataTable(); dt = CommFun.LoadExecutive(); cboExec.Properties.DataSource = dt; cboExec.Properties.PopulateColumns(); cboExec.Properties.DisplayMember = "ExecName"; cboExec.Properties.ValueMember = "ExecId"; cboExec.Properties.ShowHeader = false; cboExec.Properties.ShowFooter = false; cboExec.Properties.Columns["ExecId"].Visible = false; }
private void FillBranch() { DataTable dt = new DataTable(); dt = BankBL.getBranchName(); cboBranch.Properties.DataSource = CommFun.AddAllToDataTable(dt); cboBranch.Properties.PopulateColumns(); cboBranch.Properties.DisplayMember = "BranchName"; cboBranch.Properties.ValueMember = "BranchId"; cboBranch.Properties.Columns["BranchId"].Visible = false; cboBranch.Properties.ShowFooter = false; cboBranch.Properties.ShowHeader = false; }
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); } }
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e) { if (BsfGlobal.FindPermission("Buyer-Receipt-Delete") == false) { MessageBox.Show("You don't have Rights to Buyer-Receipt-Delete"); return; } if (Convert.ToInt32(grdViewReceipt.FocusedRowHandle) < 0) { return; } int iRepceiptId = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("ReceiptId"), CommFun.datatypes.vartypenumeric)); string sAppr = ReceiptDetailBL.GetApprove(iRepceiptId); if (sAppr == "P" || sAppr == "Y") { MessageBox.Show("Approved Receipt should not be Deleted"); return; } bool bCheckValidate = ReceiptDetailBL.Check_ReceiptDet(iRepceiptId); if (bCheckValidate == true) { MessageBox.Show("Cannot Delete, Schedule raised to Bill"); return; } try { if (grdViewReceipt.FocusedRowHandle >= 0) { if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { ReceiptDetailBL.DeleteReceiptDetails(Convert.ToInt32(grdViewReceipt.GetFocusedRowCellValue("ReceiptId")), grdViewReceipt.GetFocusedRowCellValue("PaymentAgainst").ToString()); grdViewReceipt.DeleteRow(grdViewReceipt.FocusedRowHandle); int iCCId = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("CostCentreId"), CommFun.datatypes.vartypenumeric)); string sRecNo = CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("ReceiptNo"), CommFun.datatypes.vartypestring).ToString(); decimal dAmt = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("Amount"), CommFun.datatypes.vartypenumeric)); //CommFun.InsertLog(DateTime.Now, "Receipt Register-Delete", "D", "Delete Receipt Register", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName); //BsfGlobal.InsertLog(DateTime.Now, "Buyer-Receipt-Delete", "D", "Delete Receipt Register", Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("ReceiptId")), iCCId, 0, BsfGlobal.g_sCRMDBName, sRecNo, BsfGlobal.g_lUserId, dAmt, 0); } } } catch (Exception ex) { throw ex; } }
public static void SendBulkMail(List <M.EmailAddress> argToAddress, string argSubject, string argContent, List <M.attachment> argAttachment) { try { //string activationLink = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority) + "/Register/Activation.aspx?id=" + argFromAddress; Cursor.Current = Cursors.WaitCursor; DataTable dt = new DataTable(); dt = CommFun.GetMandrillSetting(3); if (dt == null) { return; } if (dt.Rows.Count == 0) { return; } string sFromName = CommFun.IsNullCheck(dt.Rows[0]["FromName"], CommFun.datatypes.vartypestring).ToString(); string sUserId = CommFun.IsNullCheck(dt.Rows[0]["UserId"], CommFun.datatypes.vartypestring).ToString(); string sKeyId = CommFun.IsNullCheck(dt.Rows[0]["KeyId"], CommFun.datatypes.vartypestring).ToString(); string sTemplateName = CommFun.IsNullCheck(dt.Rows[0]["TemplateId"], CommFun.datatypes.vartypestring).ToString(); M.MandrillApi api = new M.MandrillApi(sKeyId, true); M.EmailMessage emailmsg = new M.EmailMessage(); emailmsg.from_name = sFromName; emailmsg.from_email = sUserId; emailmsg.to = argToAddress; emailmsg.attachments = argAttachment; emailmsg.merge = true; emailmsg.AddGlobalVariable("SUBJECT", argSubject); emailmsg.AddGlobalVariable("BODY", argContent); List <M.TemplateContent> tempContent = new List <M.TemplateContent>(); tempContent.Add(new M.TemplateContent() { name = sTemplateName }); List <M.EmailResult> errorMsg = api.SendMessage(emailmsg, sTemplateName, tempContent); Cursor.Current = Cursors.Default; } catch (Exception ex) { MessageBox.Show(ex.Message); } }