public async Task <tblPRCOBiodata> LoadOneAsync(int COBiodataID) { using (var conn = new SqlConnection(this.ConnectionString)) using (var cmd = new SqlCommand(@"SELECT * FROM dbo.tblPRCOBiodata WHERE [COBiodataID] = @COBiodataID ", conn)) { cmd.Parameters.AddWithValue("@COBiodataID", COBiodataID); await conn.OpenAsync(); using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { var item = new tblPRCOBiodata(); item.COBumiStatus = reader["COBumiStatus"].ReadNullable <bool>(); item.EmailNotifyInd = reader["EmailNotifyInd"].ReadNullable <bool>(); item.ReligionCd = reader["ReligionCd"].ReadNullableString(); item.RaceCd = reader["RaceCd"].ReadNullableString(); item.EthnicCd = reader["EthnicCd"].ReadNullableString(); item.ArmyPoliceCd = reader["ArmyPoliceCd"].ReadNullableString(); item.BloodTypeCd = reader["BloodTypeCd"].ReadNullableString(); item.MrtlStatusCd = reader["MrtlStatusCd"].ReadNullableString(); item.NatStatusCd = reader["NatStatusCd"].ReadNullableString(); item.COHPhoneStatus = reader["COHPhoneStatus"].ReadNullableString(); item.COUpdtInd = reader["COUpdtInd"].ReadNullableString(); item.EIICd = reader["EIICd"].ReadNullableString(); item.COOrigTrtry = reader["COOrigTrtry"].ReadNullableString(); item.TitleCd = reader["TitleCd"].ReadNullableString(); item.HighestEduLevelCd = reader["HighestEduLevelCd"].ReadNullableString(); item.GenderCd = reader["GenderCd"].ReadNullableString(); item.COBirthPlaceCd = reader["COBirthPlaceCd"].ReadNullableString(); item.COBirthCountryCd = reader["COBirthCountryCd"].ReadNullableString(); item.NatCd = reader["NatCd"].ReadNullableString(); item.COBirthDt = reader["COBirthDt"].ReadNullable <DateTime>(); item.COLastUpdtDt = reader["COLastUpdtDt"].ReadNullable <DateTime>(); item.COPhoto = (byte[])reader["COPhoto"]; item.COBiodataID = (int)reader["COBiodataID"]; item.COID = reader["COID"].ReadNullable <int>(); item.CONm = reader["CONm"].ReadNullableString(); item.COEmail = reader["COEmail"].ReadNullableString(); item.COOldID = reader["COOldID"].ReadNullableString(); item.COBirthCertNo = reader["COBirthCertNo"].ReadNullableString(); item.COHPhoneNo = reader["COHPhoneNo"].ReadNullableString(); item.COOffTelNo = reader["COOffTelNo"].ReadNullableString(); item.COOffTelNoExtn = reader["COOffTelNoExtn"].ReadNullableString(); item.APCrtdBy = reader["APCrtdBy"].ReadNullableString(); return(item); } } return(null); } }
public async Task <HttpResponseMessage> Insert([FromBody] tblPRCOBiodata item) { if (null == item) { throw new ArgumentNullException("item"); } var context = new tblPRCOBiodataAdapter(); await context.InsertAsync(item); var response = Request.CreateResponse(HttpStatusCode.Accepted, new { success = true, status = "OK", item }); return(response); }
public async Task <object> InsertAsync(tblPRCOBiodata item) { using (var conn = new SqlConnection(this.ConnectionString)) using (var cmd = new SqlCommand(@"INSERT INTO [dbo].[tblPRCOBiodata] ([COBumiStatus], [EmailNotifyInd], [ReligionCd], [RaceCd], [EthnicCd], [ArmyPoliceCd], [BloodTypeCd], [MrtlStatusCd], [NatStatusCd], [COHPhoneStatus], [COUpdtInd], [EIICd], [COOrigTrtry], [TitleCd], [HighestEduLevelCd], [GenderCd], [COBirthPlaceCd], [COBirthCountryCd], [NatCd], [COBirthDt], [COLastUpdtDt], [COPhoto], [COBiodataID], [COID], [CONm], [COEmail], [COOldID], [COBirthCertNo], [COHPhoneNo], [COOffTelNo], [COOffTelNoExtn], [APCrtdBy] ) VALUES( @COBumiStatus, @EmailNotifyInd, @ReligionCd, @RaceCd, @EthnicCd, @ArmyPoliceCd, @BloodTypeCd, @MrtlStatusCd, @NatStatusCd, @COHPhoneStatus, @COUpdtInd, @EIICd, @COOrigTrtry, @TitleCd, @HighestEduLevelCd, @GenderCd, @COBirthPlaceCd, @COBirthCountryCd, @NatCd, @COBirthDt, @COLastUpdtDt, @COPhoto, @COBiodataID, @COID, @CONm, @COEmail, @COOldID, @COBirthCertNo, @COHPhoneNo, @COOffTelNo, @COOffTelNoExtn, @APCrtdBy ) ", conn)) { cmd.Parameters.AddWithValue("@COBumiStatus", item.COBumiStatus.ToDbNull()); cmd.Parameters.AddWithValue("@EmailNotifyInd", item.EmailNotifyInd.ToDbNull()); cmd.Parameters.AddWithValue("@ReligionCd", item.ReligionCd.ToDbNull()); cmd.Parameters.AddWithValue("@RaceCd", item.RaceCd.ToDbNull()); cmd.Parameters.AddWithValue("@EthnicCd", item.EthnicCd.ToDbNull()); cmd.Parameters.AddWithValue("@ArmyPoliceCd", item.ArmyPoliceCd.ToDbNull()); cmd.Parameters.AddWithValue("@BloodTypeCd", item.BloodTypeCd.ToDbNull()); cmd.Parameters.AddWithValue("@MrtlStatusCd", item.MrtlStatusCd.ToDbNull()); cmd.Parameters.AddWithValue("@NatStatusCd", item.NatStatusCd.ToDbNull()); cmd.Parameters.AddWithValue("@COHPhoneStatus", item.COHPhoneStatus.ToDbNull()); cmd.Parameters.AddWithValue("@COUpdtInd", item.COUpdtInd.ToDbNull()); cmd.Parameters.AddWithValue("@EIICd", item.EIICd.ToDbNull()); cmd.Parameters.AddWithValue("@COOrigTrtry", item.COOrigTrtry.ToDbNull()); cmd.Parameters.AddWithValue("@TitleCd", item.TitleCd.ToDbNull()); cmd.Parameters.AddWithValue("@HighestEduLevelCd", item.HighestEduLevelCd.ToDbNull()); cmd.Parameters.AddWithValue("@GenderCd", item.GenderCd.ToDbNull()); cmd.Parameters.AddWithValue("@COBirthPlaceCd", item.COBirthPlaceCd.ToDbNull()); cmd.Parameters.AddWithValue("@COBirthCountryCd", item.COBirthCountryCd.ToDbNull()); cmd.Parameters.AddWithValue("@NatCd", item.NatCd.ToDbNull()); cmd.Parameters.AddWithValue("@COBirthDt", item.COBirthDt.ToDbNull()); cmd.Parameters.AddWithValue("@COLastUpdtDt", item.COLastUpdtDt.ToDbNull()); cmd.Parameters.AddWithValue("@COPhoto", item.COPhoto.ToDbNull()); cmd.Parameters.AddWithValue("@COBiodataID", item.COBiodataID); cmd.Parameters.AddWithValue("@COID", item.COID.ToDbNull()); cmd.Parameters.AddWithValue("@CONm", item.CONm.ToDbNull()); cmd.Parameters.AddWithValue("@COEmail", item.COEmail.ToDbNull()); cmd.Parameters.AddWithValue("@COOldID", item.COOldID.ToDbNull()); cmd.Parameters.AddWithValue("@COBirthCertNo", item.COBirthCertNo.ToDbNull()); cmd.Parameters.AddWithValue("@COHPhoneNo", item.COHPhoneNo.ToDbNull()); cmd.Parameters.AddWithValue("@COOffTelNo", item.COOffTelNo.ToDbNull()); cmd.Parameters.AddWithValue("@COOffTelNoExtn", item.COOffTelNoExtn.ToDbNull()); cmd.Parameters.AddWithValue("@APCrtdBy", item.APCrtdBy.ToDbNull()); await conn.OpenAsync(); return(await cmd.ExecuteNonQueryAsync()); } }
public async Task <LoadOperation <tblPRCOBiodata> > LoadAsync(string sql, int page = 1, int size = 40, bool includeTotal = false) { if (!sql.ToString().Contains("ORDER")) { sql += "\r\nORDER BY [COBiodataID]"; } var translator = new SqlPagingTranslator(); sql = translator.Translate(sql, page, size); using (var conn = new SqlConnection(this.ConnectionString)) using (var cmd = new SqlCommand(sql, conn)) { var lo = new LoadOperation <tblPRCOBiodata> { CurrentPage = page, Filter = sql, PageSize = size, }; await conn.OpenAsync(); using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { var item = new tblPRCOBiodata(); item.COBumiStatus = reader["COBumiStatus"].ReadNullable <bool>(); item.EmailNotifyInd = reader["EmailNotifyInd"].ReadNullable <bool>(); item.ReligionCd = reader["ReligionCd"].ReadNullableString(); item.RaceCd = reader["RaceCd"].ReadNullableString(); item.EthnicCd = reader["EthnicCd"].ReadNullableString(); item.ArmyPoliceCd = reader["ArmyPoliceCd"].ReadNullableString(); item.BloodTypeCd = reader["BloodTypeCd"].ReadNullableString(); item.MrtlStatusCd = reader["MrtlStatusCd"].ReadNullableString(); item.NatStatusCd = reader["NatStatusCd"].ReadNullableString(); item.COHPhoneStatus = reader["COHPhoneStatus"].ReadNullableString(); item.COUpdtInd = reader["COUpdtInd"].ReadNullableString(); item.EIICd = reader["EIICd"].ReadNullableString(); item.COOrigTrtry = reader["COOrigTrtry"].ReadNullableString(); item.TitleCd = reader["TitleCd"].ReadNullableString(); item.HighestEduLevelCd = reader["HighestEduLevelCd"].ReadNullableString(); item.GenderCd = reader["GenderCd"].ReadNullableString(); item.COBirthPlaceCd = reader["COBirthPlaceCd"].ReadNullableString(); item.COBirthCountryCd = reader["COBirthCountryCd"].ReadNullableString(); item.NatCd = reader["NatCd"].ReadNullableString(); item.COBirthDt = reader["COBirthDt"].ReadNullable <DateTime>(); item.COLastUpdtDt = reader["COLastUpdtDt"].ReadNullable <DateTime>(); item.COPhoto = (byte[])reader["COPhoto"]; item.COBiodataID = (int)reader["COBiodataID"]; item.COID = reader["COID"].ReadNullable <int>(); item.CONm = reader["CONm"].ReadNullableString(); item.COEmail = reader["COEmail"].ReadNullableString(); item.COOldID = reader["COOldID"].ReadNullableString(); item.COBirthCertNo = reader["COBirthCertNo"].ReadNullableString(); item.COHPhoneNo = reader["COHPhoneNo"].ReadNullableString(); item.COOffTelNo = reader["COOffTelNo"].ReadNullableString(); item.COOffTelNoExtn = reader["COOffTelNoExtn"].ReadNullableString(); item.APCrtdBy = reader["APCrtdBy"].ReadNullableString(); lo.ItemCollection.Add(item); } } return(lo); } }