public void updatateGisCamDetails(CamKlaliModel camKlali) { OracleConnection oConn = Connect("aradmin"); OracleDataAdapter da = new OracleDataAdapter(); OracleCommand cmd = new OracleCommand(); cmd.Connection = oConn; }
public void updateModifyDate(CamKlaliModel camKlali) { OracleConnection oConn = Connect("aradmin"); OracleDataAdapter da = new OracleDataAdapter(); OracleCommand cmd = new OracleCommand(); string site_name_ = Regex.Match(camKlali.SITE_NAME_ID, @"\d+").Value; cmd.Connection = oConn; cmd.CommandText = "update gis_cam_pramis_data_tbl A set A.MODIFIEDDAY = (TO_DATE(sysdate, 'dd/mm/yyyy hh24:mi:ss')) WHERE A.SITE_NAME_ID like '%" + site_name_ + "%'";//"UPDATE LOG_SITE_DOWN SET removedMenual='yes' WHERE SITE_ID='" + siteid + "'"; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
public void updateGisCamPramis(CamKlaliModel camKlali) { OracleConnection oConn = Connect("aradmin"); OracleDataAdapter da = new OracleDataAdapter(); OracleCommand cmd = new OracleCommand(); cmd.Connection = oConn; string site_num = Regex.Match(camKlali.SITE_NAME_ID, @"\d+").Value; cmd.CommandText = " UPDATE GIS_CAM_SITE_DETAILS_CAM A SET HOSTED='" + camKlali.HOSTED + "', A.NEEDS_GENERATOR ='" + camKlali.NEEDS_GENERATOR + "',A.SIM_NUMBER= '" + camKlali.SIM_NUM + "' WHERE A.SITE_NAME_ID like '%" + site_num + "%'";//"UPDATE LOG_SITE_DOWN SET removedMenual='yes' WHERE SITE_ID='" + siteid + "'"; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
public void updateGisCamPramis2(CamKlaliModel camKlali, string concat) { OracleConnection oConn = Connect("aradmin"); OracleDataAdapter da = new OracleDataAdapter(); OracleCommand cmd = new OracleCommand(); string site_name_ = Regex.Match(camKlali.SITE_NAME_ID, @"\d+").Value; cmd.Connection = oConn; string CHRSITEENTRCODE = camKlali.CHRSITEENTRCODE == null ? "" : camKlali.CHRSITEENTRCODE.Replace("'", ""); string TIME_REMARKS = camKlali.TIME_REMARKS == null ? "" : camKlali.TIME_REMARKS.Replace("'", ""); cmd.CommandText = " UPDATE gis_cam_pramis_data_tbl A SET A.time_remarks='" + TIME_REMARKS + "', A.TIMEGENFROM = '" + camKlali.TIMEGENFROM + "' , A.TIMEGENTO = '" + camKlali.TIMEGENTO + "' , A_24_HOURS = '" + camKlali.A_24_HOURS + "', A.CHRSITESENSITIVE ='" + camKlali.CHRSITESENSITIVE + "', A.CHRSITENEEDKEY ='" + camKlali.chrSiteNeedKey + "', A.CHRSITENEEDCOORD ='" + camKlali.CHRSITENEEDCOORD + "', A.CHRSITEENTRCODE ='" + CHRSITEENTRCODE + "',A.CHRSITECARRESTR= '" + camKlali.CHRSITECARRESTR + "', A.CHRSITESECURITY= '" + camKlali.CHRSITESECURITY + "', A.cbk= '" + concat + "',a.ROOMRESPONSIBITY='" + camKlali.roomResponsibity + "' WHERE A.SITE_NAME_ID like '%" + site_name_ + "%'";//"UPDATE LOG_SITE_DOWN SET removedMenual='yes' WHERE SITE_ID='" + siteid + "'"; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
// todo:check to update public void updateGisCamMenualFill(CamKlaliModel camKlali) { string instuctions = camKlali.ACCESS_INSTRUCTIONS == null ? "" : camKlali.ACCESS_INSTRUCTIONS.Replace("'", ""); string transbk = camKlali.HAS_TRANSMITION_BKP == null ? "" : camKlali.HAS_TRANSMITION_BKP.Replace("כן", "קיים בשטח"); OracleConnection oConn = Connect("gisOraConn"); OracleDataAdapter da = new OracleDataAdapter(); string site_name_ = Regex.Match(camKlali.SITE_NAME_ID, @"\d+").Value; OracleCommand cmd = new OracleCommand(); cmd.Connection = oConn; cmd.CommandText = " UPDATE gis_camdata_menual A SET a.electricity_source = '" + camKlali.ELECTRICITY_SOURCE + "', a.MONE_NUMBER = '" + camKlali.MONE_NUM + "', a.MMARECHET_KOAH_NUM = '" + camKlali.MMARECHET_KOAH_NUM + "', A.EZOR_HALUKA = '" + camKlali.EZOR_HALUKA + "' , A.RATZ_EZOR = '" + camKlali.RATZ_EZOR + "' , TECH_POLY = '" + camKlali.TECH_POLY + "', A.SUPPLY_SIZE ='" + camKlali.SUPPLY_SIZE + "', MNUSTRUCTURETYPE='" + camKlali.MNUSTRUCTURETYPE + "', A.ACCESS_INSTRUCTIONS ='" + instuctions + "', A.HAS_TRANSMITION_BKP ='" + transbk + "' WHERE A.SITE_NAME_ID like '%" + site_name_ + "%'"; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
public bool saveData(CamKlaliModel camKlali) { string concat = ""; string[] camCell = { camKlali.cbk_PELEPHONE, camKlali.cbk_CELLCOM, camKlali.cbk_PARTNER, camKlali.cbk_HOT_CBK }; foreach (string company in camCell) { if (company == null) { continue; } else { if (concat != "") { concat += "," + company; } else { concat += company; } } } try { updateGisCamPramis(camKlali); updateGisCamMenualFill(camKlali); updateContacts(camKlali.CamContactList, camKlali.SITE_NAME_ID); updateGisCamPramis2(camKlali, concat); updateModifyDate(camKlali); } catch (Exception ex) { Console.WriteLine("SiteDownLogHistory:Error trying to create log on DBConnection : " + ex.Message); } return(true); }