/// <summary>
/// Page load event handler
/// </summary>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
cdrPrevDate.VisibleDate = DateTime.Today;
cdrCurrentDate.Enabled = false;
//FillDatesUsingData(DateTime.Today);
ddlPrevTime.Enabled = false;
cdrPrevDate.Enabled = false;
ScoringDAL dbAccess = new ScoringDAL();
userName = HttpContext.Current.User.Identity.Name;
userName = userName.Substring(userName.IndexOf('\\') + 1);
if (Request.QueryString["user"] != null && Request.QueryString["id"] != null)
{
if (Request.QueryString["user"] == userName)
{
Dictionary<String, String> compareIDs = new Dictionary<String, String>();
compareIDs = dbAccess.getAllExistingCompareIDs();
Int32 compareIDSerial = (Request.QueryString["id"] == null) ? 0 : Convert.ToInt32(Request.QueryString["id"]);
int i = 0;
foreach (KeyValuePair<String, String> userCompareIDs in compareIDs)
{
i = i + 1;
if (i == compareIDSerial)
{
compareID = userCompareIDs.Key;
}
}
dbAccess.DeleteCompareID(compareID, userName);
}
}
//DataTable tblCompareIDs = getPrevCompareTable();
//List<String> compareIDList = new List<String>();
//compareIDList = dbAccess.getAllExistingCompareIDs();
//ClientScript.RegisterForEventValidation("mode_id");
}
else
{
dsPrevDateSelectedData = (DataSet)ViewState["selectedPrevDateDataForMonth"];
// FillDatesUsingData(DateTime.Today);
dsCurrentDateSelectedData = (DataSet)ViewState["selectedCurrentDateDataForMonth"];
compareID = Session["compareID"] == null ? "" : Session["compareID"].ToString();
ClientScript.RegisterHiddenField("isPostBack", "1");
}
}
public List<CompareIDFields> getPrevCompareIDs()
{
ScoringDAL dbAccess = new ScoringDAL();
List<String> compareIDList = new List<String>();
compareIDList = dbAccess.getAllExistingCompareIDs();
CultureInfo provider = CultureInfo.InvariantCulture;
List<CompareIDFields> compareIDObjs = new List<CompareIDFields>();
String[] comparisonData;
DateTime prevDateTime, currDateTime;
String compareID;
CompareIDFields compareIDObj;
for (int i = 0; i < compareIDList.Count; i++)
{
compareID = compareIDList[i];
comparisonData = compareID.Split('_');
if (comparisonData != null)
{
compareIDObj = new CompareIDFields();
compareIDObj.Serial = i + 1;
compareIDObj.Model = comparisonData[0];
prevDateTime = DateTime.ParseExact(comparisonData[1] + " " + comparisonData[2], "yyyyMMdd HHmmss", provider);
currDateTime = DateTime.ParseExact(comparisonData[3] + " " + comparisonData[4], "yyyyMMdd HHmmss", provider);
compareIDObj.Dates = prevDateTime.ToString() + " vs " + currDateTime.ToString();
compareIDObj.Version = comparisonData[5];
compareIDObj.Mode = comparisonData[6];
compareIDObj.Environment = comparisonData[7];
compareIDObj.Restriction = comparisonData[8];
compareIDObj.Customer = comparisonData[9];
compareIDObjs.Add(compareIDObj);
}
//allComparisonData.Add(comparisonData);
//DataRow dr = tblCompareIDs.NewRow();
//tblCompareIDs.Rows.Add(processedCompareList);
}
return compareIDObjs;
}
private DataTable getPrevCompareTable()
{
List<String> compareIDList = new List<String>();
ScoringDAL dbAccess = new ScoringDAL();
compareIDList = dbAccess.getAllExistingCompareIDs();
String[] comparisonData;
List<String[]> allComparisonData = new List<String[]>();
DataTable tblCompareIDs = grdPrevCompareIDs.DataSource as DataTable;
String[] processedCompareList = new String[8];
CultureInfo provider = CultureInfo.InvariantCulture;
DateTime prevDateTime, currDateTime;
String compareID;
if (tblCompareIDs != null)
{
for (int i = 0; i < compareIDList.Count; i++)
{
compareID = compareIDList[i];
comparisonData = compareID.Split('_');
//allComparisonData.Add(comparisonData);
DataRow dr = tblCompareIDs.NewRow();
tblCompareIDs.Rows.Add(comparisonData);
}
}
else
{
tblCompareIDs = new DataTable();
tblCompareIDs.Columns.Add("Serial");
tblCompareIDs.Columns.Add("Model");
tblCompareIDs.Columns.Add("Dates");
tblCompareIDs.Columns.Add("Version");
tblCompareIDs.Columns.Add("Mode");
tblCompareIDs.Columns.Add("Environment");
tblCompareIDs.Columns.Add("Restriction");
tblCompareIDs.Columns.Add("Customer");
for (int i = 0; i < compareIDList.Count; i++)
{
compareID = compareIDList[i];
comparisonData = compareID.Split('_');
if (comparisonData != null)
{
DataRow dr = tblCompareIDs.NewRow();
dr[0] = i + 1;
dr[1] = comparisonData[0];
prevDateTime = DateTime.ParseExact(comparisonData[1] + " " + comparisonData[2], "yyyyMMdd HHmmss", provider);
currDateTime = DateTime.ParseExact(comparisonData[3] + " " + comparisonData[4], "yyyyMMdd HHmmss", provider);
dr[2] = prevDateTime.ToString() + " vs " + currDateTime.ToString();
dr[3] = comparisonData[5];
dr[4] = comparisonData[6];
dr[5] = comparisonData[7];
dr[6] = comparisonData[8];
dr[7] = comparisonData[9];
tblCompareIDs.Rows.Add(dr);
}
//allComparisonData.Add(comparisonData);
//DataRow dr = tblCompareIDs.NewRow();
//tblCompareIDs.Rows.Add(processedCompareList);
}
}
return tblCompareIDs;
}
public static void DeleteCompareID(String serialID)
{
ScoringDAL dbAccess = new ScoringDAL();
String compareID = "";
Dictionary<String, String> compareIDs = new Dictionary<String, String>();
compareIDs = dbAccess.getAllExistingCompareIDs();
Int32 compareIDSerial = (serialID == null || serialID == "") ? 0 : Convert.ToInt32(serialID);
int i = 0;
foreach (KeyValuePair<String, String> userCompareIDs in compareIDs)
{
i = i + 1;
if (i == compareIDSerial + 1)
{
compareID = userCompareIDs.Key;
}
}
// dbAccess.DeleteCompareID(compareID);
}
/// <summary>
/// main execution code for running the comparisons
/// </summary>
private void Run(String typeOfTask)
{
//Current application user name
userName = HttpContext.Current.User.Identity.Name;
userName = userName.Substring(userName.IndexOf('\\') + 1);
ScoringDAL dbAccess = new ScoringDAL();
//changing the progress that is to be displayed on the loading division
progress = "Retrieving values from UI...";
try
{
//if the type of task is to compare based on the previous compareIDs,
//then the stored proc is called with just the username and the compareID
if (typeOfTask == "History Compare")
{
//getting all the compareIDs as a list. This list was sent to the
//client during page load, as an ajax call from jquery.
//When the datatable in prev comparison screen is clicked,
//jquery returns the serial number on the grid, through which we fetch the compareID
Dictionary<String, String> compareIDs = new Dictionary<String, String>();
compareIDs = dbAccess.getAllExistingCompareIDs();
Int32 compareIDSerial = (hifCompareIDSerial.Value == null) ? 0 : Convert.ToInt32(hifCompareIDSerial.Value);
int i = 0;
foreach (KeyValuePair<String, String> userCompareIDs in compareIDs)
{
i = i + 1;
if (i == compareIDSerial + 1)
{
compareID = userCompareIDs.Key;
}
}
//calling DAL method that calls the stored procedure
dbAccess.RefreshData("", "", "", "", "", "", "", "", "", userName, compareID);
progress = "Results populated in the database. Please refresh the specific excel to see the results.";
}
else
{
//this is the case where the user requested that the comparison results be generated at real time
//server validation for dates
if (!(cdrPrevDate.SelectedDate == Convert.ToDateTime("1/1/0001 12:00:00 AM") ||
cdrCurrentDate.SelectedDate == Convert.ToDateTime("1/1/0001 12:00:00 AM")))
{
String model, version, mode, env, restriction, customer;
String previousDate, currentDate;
String loadTime = DateTime.Now.ToString();
//getting all the required values from the user interface,
//that will be passed to the stored proc at the backend
String prevTime = Convert.ToDateTime(ddlPrevTime.SelectedValue.ToString()).ToString("HHmmss");
String currentTime = Convert.ToDateTime(ddlCurrentTime.SelectedValue.ToString()).ToString("HHmmss");
previousDate = cdrPrevDate.SelectedDate.ToString("yyyyMMdd") + "_" + prevTime;
currentDate = cdrCurrentDate.SelectedDate.ToString("yyyyMMdd") + "_" + currentTime;
model = (hifModel.Value == "") ? "Risk View" : hifModel.Value;
version = hifVersion.Value.Substring(1);
mode = hifMode.Value;
env = hifEnv.Value;
restriction = hifRestriction.Value;
customer = hifCustomer.Value;
userName = HttpContext.Current.User.Identity.Name;
userName = userName.Substring(userName.IndexOf('\\') + 1);
//preparing a compareID that is passed to the stored proc
compareID = model + "_" + previousDate + "_"
+ currentDate + "_" + version + "_" +
mode + "_" + env + "_" + restriction + "_" + customer;
//storing the compareID as a session variable
Session["compareID"] = compareID;
//changing the display status of the application
progress = "Running queries to generate comparison results...";
//calling the DAL method using the parameters passed
dbAccess.RefreshData(previousDate, currentDate, model, version, mode, env, restriction, customer, loadTime, userName, compareID);
//updating the display status
progress = "Results populated in the database. Please refresh the specific excel to see the results.";
}
else
{
//error while validating the calendar dates
progress = "Please enter the values for all the previous and current comparison dates";
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getHTMLCompareTable()
{
Dictionary<String, String> compareIDs = new Dictionary<String, String>();
ScoringDAL dbAccess = new ScoringDAL();
compareIDs = dbAccess.getAllExistingCompareIDs();
String[] comparisonData;
List<String[]> allComparisonData = new List<String[]>();
DataTable tblCompareIDs = new DataTable();
CultureInfo provider = CultureInfo.InvariantCulture;
DateTime prevDateTime, currDateTime;
String compareID, ownerName;
int i = 0;
tblCompareIDs.Columns.Add("Serial");
tblCompareIDs.Columns.Add("Model");
tblCompareIDs.Columns.Add("Dates");
tblCompareIDs.Columns.Add("Version");
tblCompareIDs.Columns.Add("Mode");
tblCompareIDs.Columns.Add("Environment");
tblCompareIDs.Columns.Add("Restriction");
tblCompareIDs.Columns.Add("Customer");
tblCompareIDs.Columns.Add("Owner");
foreach (KeyValuePair<String, String> userCompareID in compareIDs)
{
ownerName = userCompareID.Value;
compareID = userCompareID.Key;
comparisonData = compareID.Split('_');
if (comparisonData != null)
{
DataRow dr = tblCompareIDs.NewRow();
dr[0] = ++i;
dr[1] = comparisonData[0];
prevDateTime = DateTime.ParseExact(comparisonData[1] + " " + comparisonData[2], "yyyyMMdd HHmmss", provider);
currDateTime = DateTime.ParseExact(comparisonData[3] + " " + comparisonData[4], "yyyyMMdd HHmmss", provider);
dr[2] = prevDateTime.ToString() + " vs " + currDateTime.ToString();
dr[3] = "v" + comparisonData[5];
dr[4] = comparisonData[6];
dr[5] = comparisonData[7];
dr[6] = comparisonData[8];
dr[7] = comparisonData[9];
dr[8] = ownerName;
tblCompareIDs.Rows.Add(dr);
}
//allComparisonData.Add(comparisonData);
//DataRow dr = tblCompareIDs.NewRow();
//tblCompareIDs.Rows.Add(processedCompareList);
}
// return "{\"aaData\" : " + GetJson(tblCompareIDs) + "}";
return GetJson(tblCompareIDs);
}
public string getHTMLCompareTable1()
{
Dictionary<String, String> compareIDs = new Dictionary<String, String>();
ScoringDAL dbAccess = new ScoringDAL();
compareIDs = dbAccess.getAllExistingCompareIDs();
String compareID;
String[] comparisonData;
DateTime prevDateTime, currDateTime;
CultureInfo provider = CultureInfo.InvariantCulture;
List<String[]> allCompareData = new List<String[]>();
int i = 0;
foreach (KeyValuePair<String,String> userCompareID in compareIDs)
{
compareID = userCompareID.Key;
comparisonData = compareID.Split('_');
if (comparisonData != null)
{
String[] tableData = new String[8];
//dr[0] = i + 1 + "," + comparisonData[0] + "," + prevDateTime.ToString() + " vs " +
// currDateTime.ToString() + "," + "v" + comparisonData[5] + "," +
// comparisonData[6] + "," + comparisonData[7] + "," + comparisonData[8] + "," + comparisonData[9];
tableData[0] = (i + 1).ToString();
tableData[1] = comparisonData[0];
prevDateTime = DateTime.ParseExact(comparisonData[1] + " " + comparisonData[2], "yyyyMMdd HHmmss", provider);
currDateTime = DateTime.ParseExact(comparisonData[3] + " " + comparisonData[4], "yyyyMMdd HHmmss", provider);
tableData[2] = prevDateTime.ToString() + " vs " + currDateTime.ToString();
tableData[3] = "v" + comparisonData[5];
tableData[4] = comparisonData[6];
tableData[5] = comparisonData[7];
tableData[6] = comparisonData[8];
tableData[7] = comparisonData[9];
allCompareData.Add(tableData);
}
}
//for (int i = 0; i < compareIDList.Count; i++)
//{
// compareID = compareIDList[i];
// comparisonData = compareID.Split('_');
// if (comparisonData != null)
// {
// String[] tableData = new String[8];
// //dr[0] = i + 1 + "," + comparisonData[0] + "," + prevDateTime.ToString() + " vs " +
// // currDateTime.ToString() + "," + "v" + comparisonData[5] + "," +
// // comparisonData[6] + "," + comparisonData[7] + "," + comparisonData[8] + "," + comparisonData[9];
// tableData[0] = (i + 1).ToString();
// tableData[1] = comparisonData[0];
// prevDateTime = DateTime.ParseExact(comparisonData[1] + " " + comparisonData[2], "yyyyMMdd HHmmss", provider);
// currDateTime = DateTime.ParseExact(comparisonData[3] + " " + comparisonData[4], "yyyyMMdd HHmmss", provider);
// tableData[2] = prevDateTime.ToString() + " vs " + currDateTime.ToString();
// tableData[3] = "v" + comparisonData[5];
// tableData[4] = comparisonData[6];
// tableData[5] = comparisonData[7];
// tableData[6] = comparisonData[8];
// tableData[7] = comparisonData[9];
// allCompareData.Add(tableData);
// }
// //allComparisonData.Add(comparisonData);
// //DataRow dr = tblCompareIDs.NewRow();
// //tblCompareIDs.Rows.Add(processedCompareList);
//}
// return "{\"aaData\" : " + GetJson(tblCompareIDs) + "}";
return GetJson1(allCompareData);
}