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 int deleteRecord(EntTransaction objent) { string ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString; SqlConnection con = new SqlConnection(ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("Usp_DeleteTransaction", con); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.AddWithValue("@TransactionId", objent.TransactionId); int result = cmd.ExecuteNonQuery(); return result; con.Close(); } catch (Exception ex) { throw ex; // MessageBox.Show(ex.Message.ToString()); } finally { cmd.Dispose(); con.Close(); con.Dispose(); } }
public string AddPayment(EntTransaction objentcustomerDetails) { try { string strMessage = null; SqlConnection con = new SqlConnection(ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("Usp_SavePaymentDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TransactionID", objentcustomerDetails.TransactionId); cmd.Parameters.AddWithValue("@GroupID", objentcustomerDetails.GroupId); cmd.Parameters.AddWithValue("@BCReceiverID", objentcustomerDetails.BcRecriverMember); cmd.Parameters.AddWithValue("@DeuDate", objentcustomerDetails.DueDate); cmd.Parameters.AddWithValue("@DebitAmount", objentcustomerDetails.Amount); cmd.Parameters.AddWithValue("@CreditAmount", objentcustomerDetails.ActualAmountforBCCustomer); strMessage = cmd.ExecuteNonQuery().ToString(); return strMessage; } catch (Exception eo) { throw eo; } }
public DataTable searchData(EntTransaction objentransaction) { DLTransaction objdltransaction = new DLTransaction(); DataTable dt = objdltransaction.searchData(objentransaction); return dt; }
public int delertRecord(EntTransaction objent) { DLTransaction objdl = new DLTransaction(); int result = objdl.deleteRecord(objent); return result; }
private void getGroupMembers(int groupId) { SqlConnection con = new SqlConnection(ConnectionString); EntTransaction objentcustomerDetails = new EntTransaction(); using (SqlConnection sqlCon = new SqlConnection(ConnectionString)) { try { #region con.Open(); SqlCommand cmd = new SqlCommand("Usp_GetGroupMembers", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@GroupId", groupId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); try { if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { getInstallmentId(); string Output; objentcustomerDetails.MemberList = row.Field<String>("Name"); objentcustomerDetails.CustomerId = row.Field<int>("CustomerId"); objentcustomerDetails.InstallmentId = Convert.ToInt32(lblInstallmentID.Text); objentcustomerDetails.Amount = (float)Convert.ToDouble(txtamount.Text); objentcustomerDetails.Month = Convert.ToInt32(txtmonth.Text); objentcustomerDetails.amountofmonth = (float)Convert.ToDouble(txtmonthandamount.Text); objentcustomerDetails.GroupName = cbgroupname.Text; objentcustomerDetails.ActualAmountforBCCustomer = (float)Convert.ToDouble(txtactulaAmountforbccustomer.Text); objentcustomerDetails.ActualInstallment = (float)Convert.ToDouble(txtactualInstallment.Text); objentcustomerDetails.GroupId = Convert.ToInt32(cbgroupname.SelectedValue.ToString()); objentcustomerDetails.InstallmentStatus = "Pending"; objentcustomerDetails.BcDate = DateTime.Now; objentcustomerDetails.BcDate = Convert.ToDateTime(txtbcdate.Text); objentcustomerDetails.TransactionId = Convert.ToInt32(txttransationId.Text); BLInstallment objblcustomerdetails = new BLInstallment(); Output = objblcustomerdetails.SaveInstallmentForGroupMembers(objentcustomerDetails); //MessageBox.Show("Installment Saved Successfully For Group Members"); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { cmd.Dispose(); con.Close(); con.Dispose(); } #endregion } catch (Exception eo) { MessageBox.Show(eo.Message.ToString()); } } }
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 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(); } }
public DataTable searchData(EntTransaction objentransaction) { using (SqlConnection sqlCon = new SqlConnection(ConnectionString)) try { #region SqlCommand cmd = new SqlCommand("Usp_SearchDatabydate", sqlCon); cmd.Parameters.AddWithValue("@FromDate", objentransaction.FromDate); cmd.Parameters.AddWithValue("@ToDate", objentransaction.ToDate); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return dt; #endregion } catch(Exception ex) { throw ex; // MessageBox.Show(ex.Message.ToString()); } finally { } }