public void deleteRecord()
{
try
{
if (dataGridView1.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dataGridView1.SelectedCells[0].Value.ToString());
EntTransaction objent = new EntTransaction();
objent.TransactionId = id;
BLTransation objbl = new BLTransation();
int result = objbl.delertRecord(objent);
if (result > 0)
{
MessageBox.Show("Record deleted Successfully..");
bindGrid();
}
else
{
}
}
else
{
MessageBox.Show("please select record first");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public void getCustomerId()
{
BLTransation obblcustomerDetails = new BLTransation();
DataTable dt = obblcustomerDetails.getCustomerId();
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (string.IsNullOrEmpty(dt.Rows[i][j].ToString()))
{
int a = 1;
txttransationId.Text = Convert.ToString(a);
}
else
{
txttransationId.Text = dt.Rows[0][0].ToString();
}
}
}
}
private void getEndDate()
{
if (cbgroupname.SelectedValue.ToString() != "0")
{
BLTransation objTransaction = new BLTransation();
DataTable dt = objTransaction.GetEndDate(Convert.ToInt32(cbgroupname.SelectedValue));
if (dt.Rows.Count != 0)
{
EndDt = Convert.ToDateTime(dt.Rows[0]["EndDate"]);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
int GroupID = Convert.ToInt32(cbgroupname.SelectedValue.ToString());
//int TransactionID = Convert.ToInt32(txttransationId.Text);
//int CustID = Convert.ToInt32(txtbcreceivermember.Text);
try
{
if (lblMsgTransaction.Text != "")
{
if (Validate())
{
if (btnSave.Text == "Save")
{
string value = string.Empty;
string Output = string.Empty;
EntTransaction objentcustomerDetails = new EntTransaction();
objentcustomerDetails.TransactionId = Convert.ToInt32(txttransationId.Text);
objentcustomerDetails.Amount = (float)Convert.ToDouble(txtamount.Text);
objentcustomerDetails.Month = Convert.ToInt32(txtmonth.Text);
objentcustomerDetails.Member = Convert.ToInt32(txtmember.Text);
objentcustomerDetails.amountofmonth = (float)Convert.ToDouble(txtmonthandamount.Text);
objentcustomerDetails.Percentage = (float)Convert.ToDouble(txtpercenter.Text);
objentcustomerDetails.RemainingMonths = Convert.ToInt32(txtremainingmonths.Text);
objentcustomerDetails.GroupName = cbgroupname.Text;
objentcustomerDetails.MemberList = cbmemberlist.Text;
objentcustomerDetails.OffcetPrice = (float)Convert.ToDouble(txtoffcetprice.Text);
objentcustomerDetails.Loss = (float)Convert.ToDouble(txtloss.Text);
objentcustomerDetails.ActualAmountforBCCustomer = (float)Convert.ToDouble(txtactulaAmountforbccustomer.Text);
objentcustomerDetails.Installment = Convert.ToInt32(txtinstallment.Text);
objentcustomerDetails.Drawa = (float)Convert.ToDouble(txtdrawa.Text);
objentcustomerDetails.ActualInstallment = (float)Convert.ToDouble(txtactualInstallment.Text);
objentcustomerDetails.BcRecriverMember = txtbcreceivermember.Text.ToString();
objentcustomerDetails.BcDate = DateTime.Now;
objentcustomerDetails.BcDate = Convert.ToDateTime(txtbcdate.Text);
objentcustomerDetails.DueDate = DateTime.Now;
objentcustomerDetails.DueDate = Convert.ToDateTime(DueDatePicker.Text);
objentcustomerDetails.CustomerId = Convert.ToInt32(cbmemberlist.SelectedValue.ToString());
objentcustomerDetails.GroupId = Convert.ToInt32(cbgroupname.SelectedValue.ToString());
objentcustomerDetails.Drawa1Name = cmbDrawa1Name.Text;
objentcustomerDetails.Drawa2Name = cmbDrawa2Name.Text;
objentcustomerDetails.Drawa2Amount = Convert.ToInt32(txtdrawn2amount.Text);
objentcustomerDetails.RunnerUpName = cmbRunnerUp.Text;
objentcustomerDetails.RunnerUpAmount = Convert.ToInt32(txtrunerupAmount.Text.ToString());
BLTransation objblcustomerdetails = new BLTransation();
Output = objblcustomerdetails.SaveCustomer(objentcustomerDetails);
/*
* Add Payment Debit Credit code
*/
//if (Convert.ToInt32(Output) > 0)
//{
// tempResult =Convert.ToInt32(Output);
//}
////DataSet ds = objblcustomerdetails.getData(GroupID);
//int count = ds.Tables[0].Rows.Count;
//int cnt = 0;
//for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
//{
//}
//string Payment = objblcustomerdetails.AddPayment(objentcustomerDetails);
if (Output == "1")
{
MessageBox.Show("This Months Transaction Saved Successfully...");
getGroupMembers(Convert.ToInt32(cbgroupname.SelectedValue.ToString()));
bindGrid();
clearFields();
getCustomerId();
}
else
{
MessageBox.Show("Sorry..! This Months Transaction Has Been Done already");
txtbcdate.Focus();
//clearFields();
}
// clearFields();
}
else
{
string value = string.Empty;
string Output = string.Empty;
EntTransaction objentcustomerDetails = new EntTransaction();
objentcustomerDetails.TransactionId = Convert.ToInt32(txttransationId.Text);
objentcustomerDetails.Amount = (float)Convert.ToDouble(txtamount.Text);
objentcustomerDetails.Month = Convert.ToInt32(txtmonth.Text);
objentcustomerDetails.Member = Convert.ToInt32(txtmember.Text);
objentcustomerDetails.amountofmonth = (float)Convert.ToDouble(txtmonthandamount.Text);
objentcustomerDetails.Percentage = (float)Convert.ToDouble(txtpercenter.Text);
objentcustomerDetails.RemainingMonths = Convert.ToInt32(txtremainingmonths.Text);
objentcustomerDetails.GroupName = cbgroupname.Text;
objentcustomerDetails.MemberList = cbmemberlist.Text;
objentcustomerDetails.OffcetPrice = (float)Convert.ToDouble(txtoffcetprice.Text);
objentcustomerDetails.Loss = (float)Convert.ToDouble(txtloss.Text);
objentcustomerDetails.ActualAmountforBCCustomer = (float)Convert.ToDouble(txtactulaAmountforbccustomer.Text);
objentcustomerDetails.Installment = Convert.ToInt32(txtinstallment.Text);
objentcustomerDetails.Drawa = (float)Convert.ToDouble(txtdrawa.Text);
objentcustomerDetails.ActualInstallment = (float)Convert.ToDouble(txtactualInstallment.Text);
objentcustomerDetails.BcRecriverMember = txtbcreceivermember.Text.ToString();
objentcustomerDetails.BcDate = Convert.ToDateTime(txtbcdate.Text);
objentcustomerDetails.DueDate = Convert.ToDateTime(DueDatePicker.Text);
objentcustomerDetails.GroupId = Convert.ToInt32(cbgroupname.SelectedValue.ToString());
objentcustomerDetails.CustomerId = Convert.ToInt32(cbmemberlist.SelectedValue.ToString());
objentcustomerDetails.Drawa1Name = cmbDrawa1Name.Text.ToString();
objentcustomerDetails.Drawa2Name = cmbDrawa2Name.Text.ToString();
objentcustomerDetails.Drawa2Amount = Convert.ToInt32(txtdrawn2amount.Text);
objentcustomerDetails.RunnerUpName = cmbRunnerUp.Text.ToString();
objentcustomerDetails.RunnerUpAmount = Convert.ToInt32(txtrunerupAmount.Text.ToString());
BLTransation objblcustomerdetails = new BLTransation();
Output = objblcustomerdetails.SaveCustomer(objentcustomerDetails);
if (Output == "1")
{
MessageBox.Show("Transactions updated Successfully...");
}
else
{
MessageBox.Show("Transactions not updated");
}
clearFields();
bindGrid();
txtbcreceivermember.Text = "";
btnSave.Text = "Save";
getCustomerId();
// getCustomerId();
}
}
}
else
{
MessageBox.Show("Please Select Group First");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void bindGrid()
{
DataTable dt = new DataTable();
BLTransation objBL = new BLTransation();
dt = objBL.BindFullGrid();
if (dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].HeaderCell.Value = "TransactionId";
dataGridView1.Columns[0].Visible = false;
//dataGridView1.Columns[1].HeaderCell.Value = "Transaction No";
dataGridView1.Columns[1].HeaderCell.Value = "Group Name";
dataGridView1.Columns[2].HeaderCell.Value = "Amount";
dataGridView1.Columns[3].HeaderCell.Value = "Month Duration";
dataGridView1.Columns[4].HeaderCell.Value = "No. Member";
dataGridView1.Columns[5].HeaderCell.Value = "Amount Of Month";
dataGridView1.Columns[6].HeaderCell.Value = "Percentage";
dataGridView1.Columns[7].HeaderCell.Value = "Remaining Months";
dataGridView1.Columns[8].HeaderCell.Value = "Member Name";
dataGridView1.Columns[9].HeaderCell.Value = "Offcet Price";
dataGridView1.Columns[10].HeaderCell.Value = "Loss";
dataGridView1.Columns[11].HeaderCell.Value = "Actual Amount";
dataGridView1.Columns[12].HeaderCell.Value = "Actual Installment";
dataGridView1.Columns[13].HeaderCell.Value = "BC Date";
dataGridView1.Columns[14].HeaderCell.Value = "Due Date";
dataGridView1.Columns[15].HeaderCell.Value = "GroupId";
dataGridView1.Columns[15].Visible = false;
dataGridView1.Columns[16].HeaderCell.Value = "CustomerId";
dataGridView1.Columns[16].Visible = false;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.Refresh();
dataGridView1.Show();
}
}
private void updateTransaction()
{
if (dataGridView1.SelectedRows.Count > 0)
{
txttransationId.Text = Convert.ToString(dataGridView1.SelectedRows[0].Cells[0].Value);
int TransactionID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
DataTable dt = new DataTable();
BLTransation objBL = new BLTransation();
dt = objBL.FetchTransaction(TransactionID);
if (dt.Rows.Count > 0)
{
txtmonth.Text = dt.Rows[0]["DurMonth"].ToString();
txtmember.Text = dt.Rows[0]["Member"].ToString();
txtmonthandamount.Text = dt.Rows[0]["amountofmonth"].ToString();
txtpercenter.Text = Convert.ToString( dt.Rows[0]["Percentage"]);
txtremainingmonths.Text = dt.Rows[0]["RemainingMonths"].ToString();
cbgroupname.SelectedValue = dt.Rows[0]["GroupId"].ToString();
cbmemberlist.Text = dt.Rows[0]["MemberList"].ToString();
txtoffcetprice.Text = dt.Rows[0]["OffcetPrice"].ToString();
txtamount.Text = dt.Rows[0]["Amount"].ToString();
txtloss.Text = dt.Rows[0]["Loss"].ToString();
txtactulaAmountforbccustomer.Text = dt.Rows[0]["ActualAmountforBCCustomer"].ToString();
txtinstallment.Text = dt.Rows[0]["Installment"].ToString();
cmbDrawa1Name.Text = dt.Rows[0]["Drawa1Name"].ToString();
txtdrawa.Text = dt.Rows[0]["Drawa"].ToString();
txtactualInstallment.Text = dt.Rows[0]["ActualInstallment"].ToString();
txtbcdate.Text = dt.Rows[0]["BcDate"].ToString();
DueDatePicker.Text = dt.Rows[0]["DueDate"].ToString();
cmbDrawa2Name.Text = dt.Rows[0]["Drawa2Name"].ToString();
txtdrawn2amount.Text = dt.Rows[0]["Drawa2Amount"].ToString();
cmbRunnerUp.Text = dt.Rows[0]["RunnerUpName"].ToString();
txtrunerupAmount.Text = dt.Rows[0]["RunnerUpAmount"].ToString();
//loadGroupNames();
loadMembers();
}
tabControl1.SelectedIndex = 0;
btnSave.Text = "Update";
}
else
{
MessageBox.Show("Please Select the record..");
}
}
private void searchData()
{
EntTransaction objentransaction = new EntTransaction();
objentransaction.FromDate = Convert.ToDateTime(txtfromDate.Text.ToString());
objentransaction.ToDate = Convert.ToDateTime(txtToDate.Text.ToString());
BLTransation objbltransation = new BLTransation();
DataTable dt = objbltransation.searchData(objentransaction);
// SqlDataAdapter da = new SqlDataAdapter();
// da.Fill(dt);
if (dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
dataGridView1.Refresh();
dataGridView1.Show();
}
else
{
MessageBox.Show("Record does not found..");
dataGridView1.DataSource = null;
dataGridView1.Refresh();
dataGridView1.Show();
}
}
