public static int Add(Students students) { int retvalue = -1; try { Persons persons = new Persons(); persons.PersonId = students.PersonsId; persons.FirstName = students.FirstName; persons.LastName = students.LastName; persons.DateOfBirth = students.DateOfBirth; persons.CNIC = students.CNIC; persons.ImageUrlPath = students.ImageUrlPath; persons.Phone1 = students.Phone1; persons.Phone2 = students.Phone2; persons.GendersId = students.GendersId; students.PersonsId = Persons.PersonAdd(persons); students.LoginDetailsId = LoginDetails.Add(students.LoginDetails); db.cmd.CommandType = CommandType.StoredProcedure; db.cmd.CommandText = "procStudents_AddStudents"; db.cmd.Parameters.AddWithValue("@RegistrationID", students.RegistrationId); db.cmd.Parameters.AddWithValue("@DiscountPercentage", students.DiscountPercentage); db.cmd.Parameters.AddWithValue("@IdentityCardUrl", students.IdentityCardUrl); db.cmd.Parameters.AddWithValue("@AdmissionCard", students.AdmissionCard); db.cmd.Parameters.AddWithValue("@PostalAddress", students.PostalAddress); db.cmd.Parameters.AddWithValue("@ResidentialAddress", students.ResidentialAddress); db.cmd.Parameters.AddWithValue("@Person_ID", students.PersonsId); db.cmd.Parameters.AddWithValue("@LoginDetail_ID", students.LoginDetailsId); db.cmd.Parameters.AddWithValue("@Parent_ID", students.ParentsId); db.cmd.Parameters.AddWithValue("@Class_ID", students.ClassesId); 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(Parents parents) { int retvalue = -1; try { Persons persons = new Persons(); persons.FirstName = parents.FirstName; persons.LastName = parents.LastName; persons.DateOfBirth = parents.DateOfBirth; persons.CNIC = parents.CNIC; persons.ImageUrlPath = parents.ImageUrlPath; persons.Phone1 = parents.Phone1; persons.Phone2 = parents.Phone2; persons.GendersId = parents.GendersId; parents.PersonsId = Persons.PersonAdd(persons); parents.LoginDetailsId = LoginDetails.Add(parents.LoginDetails); db.cmd.CommandType = CommandType.StoredProcedure; db.cmd.CommandText = "procParents_AddParents"; db.cmd.Parameters.AddWithValue("@Person_ID", parents.PersonsId); db.cmd.Parameters.AddWithValue("@LoginDetail_ID", parents.LoginDetailsId); db.cmd.Parameters.Add("@id", SqlDbType.Int); db.cmd.Parameters["@id"].Direction = ParameterDirection.Output; db.con.Open(); db.cmd.ExecuteNonQuery(); db.con.Close(); 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(Employees employee) { Persons person = new Persons(); int retvalue = -1; try { employee.PersonsId = Persons.PersonAdd(employee); employee.LoginDetailsId = LoginDetails.Add(employee.LoginDetails); db.cmd.CommandType = CommandType.StoredProcedure; db.cmd.CommandText = "procEmployees_AddEmployees"; db.cmd.Parameters.AddWithValue("@RegistrationID", employee.RegistrationID); db.cmd.Parameters.AddWithValue("@Salary", employee.Salary); db.cmd.Parameters.AddWithValue("@IdentityCardUrl", employee.IdentityCardUrl); db.cmd.Parameters.AddWithValue("@PostalAddress", employee.PostalAddress); db.cmd.Parameters.AddWithValue("@ResidentialAddress", employee.RegistrationID); db.cmd.Parameters.AddWithValue("@AggrementUrl", employee.AggrementUrl); db.cmd.Parameters.AddWithValue("@Person_ID", employee.PersonsId); db.cmd.Parameters.AddWithValue("@Designation_ID", employee.DesignationsId); db.cmd.Parameters.AddWithValue("@EmployeeType_ID", employee.EmployeeTypesId); db.cmd.Parameters.AddWithValue("@LoginDetail_ID", employee.LoginDetailsId); 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); }