public static int Add(DocumentUrls documenturls)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procDocumentUrls_AddDucumentUrls";
db.cmd.Parameters.AddWithValue("@DocumentLink", documenturls.DocumentLink);
db.cmd.Parameters.AddWithValue("@DateTime", documenturls.DateTime);
db.cmd.Parameters.AddWithValue("@AddedByEmployee_ID ", documenturls.AddedByEmployeesId);
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(StudentDocuments studentDocuments)
{
int retvalue = -1;
try
{
studentDocuments.DocumentUrls_Id = DocumentUrls.Add(studentDocuments.DocumentUrls);
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procStudentDocuments_AddStudentDocuments";
db.cmd.Parameters.AddWithValue("@Student_ID", studentDocuments.StudentsId);
db.cmd.Parameters.AddWithValue("@DocumentUrl_ID", studentDocuments.DocumentUrls_Id);
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(StudentDocuments studentDocuments, DocumentUrls documentsUrl)
{
int retvalue = -1;
studentDocuments.DocumentUrls_Id = DocumentUrls.Add(documentsUrl);
retvalue = StudentDocuments.Add(studentDocuments);
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);
}
public static void Update(int id, DocumentUrls documenturls)
{
try
{
db.cmd.CommandText = "update tblDocumentUrls set DocumentLink = @DocumentLink,DateTime=@DateTime,AddedByEmployee_ID=@AddedByEmployee_ID where Id=@id";
db.cmd.Parameters.AddWithValue("@DocumentLink", documenturls.DocumentLink);
db.cmd.Parameters.AddWithValue("@DateTime", documenturls.DateTime);
db.cmd.Parameters.AddWithValue("@AddedByEmployee_ID", documenturls.AddedByEmployeesId);
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);
}
}
private static List <DocumentUrls> _GetDocumentUrls()
{
List <DocumentUrls> documentUrls = new List <DocumentUrls>();
try
{
Command = "select * from tblDocumentUrls";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
DocumentUrls singledocumentUrl = new DocumentUrls();
singledocumentUrl.Id = (int)rdr[0];
singledocumentUrl.DocumentLink = rdr[1].ToString();
singledocumentUrl.DateTime = Convert.ToDateTime(rdr[2]);
singledocumentUrl.AddedByEmployeesId = (int)rdr[3];
singledocumentUrl.AddedByEmployees = Employees
.ListOfEmployees
.SingleOrDefault(e => e.Id == singledocumentUrl.AddedByEmployeesId);
documentUrls.Add(singledocumentUrl);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(documentUrls);
}
public StudentDocuments()
{
Students = new Students();
DocumentUrls = new DocumentUrls();
}
public EmployeeDocuments()
{
Employees = new Employees();
DocumentUrls = new DocumentUrls();
}
