public bool SavePasswordChange() { GIDB db = new GIDB(); bool bDBIsNothing = db == null; if (bDBIsNothing) { db = new GIDB(); } bool retval = false; try { UserDto obj = this; retval = db.SavePassword(ref obj); this.tblUserID = db.Identity; } catch (Exception ex) { throw new Exception("UserDto.SavePasswordChange: \r\n" + ex.Message); } finally { if (bDBIsNothing) { db = null; } } return(retval); }
public bool UpdateActive(GIDB db = null /* TODO Change to default(_) if this is not a reference type */) { bool bDBIsNothing = db == null; if (bDBIsNothing) { db = new GIDB(); } bool retval = false; try { GrantsDto obj = this; retval = db.UpdateGrantActive(ref obj); this.ID = db.Identity; } catch (Exception ex) { throw new Exception("GrantsDto.Delete: " + ex.Message + Constants.vbCrLf); } finally { if (bDBIsNothing) { db = null /* TODO Change to default(_) if this is not a reference type */; } } return(retval); }
public bool Save() { GIDB db = new GIDB(); bool bDBIsNothing = db == null; if (bDBIsNothing) { db = new GIDB(); } bool retval = false; try { SearchGrantsDto obj = this; retval = db.SaveGrantRecords(ref obj); this.ID = db.Identity; } catch (Exception ex) { throw new Exception("GrantRecordsDto.Save: \r\n" + ex.Message); } finally { if (bDBIsNothing) { db = null; } } return(retval); }
public void Populate(ref int ID, ref GIDB db) { bool bDBIsNothing = db == null; if (bDBIsNothing) { db = new GIDB(); } try { DataSet ds = db.SelectByIDGrants(ID); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; this.ID = dr["ID"]; this.GrantID = dr["GrantID"]; this.ProgramName = dr["ProgramName"]; this.AgencyName = dr["AgencyName"]; this.ContactInformation = dr["ContactInformation"]; this.GrantSubject = dr["GrantSubject"]; this.EligibleActivities = dr["EligibleActivities"]; this.LastUpdated = dr["LastUpdated"]; this.CostShareType = dr["CostShareType"]; this.CostShareDescription = dr["CostShareDescription"]; this.OtherProgramCharacteristics = dr["OtherProgramCharacteristics"]; this.ApplicationDueDate = dr["ApplicationDueDate"]; this.DueDate = dr["DueDate"]; this.ApplicationSubType = dr["ApplicationSubType"]; this.FundingType = dr["FundingType"]; this.Active = dr["Active"]; this.CreatedByUserID = dr["CreatedByUserID"]; this.DateCreated = dr["DateCreated"]; this.LastUpdatedByUserID = dr["LastUpdatedByUserID"]; this.DateLastUpdated = dr["DateLastUpdated"]; } } catch (Exception ex) { throw new Exception("Error GrantsDTO.Populate: \r\n" + ex.Message); } finally { if (bDBIsNothing) { db = null /* TODO Change to default(_) if this is not a reference type */; } } }
public void Populate(int ID) { GIDB db = new GIDB(); bool bDBIsNothing = db == null; if (bDBIsNothing) { db = new GIDB(); } try { DataSet ds = db.SelectByIDUsers(ID); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; this.tblUserID = Convert.ToInt32(dr["tblUserID"]); this.Email = Convert.ToString(dr["Email"]); this.Alias = Convert.ToString(dr["Alias"]); this.FirstName = Convert.ToString(dr["FirstName"]); this.LastName = Convert.ToString(dr["LastName"]); this.luRoleID = Convert.ToInt32(dr["luRoleID"]); this.OrganizationShortName = Convert.ToString(dr["OrganizationShortName"]); this.OrganizationFullName = Convert.ToString(dr["OrganizationFullName"]); this.Active = Convert.ToBoolean(dr["Active"]); this.CreatedByUserID = Convert.ToString(dr["CreatedByUserID"]); this.DateCreated = Convert.ToDateTime(dr["DateCreated"]); this.LastUpdatedByUserID = Convert.ToString(dr["LastUpdatedByUserID"]); this.DateLastUpdated = Convert.ToDateTime(dr["DateLastUpdated"]); this.Verified = Convert.ToBoolean(dr["Verified"]); } } catch (Exception ex) { throw new Exception("Error UserDTO.Populate: \r\n" + ex.Message); } finally { if (bDBIsNothing) { db = null; } } }