public static COMN_PersonalDocuments GetCOMN_PersonalDocumentsByPersonalDocumentsID(int PersonalDocumentsID) { COMN_PersonalDocuments cOMN_PersonalDocuments = new COMN_PersonalDocuments(); SqlCOMN_PersonalDocumentsProvider sqlCOMN_PersonalDocumentsProvider = new SqlCOMN_PersonalDocumentsProvider(); cOMN_PersonalDocuments = sqlCOMN_PersonalDocumentsProvider.GetCOMN_PersonalDocumentsByPersonalDocumentsID(PersonalDocumentsID); return cOMN_PersonalDocuments; }
public static COMN_PersonalDocuments GetCOMN_UserByUserID(string UserID) { COMN_PersonalDocuments cOMN_PersonalDocuments = new COMN_PersonalDocuments(); SqlCOMN_PersonalDocumentsProvider sqlCOMN_PersonalDocumentsProvider = new SqlCOMN_PersonalDocumentsProvider(); cOMN_PersonalDocuments = sqlCOMN_PersonalDocumentsProvider.GetCOMN_PersonalDocumentsByUserID(UserID); return cOMN_PersonalDocuments; }
private void showCOMN_PersonalDocumentsData() { COMN_PersonalDocuments cOMN_PersonalDocuments = new COMN_PersonalDocuments (); cOMN_PersonalDocuments = COMN_PersonalDocumentsManager.GetCOMN_PersonalDocumentsByPersonalDocumentsID(Int32.Parse(Request.QueryString["ID"])); ddlUserID.SelectedValue =cOMN_PersonalDocuments.UserID.ToString(); txtFileName.Text =cOMN_PersonalDocuments.FileName.ToString(); txtFileLocationUrl.Text =cOMN_PersonalDocuments.FileLocationUrl.ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { COMN_PersonalDocuments cOMN_PersonalDocuments = new COMN_PersonalDocuments (); cOMN_PersonalDocuments.PersonalDocumentsID= int.Parse(Request.QueryString["ID"].ToString()); cOMN_PersonalDocuments.UserID= ddlUserID.SelectedValue; cOMN_PersonalDocuments.FileName= txtFileName.Text; cOMN_PersonalDocuments.FileLocationUrl= txtFileLocationUrl.Text; cOMN_PersonalDocuments.AddedBy= Profile.card_id; cOMN_PersonalDocuments.AddedDate= DateTime.Now; cOMN_PersonalDocuments.ModifiedBy= Profile.card_id; cOMN_PersonalDocuments.ModifiedDate= DateTime.Now; bool resutl =COMN_PersonalDocumentsManager.UpdateCOMN_PersonalDocuments(cOMN_PersonalDocuments); Response.Redirect("AdminDisplayCOMN_PersonalDocuments.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { COMN_PersonalDocuments cOMN_PersonalDocuments = new COMN_PersonalDocuments (); // cOMN_PersonalDocuments.PersonalDocumentsID= int.Parse(ddlPersonalDocumentsID.SelectedValue); cOMN_PersonalDocuments.UserID= ddlUserID.SelectedValue; cOMN_PersonalDocuments.FileName= txtFileName.Text; cOMN_PersonalDocuments.FileLocationUrl= txtFileLocationUrl.Text; cOMN_PersonalDocuments.AddedBy= Profile.card_id; cOMN_PersonalDocuments.AddedDate= DateTime.Now; cOMN_PersonalDocuments.ModifiedBy= Profile.card_id; cOMN_PersonalDocuments.ModifiedDate= DateTime.Now; int resutl =COMN_PersonalDocumentsManager.InsertCOMN_PersonalDocuments(cOMN_PersonalDocuments); Response.Redirect("AdminCOMN_PersonalDocumentsDisplay.aspx"); }
public static bool UpdateCOMN_PersonalDocuments(COMN_PersonalDocuments cOMN_PersonalDocuments) { SqlCOMN_PersonalDocumentsProvider sqlCOMN_PersonalDocumentsProvider = new SqlCOMN_PersonalDocumentsProvider(); return sqlCOMN_PersonalDocumentsProvider.UpdateCOMN_PersonalDocuments(cOMN_PersonalDocuments); }
public static int InsertCOMN_PersonalDocuments(COMN_PersonalDocuments cOMN_PersonalDocuments) { SqlCOMN_PersonalDocumentsProvider sqlCOMN_PersonalDocumentsProvider = new SqlCOMN_PersonalDocumentsProvider(); return sqlCOMN_PersonalDocumentsProvider.InsertCOMN_PersonalDocuments(cOMN_PersonalDocuments); }
public bool UpdateCOMN_PersonalDocuments(COMN_PersonalDocuments cOMN_PersonalDocuments) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateCOMN_PersonalDocuments", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PersonalDocumentsID", SqlDbType.Int).Value = cOMN_PersonalDocuments.PersonalDocumentsID; cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = cOMN_PersonalDocuments.UserID; cmd.Parameters.Add("@FileName", SqlDbType.NVarChar).Value = cOMN_PersonalDocuments.FileName; cmd.Parameters.Add("@FileLocationUrl", SqlDbType.NVarChar).Value = cOMN_PersonalDocuments.FileLocationUrl; cmd.Parameters.Add("@FileLocationUrl", SqlDbType.NVarChar).Value = cOMN_PersonalDocuments.FileLocationUrl; cmd.Parameters.Add("@FileLocationUrl", SqlDbType.NVarChar).Value = cOMN_PersonalDocuments.FileLocationUrl; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_PersonalDocuments.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_PersonalDocuments.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public COMN_PersonalDocuments GetCOMN_PersonalDocumentsFromReader(IDataReader reader) { try { COMN_PersonalDocuments cOMN_PersonalDocuments = new COMN_PersonalDocuments ( DataAccessObject.IsNULL<int>(reader["PersonalDocumentsID"]), DataAccessObject.IsNULL<string>(reader["UserID"].ToString()), DataAccessObject.IsNULL<string>(reader["FileName"]), DataAccessObject.IsNULL<string>(reader["FileLocationUrl"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return cOMN_PersonalDocuments; } catch(Exception ex) { return null; } }