public int Insert(EligibilityEntity entity)
{
//logic goes here
EligibilityDao eligibilityDao = new EligibilityDao();
return eligibilityDao.Insert(entity);
}
public int Insert(EligibilityEntity entity)
{
try
{
Parameters = new List<SqlParameter>();
Parameters.Add(new SqlParameter("@EligibilityID", entity.EligibilityID));
Parameters.Add(new SqlParameter("@AgreementTypeID", entity.AgreementTypeID));
Parameters.Add(new SqlParameter("@FirstName", entity.FirstName));
Parameters.Add(new SqlParameter("@LastName", entity.LastName));
Parameters.Add(new SqlParameter("@SSN", entity.SSN));
object id = null;
BeginTrans();
if (entity.EligibilityID == 0)
{
Parameters.Add(new SqlParameter("@Action", "C"));
id = ExecuteScalar(DBCommands.Eligibility);
}
else
{
Parameters.Add(new SqlParameter("@Action", "U"));
ExecCommand(DBCommands.Eligibility);
id = entity.EligibilityID;
}
Commit();
return Convert.ToInt32(id);
//SqlConnection con = new SqlConnection();
//SqlCommand cmd = new SqlCommand();
//cmd.Connection = con;
//con.Open();
////aaa
////
/////
//con.Close();
}
catch
{
Rollback();
throw;
}
}
private int SaveData()
{
TextBox txtFirstName = (TextBox)gvEligibility.HeaderRow.FindControl("txtFirstName");
TextBox txtLastName = (TextBox)gvEligibility.HeaderRow.FindControl("txtLastName");
TextBox txtSSN = (TextBox)gvEligibility.HeaderRow.FindControl("txtSSN");
//AddValidation();
EligibilityEntity entity = new EligibilityEntity();
int agreementID = SessionManager.AgreementTypeID;
entity.AgreementTypeID = agreementID;
if (hdnEligibilityID.Value != string.Empty)
{
entity.EligibilityID = Convert.ToInt32(hdnEligibilityID.Value);
}
entity.FirstName = txtFirstName.Text.Trim();
entity.LastName = txtLastName.Text.Trim();
entity.SSN = txtSSN.Text.Trim();
//AddValidationControls();
EligibilityBI eligibility = new EligibilityBI();
int eligibilityID = eligibility.Insert(entity);
return eligibilityID;
}
public EligibilityEntity Read(int eligibilityID)
{
Parameters = new List<SqlParameter>();
Parameters.Add(new SqlParameter("@EligibilityID", eligibilityID));
EligibilityEntity entity = new EligibilityEntity();
SqlDataReader reader = null;
try
{
Parameters.Add(new SqlParameter("@Action", "R"));
reader = ExecDataReader(DBCommands.Eligibility);
if (reader.Read())
{
entity.EligibilityID = reader["EligibilityID"].ToInt32();
entity.FirstName = reader["FirstName"].ToStr();
entity.LastName = reader["LastName"].ToStr();
entity.SSN = reader["SSN"].ToStr();
}
}
finally
{
if (reader != null)
{
reader.Close();
reader.Dispose();
}
}
return entity;
}
public List<EligibilityEntity> ReadList(int agreementID)
{
Parameters = new List<SqlParameter>();
Parameters.Add(new SqlParameter("@AgreementTypeID", agreementID));
List<EligibilityEntity> list = new List<EligibilityEntity>();
SqlDataReader reader = null;
try
{
Parameters.Add(new SqlParameter("@Action", "RL"));
reader = ExecDataReader(DBCommands.Eligibility);
while (reader.Read())
{
EligibilityEntity entity = new EligibilityEntity();
entity.EligibilityID = reader["EligibilityID"].ToInt32();
entity.FirstName = reader["FirstName"].ToStr();
entity.LastName = reader["LastName"].ToStr();
entity.SSN = reader["SSN"].ToStr();
list.Add(entity);
}
}
finally
{
if (reader != null)
{
reader.Close();
reader.Dispose();
}
}
return list;
}
