public bool SaveFromDT(DataTable rec, string TestType, bool Status) { try { DataTable SiteTestLog = new DataTable(); #region DataTable SiteTestLog.Columns.AddRange(new DataColumn[135] { new DataColumn("TestType", typeof(string)), new DataColumn("TimeStamp", typeof(string)), new DataColumn("Latitude", typeof(double)), new DataColumn("Longitude", typeof(double)), new DataColumn("MccId", typeof(string)), new DataColumn("MncId", typeof(string)), new DataColumn("Site", typeof(string)), new DataColumn("Sector", typeof(string)), new DataColumn("SubNetworkMode", typeof(string)), new DataColumn("ActualBand", typeof(string)), new DataColumn("ActualCarrier", typeof(string)), new DataColumn("Scope", typeof(string)), new DataColumn("Band", typeof(string)), new DataColumn("Carrier", typeof(string)), new DataColumn("NetworkMode", typeof(string)), new DataColumn("CellId", typeof(string)), new DataColumn("LacId", typeof(string)), new DataColumn("PciId", typeof(string)), new DataColumn("GsmRssi", typeof(float)), new DataColumn("GsmRxQual", typeof(float)), new DataColumn("WcdmaRscp", typeof(float)), new DataColumn("WcdmaEcio", typeof(float)), new DataColumn("LteRssi", typeof(float)), new DataColumn("LteRsrp", typeof(float)), new DataColumn("LteRsrq", typeof(float)), new DataColumn("LteRsnr", typeof(float)), new DataColumn("LteCqi", typeof(float)), new DataColumn("DistanceFromSite", typeof(float)), new DataColumn("AngleToSite", typeof(float)), new DataColumn("StackTrace", typeof(string)), new DataColumn("TestResult", typeof(float)), new DataColumn("FtpStatus", typeof(string)), new DataColumn("IsHandover", typeof(int)), new DataColumn("SiteRefId", typeof(int)), new DataColumn("SectorRefId", typeof(int)), new DataColumn("NetworkModeId", typeof(int)), new DataColumn("BandId", typeof(int)), new DataColumn("CarrierId", typeof(int)), new DataColumn("ScopeId", typeof(int)), new DataColumn("WoRefId", typeof(string)), new DataColumn("FloorId", typeof(long)), new DataColumn("RRCState", typeof(String)), new DataColumn("NetMode1", typeof(String)), new DataColumn("Band1", typeof(String)), new DataColumn("CH1", typeof(String)), new DataColumn("PCI1", typeof(int)), new DataColumn("CI1", typeof(double)), new DataColumn("SS1", typeof(double)), new DataColumn("SP1", typeof(double)), new DataColumn("SQ1", typeof(double)), new DataColumn("SNR1", typeof(double)), new DataColumn("NetMode2", typeof(String)), new DataColumn("Band2", typeof(String)), new DataColumn("CH2", typeof(String)), new DataColumn("PCI2", typeof(int)), new DataColumn("CI2", typeof(double)), new DataColumn("SS2", typeof(double)), new DataColumn("SP2", typeof(double)), new DataColumn("SQ2", typeof(double)), new DataColumn("SNR2", typeof(double)), new DataColumn("NetMode3", typeof(String)), new DataColumn("Band3", typeof(String)), new DataColumn("CH3", typeof(String)), new DataColumn("PCI3", typeof(int)), new DataColumn("CI3", typeof(double)), new DataColumn("SS3", typeof(double)), new DataColumn("SP3", typeof(double)), new DataColumn("SQ3", typeof(double)), new DataColumn("SNR3", typeof(double)), new DataColumn("NetMode4", typeof(String)), new DataColumn("Band4", typeof(String)), new DataColumn("CH4", typeof(String)), new DataColumn("PCI4", typeof(int)), new DataColumn("CI4", typeof(double)), new DataColumn("SS4", typeof(double)), new DataColumn("SP4", typeof(double)), new DataColumn("SQ4", typeof(double)), new DataColumn("SNR4", typeof(double)), new DataColumn("NetMode5", typeof(String)), new DataColumn("Band5", typeof(String)), new DataColumn("CH5", typeof(String)), new DataColumn("PCI5", typeof(int)), new DataColumn("CI5", typeof(double)), new DataColumn("SS5", typeof(double)), new DataColumn("SP5", typeof(double)), new DataColumn("SQ5", typeof(double)), new DataColumn("SNR5", typeof(double)), new DataColumn("NetMode6", typeof(String)), new DataColumn("Band6", typeof(String)), new DataColumn("CH6", typeof(String)), new DataColumn("PCI6", typeof(int)), new DataColumn("CI6", typeof(double)), new DataColumn("SS6", typeof(double)), new DataColumn("SP6", typeof(double)), new DataColumn("SQ6", typeof(double)), new DataColumn("SNR6", typeof(double)), new DataColumn("NetMode7", typeof(String)), new DataColumn("Band7", typeof(String)), new DataColumn("CH7", typeof(String)), new DataColumn("PCI7", typeof(int)), new DataColumn("CI7", typeof(double)), new DataColumn("SS7", typeof(double)), new DataColumn("SP7", typeof(double)), new DataColumn("SQ7", typeof(double)), new DataColumn("SNR7", typeof(double)), new DataColumn("NetMode8", typeof(String)), new DataColumn("Band8", typeof(String)), new DataColumn("CH8", typeof(String)), new DataColumn("PCI8", typeof(int)), new DataColumn("CI8", typeof(double)), new DataColumn("SS8", typeof(double)), new DataColumn("SP8", typeof(double)), new DataColumn("SQ8", typeof(double)), new DataColumn("SNR8", typeof(double)), new DataColumn("TCH", typeof(string)), new DataColumn("FromPCI", typeof(string)), new DataColumn("ToPCI", typeof(string)), new DataColumn("PRBPercent", typeof(float)), new DataColumn("MCS", typeof(String)), new DataColumn("RB", typeof(int)), new DataColumn("Modulation", typeof(String)), new DataColumn("ModPercent", typeof(String)), new DataColumn("TM", typeof(String)), new DataColumn("RI", typeof(int)), new DataColumn("PCPDSCH", typeof(float)), new DataColumn("PCPUSCH", typeof(float)), new DataColumn("SCPDSCH", typeof(float)), new DataColumn("SCPUSCH", typeof(float)), new DataColumn("NRBand", typeof(string)), new DataColumn("NRCarrier", typeof(string)), new DataColumn("NRRsrp", typeof(float)), new DataColumn("NRRsrq", typeof(float)), new DataColumn("NRRsnr", typeof(float)), new DataColumn("NRCqi", typeof(float)), new DataColumn("NRPci", typeof(float)), }); /* * * */ #endregion #region Add Rows In DataTable foreach (DataRow item in rec.Rows) { DataRow row; row = SiteTestLog.NewRow(); row["TestType"] = TestType; row["TimeStamp"] = item["time_stamp"]; row["Latitude"] = item["latitude"]; row["Longitude"] = item["longitude"]; row["MccId"] = item["mcc"]; row["MncId"] = item["mnc"]; row["Site"] = item["site_id"]; row["Sector"] = item["sector_id"]; row["Band"] = item["band"]; row["Carrier"] = item["carrier"]; row["NetworkMode"] = item["network_mode"]; row["CellId"] = item["cell_id"]; row["LacId"] = item["lac_id"]; row["PciId"] = item["pci_id"]; row["GsmRssi"] = item["gsm_rssi"]; row["GsmRxQual"] = item["gsm_rxqual"]; row["LteRsrp"] = item["lte_rsrp"]; row["LteRsrq"] = item["lte_rsrq"]; row["LteRsnr"] = item["lte_rsnr"]; row["LteCqi"] = item["lte_cqi"]; row["NRBand"] = item["nr_band"]; row["NRCarrier"] = item["nr_carrier"]; row["NRPci"] = item["nr_pci"]; row["NRRsrp"] = item["nr_rsrp"]; row["NRRsrq"] = item["nr_rsrq"]; row["NRRsnr"] = item["nr_snr"]; row["NRCqi"] = item["nr_cqi"]; row["DistanceFromSite"] = item["distance_from_site"]; row["AngleToSite"] = item["angle_to_site"]; row["StackTrace"] = item["stack_trace"]; row["TestResult"] = item["test_result"]; row["FtpStatus"] = (item["ftp_status"].ToString() == "Running") ? 1 : 0; row["WcdmaRscp"] = item["wcdma_rscp"]; row["WcdmaEcio"] = item["wcdma_ecio"]; row["subnetworkmode"] = item["sector_netmode"]; row["actualband"] = item["sector_band"]; row["actualcarrier"] = item["sector_carrier"]; row["ishandover"] = Status; row["LteRssi"] = item["lte_rssi"]; row["Scope"] = item["sector_scope"]; row["SiteRefId"] = item["SiteRefId"]; row["SectorRefId"] = item["SectorRefId"]; row["NetworkModeId"] = item["NetworkModeId"]; row["BandId"] = item["BandId"]; row["CarrierId"] = item["CarrierId"]; row["ScopeId"] = item["ScopeId"]; row["WoRefId"] = item["WoRefId"]; row["FloorId"] = item["FloorId"]; row["RRCState"] = item["RRCState"]; row["NetMode1"] = item["NetMode1"]; row["Band1"] = item["Band1"]; row["CH1"] = item["CH1"]; row["PCI1"] = item["PCI1"]; row["CI1"] = item["CI1"]; row["SS1"] = item["SS1"]; row["SP1"] = item["SP1"]; row["SQ1"] = item["SQ1"]; row["SNR1"] = item["SNR1"]; row["NetMode2"] = item["NetMode2"]; row["Band2"] = item["Band2"]; row["CH2"] = item["CH2"]; row["PCI2"] = item["PCI2"]; row["CI2"] = item["CI2"]; row["SS2"] = item["SS2"]; row["SP2"] = item["SP2"]; row["SQ2"] = item["SQ2"]; row["SNR2"] = item["SNR2"]; row["NetMode3"] = item["NetMode3"]; row["Band3"] = item["Band3"]; row["CH3"] = item["CH3"]; row["PCI3"] = item["PCI3"]; row["CI3"] = item["CI3"]; row["SS3"] = item["SS3"]; row["SP3"] = item["SP3"]; row["SQ3"] = item["SQ3"]; row["SNR3"] = item["SNR3"]; row["NetMode4"] = item["NetMode4"]; row["Band4"] = item["Band4"]; row["CH4"] = item["CH4"]; row["PCI4"] = item["PCI4"]; row["CI4"] = item["CI4"]; row["SS4"] = item["SS4"]; row["SP4"] = item["SP4"]; row["SQ4"] = item["SQ4"]; row["SNR4"] = item["SNR4"]; row["NetMode5"] = item["NetMode5"]; row["Band5"] = item["Band5"]; row["CH5"] = item["CH5"]; row["PCI5"] = item["PCI5"]; row["CI5"] = item["CI5"]; row["SS5"] = item["SS5"]; row["SP5"] = item["SP5"]; row["SQ5"] = item["SQ5"]; row["SNR5"] = item["SNR5"]; row["NetMode6"] = item["NetMode6"]; row["Band6"] = item["Band6"]; row["CH6"] = item["CH6"]; row["PCI6"] = item["PCI6"]; row["CI6"] = item["CI6"]; row["SS6"] = item["SS6"]; row["SP6"] = item["SP6"]; row["SQ6"] = item["SQ6"]; row["SNR6"] = item["SNR6"]; row["NetMode7"] = item["NetMode7"]; row["Band7"] = item["Band7"]; row["CH7"] = item["CH7"]; row["PCI7"] = item["PCI7"]; row["CI7"] = item["CI7"]; row["SS7"] = item["SS7"]; row["SP7"] = item["SP7"]; row["SQ7"] = item["SQ7"]; row["SNR7"] = item["SNR7"]; row["NetMode8"] = item["NetMode8"]; row["Band8"] = item["Band8"]; row["CH8"] = item["CH8"]; row["PCI8"] = item["PCI8"]; row["CI8"] = item["CI8"]; row["SS8"] = item["SS8"]; row["SP8"] = item["SP8"]; row["SQ8"] = item["SQ8"]; row["SNR8"] = item["SNR8"]; row["TCH"] = item["TCH"]; row["FromPCI"] = item["from_pci"]; row["ToPCI"] = item["to_pci"]; row["PRBPercent"] = item["PRBPercent"]; row["MCS"] = item["MCS"]; row["RB"] = item["RB"]; row["Modulation"] = item["Modulation"]; row["ModPercent"] = item["ModPercent"]; row["TM"] = item["TM"]; row["RI"] = item["RI"]; row["PCPDSCH"] = item["PCPDSCH"]; row["PCPUSCH"] = item["PCPUSCH"]; row["SCPDSCH"] = item["SCPDSCH"]; row["SCPUSCH"] = item["SCPUSCH"]; SiteTestLog.Rows.Add(row); } #endregion AV_SiteTestLogDL stld = new AV_SiteTestLogDL(); stld.Insert(SiteTestLog, Status.ToString()); return(true); } catch { throw; } }
public bool Save(List <AV_SiteTestLog> rec, string Status) { try { DataTable SiteTestLog = new DataTable(); #region DataTable SiteTestLog.Columns.AddRange(new DataColumn[135] { new DataColumn("TestType", typeof(string)), new DataColumn("TimeStamp", typeof(string)), new DataColumn("Latitude", typeof(double)), new DataColumn("Longitude", typeof(double)), new DataColumn("MccId", typeof(string)), new DataColumn("MncId", typeof(string)), new DataColumn("Site", typeof(string)), new DataColumn("Sector", typeof(string)), new DataColumn("SubNetworkMode", typeof(string)), new DataColumn("ActualBand", typeof(string)), new DataColumn("ActualCarrier", typeof(string)), new DataColumn("Scope", typeof(string)), new DataColumn("Band", typeof(string)), new DataColumn("Carrier", typeof(string)), new DataColumn("NetworkMode", typeof(string)), new DataColumn("CellId", typeof(string)), new DataColumn("LacId", typeof(string)), new DataColumn("PciId", typeof(string)), new DataColumn("GsmRssi", typeof(float)), new DataColumn("GsmRxQual", typeof(float)), new DataColumn("WcdmaRscp", typeof(float)), new DataColumn("WcdmaEcio", typeof(float)), new DataColumn("LteRssi", typeof(float)), new DataColumn("LteRsrp", typeof(float)), new DataColumn("LteRsrq", typeof(float)), new DataColumn("LteRsnr", typeof(float)), new DataColumn("LteCqi", typeof(float)), new DataColumn("DistanceFromSite", typeof(float)), new DataColumn("AngleToSite", typeof(float)), new DataColumn("StackTrace", typeof(string)), new DataColumn("TestResult", typeof(float)), new DataColumn("FtpStatus", typeof(string)), new DataColumn("IsHandover", typeof(int)), new DataColumn("SiteRefId", typeof(int)), new DataColumn("SectorRefId", typeof(int)), new DataColumn("NetworkModeId", typeof(int)), new DataColumn("BandId", typeof(int)), new DataColumn("CarrierId", typeof(int)), new DataColumn("ScopeId", typeof(int)), new DataColumn("WoRefId", typeof(string)), new DataColumn("FloorId", typeof(long)), new DataColumn("RRCState", typeof(String)), new DataColumn("NetMode1", typeof(String)), new DataColumn("Band1", typeof(String)), new DataColumn("CH1", typeof(String)), new DataColumn("PCI1", typeof(int)), new DataColumn("CI1", typeof(double)), new DataColumn("SS1", typeof(double)), new DataColumn("SP1", typeof(double)), new DataColumn("SQ1", typeof(double)), new DataColumn("SNR1", typeof(double)), new DataColumn("NetMode2", typeof(String)), new DataColumn("Band2", typeof(String)), new DataColumn("CH2", typeof(String)), new DataColumn("PCI2", typeof(int)), new DataColumn("CI2", typeof(double)), new DataColumn("SS2", typeof(double)), new DataColumn("SP2", typeof(double)), new DataColumn("SQ2", typeof(double)), new DataColumn("SNR2", typeof(double)), new DataColumn("NetMode3", typeof(String)), new DataColumn("Band3", typeof(String)), new DataColumn("CH3", typeof(String)), new DataColumn("PCI3", typeof(int)), new DataColumn("CI3", typeof(double)), new DataColumn("SS3", typeof(double)), new DataColumn("SP3", typeof(double)), new DataColumn("SQ3", typeof(double)), new DataColumn("SNR3", typeof(double)), new DataColumn("NetMode4", typeof(String)), new DataColumn("Band4", typeof(String)), new DataColumn("CH4", typeof(String)), new DataColumn("PCI4", typeof(int)), new DataColumn("CI4", typeof(double)), new DataColumn("SS4", typeof(double)), new DataColumn("SP4", typeof(double)), new DataColumn("SQ4", typeof(double)), new DataColumn("SNR4", typeof(double)), new DataColumn("NetMode5", typeof(String)), new DataColumn("Band5", typeof(String)), new DataColumn("CH5", typeof(String)), new DataColumn("PCI5", typeof(int)), new DataColumn("CI5", typeof(double)), new DataColumn("SS5", typeof(double)), new DataColumn("SP5", typeof(double)), new DataColumn("SQ5", typeof(double)), new DataColumn("SNR5", typeof(double)), new DataColumn("NetMode6", typeof(String)), new DataColumn("Band6", typeof(String)), new DataColumn("CH6", typeof(String)), new DataColumn("PCI6", typeof(int)), new DataColumn("CI6", typeof(double)), new DataColumn("SS6", typeof(double)), new DataColumn("SP6", typeof(double)), new DataColumn("SQ6", typeof(double)), new DataColumn("SNR6", typeof(double)), new DataColumn("NetMode7", typeof(String)), new DataColumn("Band7", typeof(String)), new DataColumn("CH7", typeof(String)), new DataColumn("PCI7", typeof(int)), new DataColumn("CI7", typeof(double)), new DataColumn("SS7", typeof(double)), new DataColumn("SP7", typeof(double)), new DataColumn("SQ7", typeof(double)), new DataColumn("SNR7", typeof(double)), new DataColumn("NetMode8", typeof(String)), new DataColumn("Band8", typeof(String)), new DataColumn("CH8", typeof(String)), new DataColumn("PCI8", typeof(int)), new DataColumn("CI8", typeof(double)), new DataColumn("SS8", typeof(double)), new DataColumn("SP8", typeof(double)), new DataColumn("SQ8", typeof(double)), new DataColumn("SNR8", typeof(double)), new DataColumn("TCH", typeof(string)), new DataColumn("FromPCI", typeof(string)), new DataColumn("ToPCI", typeof(string)), new DataColumn("PRBPercent", typeof(float)), new DataColumn("MCS", typeof(String)), new DataColumn("RB", typeof(int)), new DataColumn("Modulation", typeof(String)), new DataColumn("ModPercent", typeof(String)), new DataColumn("TM", typeof(String)), new DataColumn("RI", typeof(int)), new DataColumn("PCPDSCH", typeof(float)), new DataColumn("PCPUSCH", typeof(float)), new DataColumn("SCPDSCH", typeof(float)), new DataColumn("SCPUSCH", typeof(float)), new DataColumn("NRBand", typeof(string)), new DataColumn("NRCarrier", typeof(string)), new DataColumn("NRRsrp", typeof(float)), new DataColumn("NRRsrq", typeof(float)), new DataColumn("NRRsnr", typeof(float)), new DataColumn("NRCqi", typeof(float)), new DataColumn("NRPci", typeof(float)), }); /* * * */ #endregion #region Add Rows In DataTable foreach (var item in rec) { DataRow row; row = SiteTestLog.NewRow(); row["TestType"] = item.TestType; row["TimeStamp"] = item.TimeStamp; row["Latitude"] = item.Latitude; row["Longitude"] = item.Longitude; row["MccId"] = item.MccId; row["MncId"] = item.MncId; row["Site"] = item.Site; row["Sector"] = item.Sector; row["Band"] = item.Band; row["Carrier"] = item.Carrier; row["NetworkMode"] = item.NetworkMode; row["CellId"] = item.CellId; row["LacId"] = item.LacId; row["PciId"] = item.PciId; row["GsmRssi"] = item.GsmRssi; row["GsmRxQual"] = item.GsmRxQual; row["LteRsrp"] = item.LteRsrp; row["LteRsrq"] = item.LteRsrq; row["LteRsnr"] = item.LteRsnr; row["LteCqi"] = item.LteCqi; row["NRBand"] = item.NRBand; row["NRCarrier"] = item.NRCarrier; row["NRRsrp"] = item.NRRsrp; row["NRRsrq"] = item.NRRsrq; row["NRRsnr"] = item.NRRsnr; row["NRCqi"] = item.NRCqi; row["NRPci"] = item.NRPci; row["DistanceFromSite"] = item.DistanceFromSite; row["AngleToSite"] = item.AngleToSite; row["StackTrace"] = item.StackTrace; row["TestResult"] = item.TestResult; row["FtpStatus"] = (item.FtpStatus == "Running")?1:0; row["WcdmaRscp"] = item.WcdmaRscp; row["WcdmaEcio"] = item.WcdmaEcio; row["SubNetworkMode"] = item.SubNetworkMode; row["ActualBand"] = item.ActualBand; row["ActualCarrier"] = item.ActualCarrier; row["IsHandover"] = item.IsHandover; row["LteRssi"] = item.LteRssi; row["Scope"] = item.Scope; row["SiteRefId"] = item.SiteRefId; row["SectorRefId"] = item.SectorRefId; row["NetworkModeId"] = item.NetworkModeId; row["CarrierId"] = item.CarrierId; row["BandId"] = item.BandId; row["ScopeId"] = item.ScopeId; row["WoRefId"] = item.WoRefId; row["FloorId"] = item.FloorId; row["RRCState"] = item.RRCState; row["NetMode1"] = item.NetMode1; row["Band1"] = item.Band1; row["CH1"] = item.CH1; row["PCI1"] = item.PCI1; row["CI1"] = item.CI1; row["SS1"] = item.SS1; row["SP1"] = item.SP1; row["SQ1"] = item.SQ1; row["SNR1"] = item.SNR1; row["NetMode2"] = item.NetMode2; row["Band2"] = item.Band2; row["CH2"] = item.CH2; row["PCI2"] = item.PCI2; row["CI2"] = item.CI2; row["SS2"] = item.SS2; row["SP2"] = item.SP2; row["SQ2"] = item.SQ2; row["SNR2"] = item.SNR2; row["NetMode3"] = item.NetMode3; row["Band3"] = item.Band3; row["CH3"] = item.CH3; row["PCI3"] = item.PCI3; row["CI3"] = item.CI3; row["SS3"] = item.SS3; row["SP3"] = item.SP3; row["SQ3"] = item.SQ3; row["SNR3"] = item.SNR3; row["NetMode4"] = item.NetMode4; row["Band4"] = item.Band4; row["CH4"] = item.CH4; row["PCI4"] = item.PCI4; row["CI4"] = item.CI4; row["SS4"] = item.SS4; row["SP4"] = item.SP4; row["SQ4"] = item.SQ4; row["SNR4"] = item.SNR4; row["NetMode5"] = item.NetMode5; row["Band5"] = item.Band5; row["CH5"] = item.CH5; row["PCI5"] = item.PCI5; row["CI5"] = item.CI5; row["SS5"] = item.SS5; row["SP5"] = item.SP5; row["SQ5"] = item.SQ5; row["SNR5"] = item.SNR5; row["NetMode6"] = item.NetMode6; row["Band6"] = item.Band6; row["CH6"] = item.CH6; row["PCI6"] = item.PCI6; row["CI6"] = item.CI6; row["SS6"] = item.SS6; row["SP6"] = item.SP6; row["SQ6"] = item.SQ6; row["SNR6"] = item.SNR6; row["NetMode7"] = item.NetMode7; row["Band7"] = item.Band7; row["CH7"] = item.CH7; row["PCI7"] = item.PCI7; row["CI7"] = item.CI7; row["SS7"] = item.SS7; row["SP7"] = item.SP7; row["SQ7"] = item.SQ7; row["SNR7"] = item.SNR7; row["NetMode8"] = item.NetMode8; row["Band8"] = item.Band8; row["CH8"] = item.CH8; row["PCI8"] = item.PCI8; row["CI8"] = item.CI8; row["SS8"] = item.SS8; row["SP8"] = item.SP8; row["SQ8"] = item.SQ8; row["SNR8"] = item.SNR8; row["TCH"] = item.TCH; row["FromPCI"] = item.FromPCI; row["ToPCI"] = item.ToPCI; row["PRBPercent"] = item.PRBPercent; row["MCS"] = item.MCS; row["RB"] = item.RB; row["Modulation"] = item.Modulation; row["ModPercent"] = item.ModPercent; row["TM"] = item.TM; row["RI"] = item.RI; row["PCPDSCH"] = item.PCPDSCH; row["PCPUSCH"] = item.PCPUSCH; row["SCPDSCH"] = item.SCPDSCH; row["SCPUSCH"] = item.SCPUSCH; SiteTestLog.Rows.Add(row); } #endregion AV_SiteTestLogDL stld = new AV_SiteTestLogDL(); stld.Insert(SiteTestLog, Status); return(true); } catch { throw; } }