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) { }
}
