/// <summary> /// Insert data into Person Table /// </summary> /// <param name="personModel"></param> /// <param name="iSqlFactory"></param> /// <returns>Object</returns> public Response InsertDataIntoPersonTable(PersonModel personModel, ISqlFactory iSqlFactory) { Response response = new Response(); try { DbCommand command; string Sqlcommand = string.Format("Insert into Person (FirstName, LastName, Age) values('{0}','{1}',{2})", personModel.FirstName, personModel.LastName, personModel.Age); using (DbConnection conn = iSqlFactory.CreateConnection()) { conn.Open(); command = iSqlFactory.ExecuteCommand(Sqlcommand, conn); int i = command.ExecuteNonQuery(); if (i > 0) { response.MessageCode = "Ok"; response.MessageDetails = "Successfully added new Paerson."; } } } catch (DbException ex) { response.MessageCode = "Error"; response.MessageDetails = ex.Message; } return(response); }
public Response EditPerson(PersonModel personModel, ISqlFactory iSqlFactory) { Response response = new Response(); try { DbCommand command; using (DbConnection conn = iSqlFactory.CreateConnection()) { string Sqlcommand = string.Format("Update Person Set FirstName = '{0}',LastName = '{1}',Age = {2} Where Id = {3};", personModel.FirstName, personModel.LastName, personModel.Age, personModel.Id); conn.Open(); command = iSqlFactory.ExecuteCommand(Sqlcommand, conn); int i = command.ExecuteNonQuery(); if (i > 0) { response.MessageCode = "Ok"; response.MessageDetails = "Update Successfull."; } } } catch (DbException DbEx) { response.MessageCode = "Error"; response.MessageDetails = DbEx.Message; } return(response); }
/// <summary> /// Get all data from from AgeGroup /// </summary> /// <param name="iSqlFactory"></param> /// <returns>list</returns> public ListAgeGroup GetAgeGroup(ISqlFactory iSqlFactory) { ListAgeGroup lAgeGroup = new ListAgeGroup(); lAgeGroup.ListOfAgeGroup = new List <AgeGroupModel>(); try { DbDataReader datareader; DbCommand command; string sqlcommand = "SELECT * From AgeGroup"; using (DbConnection conn = iSqlFactory.CreateConnection()) { conn.Open(); command = iSqlFactory.ExecuteCommand(sqlcommand, conn); datareader = command.ExecuteReader(); while (datareader.Read()) { var ageGroup = new AgeGroupModel(); ageGroup.Id = Convert.ToInt32(datareader["Id"]); ageGroup.MinAge = Convert.ToInt32(datareader["MinAge"] == DBNull.Value ? null : datareader["MinAge"]); ageGroup.MaxAge = Convert.ToInt32(datareader["MaxAge"] == DBNull.Value ? null : datareader["MaxAge"]); ageGroup.Description = datareader["Description"].ToString(); lAgeGroup.ListOfAgeGroup.Add(ageGroup); } } } catch (DbException ex) { lAgeGroup.Message.Add(new Response { MessageCode = "Error", MessageDetails = ex.Message }); } return(lAgeGroup); }
/// <summary> /// Get record from Person table. /// </summary> /// <param name="selectCommand"></param> /// <returns></returns> public ListOfPersons GetDataFromPersonTable(ISqlFactory iSqlFactory) { ListOfPersons lPerson = new ListOfPersons(); lPerson.lPersonModel = new List <PersonModel>(); PersonModel person; try { DbCommand command; DbDataReader datareader; string Sqlcommand = "Select * from Person"; using (DbConnection conn = iSqlFactory.CreateConnection()) { conn.Open(); command = iSqlFactory.ExecuteCommand(Sqlcommand, conn); datareader = command.ExecuteReader(); while (datareader.Read()) { person = new PersonModel(); person.Id = Convert.ToInt32(datareader["Id"]); person.FirstName = datareader["FirstName"].ToString(); person.LastName = datareader["LastName"].ToString(); person.Age = Convert.ToInt32(datareader["Age"]); lPerson.lPersonModel.Add(person); } } } catch (DbException ex) { lPerson.Message.Add(new Response { MessageCode = "Error", MessageDetails = ex.Message }); } return(lPerson); }