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