public static void Update(int id, FeeSchedules feeschedules) { try { db.cmd.CommandText = @"update tblFeeSchedules set FEE = @fee, Grade_ID=@gradeid, FeeType_ID=@feetypeid where Id=@id; "; db.cmd.Parameters.AddWithValue("@fee", feeschedules.Fee); db.cmd.Parameters.AddWithValue("@gradeid", feeschedules.GradesId); db.cmd.Parameters.AddWithValue("@feetypeid", feeschedules.FeeTypesId); db.cmd.Parameters.AddWithValue("@id", id); db.con.Open(); db.cmd.ExecuteNonQuery(); } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.CloseDb(db.con, db.cmd); } }
public static int Add(FeeSchedules feeSchedules) { int retvalue = -1; try { db.cmd.CommandType = CommandType.StoredProcedure; db.cmd.CommandText = "procFeeSchedules_AddFeeSchedules"; db.cmd.Parameters.AddWithValue("@Fee", feeSchedules.Fee); db.cmd.Parameters.AddWithValue("@Grade_ID", feeSchedules.GradesId); db.cmd.Parameters.AddWithValue("@FeeType_ID", feeSchedules.FeeTypesId); db.cmd.Parameters.Add("@id", SqlDbType.Int); db.cmd.Parameters["@id"].Direction = ParameterDirection.Output; db.con.Open(); db.cmd.ExecuteNonQuery(); retvalue = Convert.ToInt32(db.cmd.Parameters["@id"].Value); } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.CloseDb(db.con, db.cmd); } return(retvalue); }
public static int Add(FeeSchedules feeSchedules, FeeTypes feeTypes) { int retvalue = -1; feeSchedules.FeeTypesId = FeeTypes.Add(feeTypes); retvalue = FeeSchedules.Add(feeSchedules); return(retvalue); }
private static List <FeeSchedules> _GetListOfFeeSchedules() { List <FeeSchedules> FeeSchedules = new List <FeeSchedules>(); try { Command = @"select * from tblFeeSchedules fees join tblGrades gds on fees.Grade_ID=gds.Id join tblFeeTypes fts on fees.FeeType_ID=fts.Id"; db.cmd.CommandText = Command; db.con.Open(); SqlDataReader rdr = db.cmd.ExecuteReader(); while (rdr.Read()) { FeeSchedules singleFeeSchedules = new FeeSchedules(); singleFeeSchedules.Id = (int)rdr[0]; singleFeeSchedules.Fee = Convert.ToSingle(rdr[1]); singleFeeSchedules.GradesId = (int)rdr[2]; singleFeeSchedules.FeeTypesId = (int)rdr[3]; // var grades = new Grades(); singleFeeSchedules.Grades = Grades.ListOfGrades.SingleOrDefault(gr => gr.Id == singleFeeSchedules.GradesId); // //singleFeeSchedules.Grades.Id = (int)rdr[4]; //singleFeeSchedules.Grades.GradeName = rdr[5].ToString(); // var feetype = new FeeTypes(); singleFeeSchedules.FeeType = FeeTypes.ListOfFeeTypes.SingleOrDefault(ft => ft.Id == singleFeeSchedules.FeeTypesId); // //singleFeeSchedules.FeeType.Id = (int)rdr[6]; //singleFeeSchedules.FeeType.FeeTypeName = rdr[7].ToString(); FeeSchedules.Add(singleFeeSchedules); } } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.con.Close(); } return(FeeSchedules); }
private static List <FeeRecords> _getListOfFeeRecords() { List <FeeRecords> FeeRecords = new List <FeeRecords>(); try { Command = @"select * from tblFeeRecords;"; db.cmd.CommandText = Command; db.con.Open(); SqlDataReader rdr = db.cmd.ExecuteReader(); while (rdr.Read()) { FeeRecords singleFeeRecords = new FeeRecords(); singleFeeRecords.Id = (int)rdr[0]; singleFeeRecords.DateTime = rdr[1].ToString(); singleFeeRecords.Paid = Convert.ToBoolean(rdr[2].ToString()); singleFeeRecords.AddedByEmployeesId = (int)rdr[3]; singleFeeRecords.StudentsId = (int)rdr[4]; singleFeeRecords.FeeSchedulesId = (int)rdr[5]; Students std = new Students(); FeeSchedules fsch = new FeeSchedules(); Employees emp = new Employees(); singleFeeRecords.Employee = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleFeeRecords.AddedByEmployeesId); singleFeeRecords.Students = Students.ListOfStudents.SingleOrDefault(s => s.Id == singleFeeRecords.StudentsId); singleFeeRecords.FeeSchedules = FeeSchedules.ListOfFeeSchedules.SingleOrDefault(f => f.Id == singleFeeRecords.FeeSchedulesId); FeeRecords.Add(singleFeeRecords); } } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.con.Close(); } return(FeeRecords); }
public static void Update(int Id, FeeSchedules feeschedules, Grades grades) { feeschedules.GradesId = Grades.Add(grades); FeeSchedules.Update(Id, feeschedules); }
public FeeRecords() { Employee = new Employees(); Students = new Students(); FeeSchedules = new FeeSchedules(); }