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(); }