public static AjaxReturn GetConversions()
{
AjaxReturn v_return = new AjaxReturn();
ConversionsData v_return_data = new ConversionsData();
Session v_session = (Session)System.Web.HttpContext.Current.Session ["OMNIDB_SESSION"];
if (v_session == null)
{
v_return.v_error = true;
v_return.v_error_id = 1;
return(v_return);
}
System.Data.DataTable v_conversions = v_session.v_omnidb_database.v_connection.Query("select * from conversions where user_id = " + v_session.v_user_id + " order by conv_id desc", "Conversions");
System.Collections.Generic.List <System.Collections.Generic.List <string> > v_conv_list = new System.Collections.Generic.List <System.Collections.Generic.List <string> >();
int v_index = 0;
foreach (System.Data.DataRow v_conv in v_conversions.Rows)
{
System.Collections.Generic.List <string> v_connection_data_list = new System.Collections.Generic.List <string>();
string v_src_conn = "";
string v_dst_conn = "";
string v_src_tech = "";
string v_dst_tech = "";
foreach (OmniDatabase.Generic v_database in v_session.v_databases)
{
if (v_database.v_conn_id == v_conv ["conn_id_src"].ToString())
{
v_src_conn = v_database.PrintDatabaseInfo();
v_src_tech = v_database.v_db_type;
break;
}
}
foreach (OmniDatabase.Generic v_database in v_session.v_databases)
{
if (v_database.v_conn_id == v_conv ["conn_id_dst"].ToString())
{
v_dst_conn = v_database.PrintDatabaseInfo();
v_dst_tech = v_database.v_db_type;
break;
}
}
string v_bar = "";
if (v_conv ["conv_re_perc"].ToString() == "100")
{
v_bar = "bar_green";
}
else
{
v_bar = "bar_yellow";
}
string v_perc = "<div id=\"progress\" class=\"progress\"><div class=\"" + v_bar + "\" style=\"width:" + v_conv["conv_re_perc"].ToString().Replace(",", ".") + "%\"></div ><div class=\"percent\" >" + v_conv["conv_re_perc"].ToString() + "%</div></div></div>";
string v_actions = "<img src='images/table_edit.png' class='img_ht' onclick='conversionDetails(" + v_conv ["conv_id"].ToString() + ")'/>" +
"<img src='images/log.png' class='img_ht' onclick='viewLog(" + v_conv ["conv_id"].ToString() + ")'/>";
if (v_conv ["conv_ch_status"].ToString() != "E")
{
v_actions += "<img src='images/start.png' class='img_ht' onclick='startConversion(" + v_conv ["conv_id"].ToString() + ")'/>" +
"<img src='images/tab_close.png' class='img_ht' onclick='deleteConversion(" + v_conv ["conv_id"].ToString() + ")'/>";
}
else
{
v_actions += "<img src='images/stop.png' class='img_ht' onclick='stopConversion(" + v_conv ["conv_id"].ToString() + ")'/>";
}
v_connection_data_list.Add("<img src='images/" + v_src_tech + "_medium.png' class='img_ht' style='margin-right: 5px;'/>" + v_src_conn);
v_connection_data_list.Add("<img src='images/" + v_dst_tech + "_medium.png' class='img_ht' style='margin-right: 5px;'/>" + v_dst_conn);
v_connection_data_list.Add(v_conv["conv_st_start"].ToString());
v_connection_data_list.Add(v_conv["conv_st_end"].ToString());
v_connection_data_list.Add(v_perc);
v_connection_data_list.Add(v_conv["conv_ch_status"].ToString());
v_connection_data_list.Add(v_conv["conv_st_comments"].ToString());
v_connection_data_list.Add(v_conv["conv_st_duration"].ToString());
v_connection_data_list.Add(v_actions);
v_index++;
v_conv_list.Add(v_connection_data_list);
}
v_return_data.v_data = v_conv_list;
v_return.v_data = v_return_data;
return(v_return);
}
public static AjaxReturn GetConversionDetails(int p_conv_id, int p_mode)
{
AjaxReturn v_return = new AjaxReturn();
ConversionsData v_return_data = new ConversionsData();
Session v_session = (Session)System.Web.HttpContext.Current.Session ["OMNIDB_SESSION"];
if (v_session == null)
{
v_return.v_error = true;
v_return.v_error_id = 1;
return(v_return);
}
string v_filter = "";
if (p_mode == 1)
{
v_filter = " and ctd_ch_transferdata='F' ";
}
else if (p_mode == 2)
{
v_filter = " and ctd_ch_transferdata<>'F' ";
}
System.Data.DataTable v_conversions = v_session.v_omnidb_database.v_connection.Query("select * from conv_tables_data where conv_id=" + p_conv_id + v_filter + " order by conv_id desc", "Conversions");
System.Collections.Generic.List <System.Collections.Generic.List <string> > v_conv_list = new System.Collections.Generic.List <System.Collections.Generic.List <string> >();
int v_index = 0;
foreach (System.Data.DataRow v_conv in v_conversions.Rows)
{
System.Collections.Generic.List <string> v_connection_data_list = new System.Collections.Generic.List <string>();
string v_bar = "";
if (v_conv ["ctd_re_transfperc"].ToString() == "100")
{
v_bar = "bar_green";
}
else
{
v_bar = "bar_yellow";
}
string v_perc = "<div id=\"progress\" class=\"progress\"><div class=\"" + v_bar + "\" style=\"width:" + v_conv["ctd_re_transfperc"].ToString().Replace(",", ".") + "%\"></div ><div class=\"percent\" >" + v_conv["ctd_re_transfperc"].ToString() + "%</div></div></div>";
string v_estimate = "";
if (v_conv["ctd_ch_transferdata"].ToString() == "E")
{
double v_est = Convert.ToDouble(v_conv["ctd_re_transferrate"].ToString());
if (v_est != 0)
{
int v_total = int.Parse(v_conv ["ctd_in_totalrecords"].ToString());
int v_transf = int.Parse(v_conv ["ctd_in_transfrecords"].ToString());
int v_remain = v_total - v_transf;
double v_time_left = v_remain / v_est;
v_estimate = string.Format("{0:00}:{1:00}:{2:00}", v_time_left / 3600, (v_time_left / 60) % 60, v_time_left % 60);
}
}
v_connection_data_list.Add(v_conv["ctd_st_table"].ToString());
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_droprecords"].ToString() + ".png'/></div>");
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_createtable"].ToString() + ".png'/></div>");
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_createpk"].ToString() + ".png'/></div>");
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_createfk"].ToString() + ".png'/></div>");
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_createuq"].ToString() + ".png'/></div>");
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_createidx"].ToString() + ".png'/></div>");
v_connection_data_list.Add("<div style='width: 100%; text-align: center;'><img class='img_ht' src='images/status/status_" + v_conv["ctd_ch_transferdata"].ToString() + ".png'/></div>");
v_connection_data_list.Add(v_conv["ctd_st_transferfilter"].ToString());
v_connection_data_list.Add(String.Format("{0:0,0}", int.Parse(v_conv["ctd_in_totalrecords"].ToString())));
v_connection_data_list.Add(String.Format("{0:0,0}", int.Parse(v_conv["ctd_in_transfrecords"].ToString())));
v_connection_data_list.Add(v_perc);
v_connection_data_list.Add(v_conv["ctd_re_transferrate"].ToString() + " records/s");
v_connection_data_list.Add(v_estimate);
v_connection_data_list.Add(v_conv["ctd_st_starttransfer"].ToString());
v_connection_data_list.Add(v_conv["ctd_st_endtransfer"].ToString());
v_connection_data_list.Add(v_conv["ctd_st_duration"].ToString());
v_index++;
v_conv_list.Add(v_connection_data_list);
}
v_return_data.v_data = v_conv_list;
v_return.v_data = v_return_data;
return(v_return);
}
