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