private static void GetValueFromDatabase(PersonalLoanPayment personalLoanPayment, SqlDataReader reader)
{
personalLoanPayment.PersonalLoanPaymentId = int.Parse(reader["id"].ToString());
personalLoanPayment.LoanDate = reader["date"].ToString();
personalLoanPayment.LoanType = reader["loan_type"].ToString();
personalLoanPayment.PartyName = reader["party_id"].ToString();
personalLoanPayment.Amount = Convert.ToDouble(reader["amount"].ToString());
}
public string Save(PersonalLoanPayment personalLoanPayment)
{
if (personalLoanPaymentGateway.Insert(personalLoanPayment) > 0)
{
return("Saved Successfully!!");
}
return("Could Not Save data in Database!!");
}
protected void lastButton_Click(object sender, EventArgs e)
{
List <PersonalLoanPayment> personalLoanPaymentList = (List <PersonalLoanPayment>)Session["loan"];
int x = personalLoanPaymentList.Count - 1;
PersonalLoanPayment personalLoanPayment = personalLoanPaymentManager.GetLoanParties(x);
dateTextBox.Value = personalLoanPayment.LoanDate;
typeDropDownList.Text = personalLoanPayment.LoanType;
partyDropDownList.Text = personalLoanPayment.PartyName;
amountTextBox.Text = personalLoanPayment.Amount.ToString();
Session["active"] = x;
}
public int Insert(PersonalLoanPayment personalLoanPayment)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_personalLoanPayment VALUES('" + personalLoanPayment.LoanDate + "','" +
personalLoanPayment.LoanType + "','" + personalLoanPayment.PartyId + "','" +
personalLoanPayment.Amount + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public PersonalLoanPayment GetLoanParties(int i)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_personalLoanPayment ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
PersonalLoanPayment personalLoanPayment = new PersonalLoanPayment();
while (reader.Read())
{
GetValueFromDatabase(personalLoanPayment, reader);
}
reader.Close();
connection.Close();
return(personalLoanPayment);
}
protected void saveButton_Click(object sender, EventArgs e)
{
PersonalLoanPayment personalLoanPayment = new PersonalLoanPayment();
personalLoanPayment.LoanDate = dateTextBox.Value;
personalLoanPayment.LoanType = typeDropDownList.SelectedValue;
personalLoanPayment.PartyId = int.Parse(partyDropDownList.SelectedValue);
string amount = amountTextBox.Text;
if (dateTextBox.Value == "" || typeDropDownList.Text == "" || amountTextBox.Text == "")
{
messageLabel.InnerText = "All Fields are Required!!";
}
else
{
personalLoanPayment.Amount = Convert.ToDouble(amount);
messageLabel.InnerText = personalLoanPaymentManager.Save(personalLoanPayment);
}
}
public List <PersonalLoanPayment> GetAllPersonalLoanList()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_personalLoanPayment";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <PersonalLoanPayment> personalLoanPaymentList = new List <PersonalLoanPayment>();
while (reader.Read())
{
PersonalLoanPayment personalLoanPayment = new PersonalLoanPayment();
GetValueFromDatabase(personalLoanPayment, reader);
personalLoanPaymentList.Add(personalLoanPayment);
}
reader.Close();
connection.Close();
return(personalLoanPaymentList);
}
