protected void btnAllRoles_Click(object sender, EventArgs e) { string USER_ID = Request.QueryString["USER_ID"]; WebTools.ExecuteProcedure("PRC_ADMIN_COLUMN_WISE(" + USER_ID + ")"); Master.show_success("Saved"); }
protected void ImageButtonProcedure_Click(object sender, System.Web.UI.ImageClickEventArgs e) { try { WebTools.ExecuteProcedure("PRC_BATCH_STATUS"); Master.ShowSuccess("BATCH STATUS HAS BEEN REFRESHED"); } catch (Exception ex) { Master.ShowWarn(ex.Message); } }
protected void btnRefresh_Click(object sender, EventArgs e) { try { WebTools.ExecuteProcedure("PRC_REFRESH_DASHBOARD"); Master.ShowSuccess("Data Refreshed!"); } catch (Exception ex) { Master.ShowMessage(ex.Message); } }
//amogh run protected void btnRun_Click(object sender, EventArgs e) { try { //btnRun.Enabled = false; string dir_obj = importformat.SelectedValue.ToString(); // string prc_run = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIRECTORY_NAME='" + dir_obj+"'"); WebTools.ExecuteProcedure("AMOGH_DATA_IMPORT"); string FilePath; string folderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE FOLDER_NAME='" + dir_obj + "'"); // FilePath = folderPath + "output.txt"; switch (importformat.SelectedValue) { case "AMOGH_DATA_IMPORT": //FilePath = folderPath + "output.txt"; //if (File.Exists(FilePath)) //{ // txtAmoghOutput.Text = File.ReadAllText(FilePath); //} string err = WebTools.GetExpr("LABEL", "SG_IMPORT_ERROR_CHECK_AMOGH", " WHERE SNO=1"); err += Environment.NewLine + WebTools.GetExpr("LABEL", "SG_IMPORT_ERROR_CHECK_AMOGH", " WHERE SNO=2"); err += Environment.NewLine + WebTools.GetExpr("LABEL", "SG_IMPORT_ERROR_CHECK_AMOGH", " WHERE SNO=3"); err += Environment.NewLine + WebTools.GetExpr("LABEL", "SG_IMPORT_ERROR_CHECK_AMOGH", " WHERE SNO=4"); txtAmoghOutput.Text = err; break; } RefreshButtons(); Master.ShowSuccess("Imported successfully"); //btnRun.Visible = false; //btnUpload.Visible = true; } catch (Exception ex) { Master.ShowError("Error in Importing, Try Again!" + "<br/>" + ex.Message); //btnRun.Visible = false; //btnUpload.Visible = true; } }