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 bool SaveGrantRecords(ref SearchGrantsDto dto)
{
SQLParamCollection p = new SQLParamCollection();
p.AddWithValue("@ID", dto.ID);
p.AddWithValue("@tblUserID", dto.tblUserID);
p.AddWithValue("@moreInfoID", dto.moreInfoID);
p.AddWithValue("@IdentityVal", 0, SqlDbType.Int, ParameterDirection.Output);
return(SaveCommand("SaveGrantRecords", p));
}