public void setupFields(UniversityModel ob) { txtApporvalAmount.Text = ob.Approval_Amount; txtApprovalDate.Text = ob.Approval_Date; txtFifthPaymentAmount.Text = ob.Fifth_Payment_Amount.ToString(); txtFifthChequeNumber.Text = ob.Fifth_Payment_Cheque_Number; txtFifthPaymentDate.Text = ob.Fifth_Payment_Date; txtFirstPaymentAmount.Text = ob.First_Payment_Amount.ToString(); txtFirstChequeNumber.Text = ob.First_Payment_Cheque_Number; txtFirstPaymentDate.Text = ob.First_Payment_Date; txtForuthPaymentAmount.Text = ob.Foruth_Payment_Amount.ToString(); txtFourthChequeNumber.Text = ob.Fourth_Payment_Cheque_Number; txtFourthPaymentDate.Text = ob.Fourth_Payment_Date; txtOrganisation.Text = ob.Organisation; txtPaymentBank.Text = ob.Payment_Bank; txtPaymentBankAccountNumber.Text = ob.Payment_Bank_Account_Number; txtProgrammeName.Text = ob.Programme_Name; txtProgramLeader.Text = ob.Program_Leader; txtProjectCode.Text = ob.Project_Code; txtSecondPaymentAmount.Text = ob.Second_Payment_Amount.ToString(); txtSecondChequeNumber.Text = ob.Second_Payment_Cheque_Number; txtSecondPaymentDate.Text = ob.Second_Payment_Date; txtSourceofFunding.Text = ob.Source_of_Funding; txtThirdPaymentAmount.Text = ob.Third_Payment_Amount.ToString(); txtThirdChequeNumber.Text = ob.Third_Payment_Cheque_Number; txtThirdPaymentDate.Text = ob.Third_Payment_Date; }
public static UniversityModel GetUniversityByProjectCode(string code) { try { using (SQLiteConnection conn = new SQLiteConnection(GetConnectionString())) { conn.Open(); string stm = "SELECT * FROM university Where Project_Code=?"; using (var cmd = new SQLiteCommand(stm, conn)) { cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = code }); SQLiteDataReader rdr = cmd.ExecuteReader(); UniversityModel ob = new UniversityModel(); while (rdr.Read()) { ob.Project_Code = rdr["Project_Code"].ToString(); ob.Organisation = rdr["Organisation"].ToString(); ob.Programme_Name = rdr["Programme_Name"].ToString(); ob.Source_of_Funding = rdr["Source_of_Funding"].ToString(); ob.Program_Leader = rdr["Program_Leader"].ToString(); ob.Approval_Date = rdr["Approval_Date"].ToString(); ob.Approval_Amount = rdr["Approval_Amount"].ToString(); ob.First_Payment_Date = rdr["First_Payment_Date"].ToString(); ob.Second_Payment_Date = rdr["Second_Payment_Date"].ToString(); ob.Third_Payment_Date = rdr["Third_Payment_Date"].ToString(); ob.Fourth_Payment_Date = rdr["Fourth_Payment_Date"].ToString(); ob.Fifth_Payment_Date = rdr["Fifth_Payment_Date"].ToString(); ob.First_Payment_Amount = Convert.ToDecimal(rdr["First_Payment_Amount"]); ob.Second_Payment_Amount = Convert.ToDecimal(rdr["Second_Payment_Amount"]); ob.Third_Payment_Amount = Convert.ToDecimal(rdr["Third_Payment_Amount"]); ob.Foruth_Payment_Amount = Convert.ToDecimal(rdr["Foruth_Payment_Amount"]); ob.Fifth_Payment_Amount = Convert.ToDecimal(rdr["Fifth_Payment_Amount"]); ob.First_Payment_Cheque_Number = rdr["First_Payment_Cheque_Number"].ToString(); ob.Second_Payment_Cheque_Number = rdr["Second_Payment_Cheque_Number"].ToString(); ob.Third_Payment_Cheque_Number = rdr["Third_Payment_Cheque_Number"].ToString(); ob.Fourth_Payment_Cheque_Number = rdr["Fourth_Payment_Cheque_Number"].ToString(); ob.Fifth_Payment_Cheque_Number = rdr["Fifth_Payment_Cheque_Number"].ToString(); ob.Payment_Bank = rdr["Payment_Bank"].ToString(); ob.Payment_Bank_Account_Number = rdr["Payment_Bank_Account_Number"].ToString(); } return(ob); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtProjectCode.Text)) { UniversityModel data = SetFields(); SqliteDataAccess.SaveUniversity(data); MessageBox.Show("Record saved successfully."); button1_Click(sender, e); } else { MessageBox.Show("enter project code"); } }
private void btnGet_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtIpProjectCode.Text)) { UniversityModel data = SqliteDataAccess.GetUniversityByProjectCode(txtIpProjectCode.Text.Trim()); setupFields(data); isEditing = true; btnDelete.Visible = true; GProject_Code = data.Project_Code; } else { MessageBox.Show("enter project code"); } }
public UniversityModel SetFields() { UniversityModel ob = new UniversityModel(); ob.Approval_Amount = txtApporvalAmount.Text; ob.Approval_Date = txtApprovalDate.Text; if (!String.IsNullOrEmpty(txtFifthPaymentAmount.Text)) { ob.Fifth_Payment_Amount = Convert.ToDecimal(txtFifthPaymentAmount.Text); } ob.Fifth_Payment_Cheque_Number = txtFifthChequeNumber.Text; ob.Fifth_Payment_Date = txtFifthPaymentDate.Text; if (!String.IsNullOrEmpty(txtFirstPaymentAmount.Text)) { ob.First_Payment_Amount = Convert.ToDecimal(txtFirstPaymentAmount.Text); } ob.First_Payment_Cheque_Number = txtFirstChequeNumber.Text; ob.First_Payment_Date = txtFirstPaymentDate.Text; if (!String.IsNullOrEmpty(txtForuthPaymentAmount.Text)) { ob.Foruth_Payment_Amount = Convert.ToDecimal(txtForuthPaymentAmount.Text); } ob.Fourth_Payment_Cheque_Number = txtFourthChequeNumber.Text; ob.Fourth_Payment_Date = txtFourthPaymentDate.Text; ob.Organisation = txtOrganisation.Text; ob.Payment_Bank = txtPaymentBank.Text; ob.Payment_Bank_Account_Number = txtPaymentBankAccountNumber.Text; ob.Programme_Name = txtProgrammeName.Text; ob.Program_Leader = txtProgramLeader.Text; ob.Project_Code = txtProjectCode.Text; if (!String.IsNullOrEmpty(txtSecondPaymentAmount.Text)) { ob.Second_Payment_Amount = Convert.ToDecimal(txtSecondPaymentAmount.Text); } ob.Second_Payment_Cheque_Number = txtSecondChequeNumber.Text; ob.Second_Payment_Date = txtSecondPaymentDate.Text; ob.Source_of_Funding = txtSourceofFunding.Text; if (!String.IsNullOrEmpty(txtThirdPaymentAmount.Text)) { ob.Third_Payment_Amount = Convert.ToDecimal(txtThirdPaymentAmount.Text); } ob.Third_Payment_Cheque_Number = txtThirdChequeNumber.Text; ob.Third_Payment_Date = txtThirdPaymentDate.Text; return(ob); }
public static void SaveUniversity(UniversityModel universityModel) { try { using (SQLiteConnection conn = new SQLiteConnection(GetConnectionString())) { conn.Open(); using (var cmd = new SQLiteCommand(@"Insert into university (" + "Project_Code,Organisation,Programme_Name,Source_of_Funding," + "Program_Leader,Approval_Date,Approval_Amount,First_Payment_Date,Second_Payment_Date," + "Third_Payment_Date,Fourth_Payment_Date,Fifth_Payment_Date,First_Payment_Amount,Second_Payment_Amount," + "Third_Payment_Amount,Foruth_Payment_Amount,Fifth_Payment_Amount,First_Payment_Cheque_Number," + "Second_Payment_Cheque_Number,Third_Payment_Cheque_Number,Fourth_Payment_Cheque_Number,Fifth_Payment_Cheque_Number,Payment_Bank,Payment_Bank_Account_Number) values(?, ?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?)", conn)) { cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Project_Code }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Organisation }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Programme_Name }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Source_of_Funding }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Program_Leader }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Approval_Date }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Approval_Amount }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.First_Payment_Date }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Second_Payment_Date }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Third_Payment_Date }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Fourth_Payment_Date }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Fifth_Payment_Date }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.Decimal, Value = universityModel.First_Payment_Amount }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.Decimal, Value = universityModel.Second_Payment_Amount }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.Decimal, Value = universityModel.Third_Payment_Amount }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.Decimal, Value = universityModel.Foruth_Payment_Amount }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.Decimal, Value = universityModel.Fifth_Payment_Amount }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.First_Payment_Cheque_Number }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Second_Payment_Cheque_Number }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Third_Payment_Cheque_Number }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Fourth_Payment_Cheque_Number }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Fifth_Payment_Cheque_Number }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Payment_Bank }); cmd.Parameters.Add(new SQLiteParameter { DbType = DbType.String, Value = universityModel.Payment_Bank_Account_Number }); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw new Exception(ex.Message); } }