private void SaveExpenses() { try { if (ValidateControls()) { model = new ExpensesModel(); model.AutoExpensesID = string.IsNullOrEmpty(hdnExpensesID.Text) ? null : (long?)Convert.ToInt64(hdnExpensesID.Text); model.ExpensesBillNo = string.IsNullOrEmpty(txtBillNo.Text) ? null : txtBillNo.Text; model.Particulars = txtParticulars.Text; model.PaymentMode = Convert.ToString(ddlPaymentMode.Text); model.ShopName = txtShopName.Text; model.Quantity = Convert.ToInt32(txtQuantity.Text); model.Amount = Convert.ToInt32(txtAmount.Text); model.PurchasesDate = Common.Convert_String_To_Date(txtMaskedDate.Text); //DateTime.ParseExact(dtpDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); _schoolExpenses = new SchoolExpenses(); int result = _schoolExpenses.SaveExpenses(model); switch (result) { case 1: MessageBox.Show("Record Successfully Saved.", "Expenses", MessageBoxButtons.OK, MessageBoxIcon.Information); break; //case -1: // MessageBox.Show("Error in saving records.", "Expenses", MessageBoxButtons.OK, MessageBoxIcon.Information); // break; } BindExpensesGrid(); ClearControls(); /*=================================================================*/ //Show Hide Delete Control, Based on Date. if (gridExpenses.Rows.Count == 0) { gridExpenses.Columns["ColDelete"].Visible = true; } else { Grid_ShowDeleteContol(); } /*=================================================================*/ } } catch { MessageBox.Show("Error in saving records.", "Expenses", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void BindExpensesGrid() { _schoolExpenses = new SchoolExpenses(); List <ExpensesModel> expenseslist = new List <ExpensesModel>(); expenseslist = _schoolExpenses.GetExpensesList(Common.Convert_String_To_Date(txtMaskedDate.Text)); gridExpenses.DataSource = expenseslist; if (expenseslist != null) { int index = 0; foreach (ExpensesModel model in expenseslist) { DataGridViewTextBoxCell colSLNo = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColSLNo"]); DataGridViewTextBoxCell colBillNo = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColBillNo"]); DataGridViewTextBoxCell colShopName = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColShopName"]); DataGridViewTextBoxCell colParticulars = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColParticulars"]); DataGridViewTextBoxCell colPaymentMode = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColPaymentMode"]); DataGridViewTextBoxCell colAmount = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColAmount"]); DataGridViewTextBoxCell colExpensesID = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColExpensesID"]); DataGridViewTextBoxCell colQuantity = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColQuantity"]); DataGridViewTextBoxCell colDate = (DataGridViewTextBoxCell)(gridExpenses.Rows[index].Cells["ColDate"]); DataGridViewLinkCell colEdit = (DataGridViewLinkCell)(gridExpenses.Rows[index].Cells["ColEdit"]); DataGridViewLinkCell colDelete = (DataGridViewLinkCell)(gridExpenses.Rows[index].Cells["ColDelete"]); colSLNo.Value = index + 1; colBillNo.Value = model.ExpensesBillNo; colShopName.Value = model.ShopName; colParticulars.Value = model.Particulars; colPaymentMode.Value = model.PaymentMode; colAmount.Value = model.Amount; colExpensesID.Value = model.AutoExpensesID; colQuantity.Value = model.Quantity; colDate.Value = model.PurchasesDate; colEdit.Value = "Edit"; colDelete.Value = "Delete"; index++; } gridExpenses.Refresh(); gridExpenses.ClearSelection(); } }
private void gridExpenses_CellContentClick(object sender, DataGridViewCellEventArgs e) { int rowIndex = e.RowIndex; try { if (e.ColumnIndex == 8) { DialogResult result = MessageBox.Show("Are you sure to delete record?", "Expenses", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { long ExpensesID = Convert.ToInt64(gridExpenses.Rows[rowIndex].Cells["ColExpensesID"].Value); _schoolExpenses = new SchoolExpenses(); DeleteRecord(ExpensesID); } } if (e.ColumnIndex == 7) { hdnExpensesID.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["ColExpensesID"].Value); txtBillNo.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["ColBillNo"].Value); txtShopName.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["ColShopName"].Value); txtParticulars.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["ColParticulars"].Value); ddlPaymentMode.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["ColPaymentMode"].Value); txtQuantity.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["colQuantity"].Value); txtAmount.Text = Convert.ToString(gridExpenses.Rows[rowIndex].Cells["ColAmount"].Value); txtMaskedDate.Text = String.Format("{0:dd.MM.yyyy}", Convert.ToDateTime(gridExpenses.Rows[rowIndex].Cells["ColDate"].Value)); // Convert.ToDateTime(gridExpenses.Rows[rowIndex].Cells["ColDate"].Value); // string dateAndTime =Convert.ToDateTime(gridExpenses.Rows[rowIndex].Cells["ColDate"].Value).ToString("dd/MM/yyyy"); //DateTime.ParseExact("", "dd/MM/yyyy", CultureInfo.InvariantCulture); // dtpDate.CustomFormat = "dd/MM/yyyy"; } gridExpenses.ClearSelection(); } catch { } }
private void GetExpenseReport(DateTime expenseDate) { btnViewReport.Enabled = false; lblPleaseWait.Visible = true; try { _schoolExpenses = new SchoolExpenses(); DataSet dsExpenseReport = _schoolExpenses.ExpensesReport(expenseDate); if (dsExpenseReport != null && dsExpenseReport.Tables[0].Rows.Count > 0) { dsExpenseReport.Tables[0].TableName = "Expenses"; dsExpenseReport.Tables[1].TableName = "ActualExpenses"; dsExpenseReport.Tables[2].TableName = "School"; ReportDocument rdoc = new ReportDocument(); rdoc.Load(_appPath + "Reports\\DailyExpenseReport.rpt"); rdoc.SetDataSource(dsExpenseReport); crystalReportViewer.ReportSource = rdoc; rdoc.Refresh(); crystalReportViewer.Refresh(); crystalReportViewer.Show(); crystalReportViewer.Visible = true; btnViewReport.Enabled = true; lblPleaseWait.Visible = false; } else { crystalReportViewer.Visible = false; MessageBox.Show("No Record Found.", "School Expense", MessageBoxButtons.OK, MessageBoxIcon.Information); btnViewReport.Enabled = true; lblPleaseWait.Visible = false; } } catch (Exception ex) { } }