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(); } }