public static HR_Documents GetHR_DocumentsByDocumentsID(int DocumentsID)
{
HR_Documents hR_Documents = new HR_Documents();
SqlHR_DocumentsProvider sqlHR_DocumentsProvider = new SqlHR_DocumentsProvider();
hR_Documents = sqlHR_DocumentsProvider.GetHR_DocumentsByDocumentsID(DocumentsID);
return hR_Documents;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_Documents hR_Documents = new HR_Documents ();
hR_Documents.DocumentsID= int.Parse(Request.QueryString["ID"].ToString());
hR_Documents.EmployeeID = Profile.card_id;
//hR_Documents.CvDocs= txtCvDocs.Text;
if (uplFile.PostedFile != null && uplFile.PostedFile.ContentLength > 0)
{
//try
//{
string dirUrl = "../HR/upload/employeer";
string dirPath = Server.MapPath(dirUrl);
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
string fileName = Path.GetFileName(uplFile.PostedFile.FileName);
string fileUrl = dirUrl + "/" + Path.GetFileName(uplFile.PostedFile.FileName);
string filePath = Server.MapPath(fileUrl);
uplFile.PostedFile.SaveAs(filePath);
hR_Documents.CvDocs = dirUrl + "/" + fileName;
//}
//catch (Exception ex)
//{
// lblMessage.Text = ex.Message.ToString();
// lblMessage.Text = lblMessage.Text + "<br />Please rename your file. ";
//}
}
else
{
hR_Documents.CvDocs = hR_Documents.CvDocs;
}
hR_Documents.JobAgreement= txtJobAgreement.Text;
hR_Documents.AddedBy= Profile.card_id;
hR_Documents.AddedDate= DateTime.Now;
hR_Documents.ModifiedBy= Profile.card_id;
hR_Documents.ModifiedDate= DateTime.Now;
bool resutl =HR_DocumentsManager.UpdateHR_Documents(hR_Documents);
Response.Redirect("AdminDisplayHR_Documents.aspx");
}
public bool UpdateHR_Documents(HR_Documents hR_Documents)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_Documents", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DocumentsID", SqlDbType.Int).Value = hR_Documents.DocumentsID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_Documents.EmployeeID;
cmd.Parameters.Add("@CvDocs", SqlDbType.NVarChar).Value = hR_Documents.CvDocs;
cmd.Parameters.Add("@JobAgreement", SqlDbType.NVarChar).Value = hR_Documents.JobAgreement;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_Documents.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_Documents.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_Documents GetHR_DocumentsFromReader(IDataReader reader)
{
try
{
HR_Documents hR_Documents = new HR_Documents
(
DataAccessObject.IsNULL<int>(reader["DocumentsID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<string>(reader["CvDocs"]),
DataAccessObject.IsNULL<string>(reader["JobAgreement"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_Documents;
}
catch(Exception ex)
{
return null;
}
}
public static int InsertHR_Documents(HR_Documents hR_Documents)
{
SqlHR_DocumentsProvider sqlHR_DocumentsProvider = new SqlHR_DocumentsProvider();
return sqlHR_DocumentsProvider.InsertHR_Documents(hR_Documents);
}
public static bool UpdateHR_Documents(HR_Documents hR_Documents)
{
SqlHR_DocumentsProvider sqlHR_DocumentsProvider = new SqlHR_DocumentsProvider();
return sqlHR_DocumentsProvider.UpdateHR_Documents(hR_Documents);
}
private void showHR_DocumentsData()
{
HR_Documents hR_Documents = new HR_Documents ();
hR_Documents = HR_DocumentsManager.GetHR_DocumentsByDocumentsID(Int32.Parse(Request.QueryString["ID"]));
//txtCvDocs.Text =hR_Documents.CvDocs.ToString();
txtJobAgreement.Text =hR_Documents.JobAgreement.ToString();
}
