public static int Add(EmployeeDocuments employeeDocuments) { int retvalue = -1; try { employeeDocuments.DocumentUrlsId = DocumentUrls.Add(employeeDocuments.DocumentUrls); db.cmd.CommandType = CommandType.StoredProcedure; db.cmd.CommandText = "procEmployeeDocuments_AddEmployeeDocuments"; db.cmd.Parameters.AddWithValue("@Employee_ID", employeeDocuments.EmployeesId); db.cmd.Parameters.AddWithValue("@DocumentUrl_ID", employeeDocuments.DocumentUrlsId); 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(EmployeeDocuments employeeDocuments, DocumentUrls documentUrls) { int retvalue = -1; employeeDocuments.DocumentUrlsId = DocumentUrls.Add(documentUrls); retvalue = EmployeeDocuments.Add(employeeDocuments); return(retvalue); }
private static List <EmployeeDocuments> _GetEmployeeDocuments() { List <EmployeeDocuments> EmployeeDocuments = new List <EmployeeDocuments>(); try { Command = "select * from tblEmployeeDocuments"; db.cmd.CommandText = Command; db.con.Open(); SqlDataReader rdr = db.cmd.ExecuteReader(); while (rdr.Read()) { EmployeeDocuments singleEmployeeDocuments = new EmployeeDocuments(); singleEmployeeDocuments.Id = (int)rdr[0]; singleEmployeeDocuments.EmployeesId = (int)rdr[1]; singleEmployeeDocuments.DocumentUrlsId = (int)rdr[2]; var emp = new Employees(); singleEmployeeDocuments.Employees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleEmployeeDocuments.EmployeesId); var docurl = new DocumentUrls(); singleEmployeeDocuments.DocumentUrls = DocumentUrls.ListOfDocumentUrls.SingleOrDefault(du => du.Id == singleEmployeeDocuments.DocumentUrlsId); EmployeeDocuments.Add(singleEmployeeDocuments); } } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.con.Close(); } return(EmployeeDocuments); }