// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
DBConnectionHandler.SetConnectionString(ConnectionString);
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
DBConnectionHandler.Connect();
Application.Run(new CertificatesListViewForm());
DBConnectionHandler.Disconnect();
}
public MainWindow()
{
InitializeComponent();
DBConnectionHandler.InitializeDB();
_loginView = new LoginView();
_registerView = new RegisterView();
_informationView = new InformationView();
DataContext = _loginView;
}
public ActionResult AdminPortal()
{
ViewBag.Message = "Portal de administrador";
List <ContactoFormViewModel> myList = new List <ContactoFormViewModel>();
myList = DBConnectionHandler.GetAllModels();
return(View(myList));
}
public ActionResult AdminLogin(LoginFormViewModel myModel)
{
if (DBConnectionHandler.ValidateLogIn(myModel) == true)
{
return(RedirectToAction("AdminPortal"));
}
else
{
return(RedirectToAction("AdminLogInError"));
}
}
static void Main()
{
DBConnectionHandler.Connect();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
using (var form = new CertificatesListForm())
{
Application.Run(form);
}
DBConnectionHandler.Disconnect();
}
public async Task <ActionResult> ContactoForm(ContactoFormViewModel myModel)
{
string emailBody = "<html><head><title></title></head><body><div><p>Hola Pablo, una nueva solicitud ha sido creada.</p><p>Por favor, vea la siguiente tabla para mas informacion:</p><table class='table table-bordered'><tr class='row'><td>Nombre:</td><td>Telefono:</td><td>Correo Electronico:</td><td>Mensaje:</td></tr><tr class='row'><td>@myModel.Nombre</td><td>@myModel.Telefono</td><td>@myModel.CorreoElectronico</td><td>@myModel.Mensaje</td></tr></table><p>Recuerde que tambien puede acceder al sitio web como administrador<br/>para ver todas las solicitudes en un portal bien organizado.</p></div></body></html>";
/*
* var message = await UseEmailTemplate("EmailTemplate");
* message = message.Replace("@ViewBag.Nombre", CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myModel.Nombre));
*/
await EmailHandler.SendEmailAsync("HITEF-Solicitud", emailBody);
DBConnectionHandler.AddModel(myModel);
return(View("ContactoConfirmation", myModel));
}
public object User_Role_Id()
{
string User_Id = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.SPNames.USER_FIRSTNAME);
db.AddInParameter(dbCommand, "@UserID", DbType.String, User_Id);
IDataReader dr = db.ExecuteReader(dbCommand);
if (dr.Read())
{
Session["user_role"] = dr.GetString(2);
}
return(User_Role_Id1(Session["user_role"].ToString()));
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
DBConnectionHandler.SetConnectionString(ConnectionString);
var supportedCultures = new[]
{
new CultureInfo("en-US"),
new CultureInfo("NL"),
};
app.UseRequestLocalization(new RequestLocalizationOptions
{
DefaultRequestCulture = new RequestCulture("en-US"),
// Formatting numbers, dates, etc.
SupportedCultures = supportedCultures,
// Localized UI strings.
SupportedUICultures = supportedCultures
});
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
}
public void UpdateAssignmentVisit(AssignmentVisit objAssignmentVisit)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.AssignmentVisit.SPNames.UPDATE_AssignmentVisit);
db.AddInParameter(dbCommand, "@strTo", DbType.String, objAssignmentVisit.strTo);
db.AddInParameter(dbCommand, "@strSubmittedBy", DbType.String, objAssignmentVisit.strSubmittedBy);
db.AddInParameter(dbCommand, "@strNameOfAssignment", DbType.String, objAssignmentVisit.strNameOfAssignment);
db.AddInParameter(dbCommand, "@strInCharge", DbType.String, objAssignmentVisit.strInCharge);
db.AddInParameter(dbCommand, "@strGuards", DbType.String, objAssignmentVisit.strDressing);
db.AddInParameter(dbCommand, "@strDressing", DbType.String, objAssignmentVisit.strDeployment);
db.AddInParameter(dbCommand, "@strAppearance", DbType.String, objAssignmentVisit.strAppearance);
db.AddInParameter(dbCommand, "@strHaircut", DbType.String, objAssignmentVisit.strHaircut);
db.AddInParameter(dbCommand, "@strAlertness", DbType.String, objAssignmentVisit.strAlertness);
db.AddInParameter(dbCommand, "@strDeployment", DbType.String, objAssignmentVisit.strDeployment);
db.AddInParameter(dbCommand, "@strGeneralPerformance", DbType.String, objAssignmentVisit.strGeneralPerformance);
db.AddInParameter(dbCommand, "@strOtherMatters", DbType.String, objAssignmentVisit.strOtherMatters);
db.AddInParameter(dbCommand, "@strConclussion", DbType.String, objAssignmentVisit.strConclussion);
db.AddInParameter(dbCommand, "@strRecommendation", DbType.String, objAssignmentVisit.strRecommendation);
db.AddInParameter(dbCommand, "@dtmDateVisit", DbType.Date, objAssignmentVisit.dtmDateVisit);
log4net.ILog logger1 = log4net.LogManager.GetLogger("File");
try
{
db.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
logger1.Info(ex.Message);
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
public void UpdateClientVisitMinutes(ClientVisitMinutes objClientVisitMinutes)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.ClientVisitMinutes.SPNames.UPDATE_ClientVisitMinutes);
db.AddInParameter(dbCommand, "@strAssignment", DbType.String, objClientVisitMinutes.strAssignment);
db.AddInParameter(dbCommand, "@strMetWith", DbType.String, objClientVisitMinutes.strMetWith);
db.AddInParameter(dbCommand, "@strCompletedBy", DbType.String, objClientVisitMinutes.strCompletedBy);
db.AddInParameter(dbCommand, "@strComplaints", DbType.String, objClientVisitMinutes.strComplaints);
db.AddInParameter(dbCommand, "@strPositiveComments", DbType.String, objClientVisitMinutes.strPositiveComments);
db.AddInParameter(dbCommand, "@strDeployment", DbType.String, objClientVisitMinutes.strDeployment);
db.AddInParameter(dbCommand, "@strEvents", DbType.String, objClientVisitMinutes.strEvents);
db.AddInParameter(dbCommand, "@strRemarks", DbType.String, objClientVisitMinutes.strRemarks);
db.AddInParameter(dbCommand, "@dtmDateMet", DbType.Date, objClientVisitMinutes.dtmDateMet);
log4net.ILog logger1 = log4net.LogManager.GetLogger("File");
try
{
db.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
logger1.Info(ex.Message);
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
public QuestionBoardUI(string userName, DBConnectionHandler dBConnectionHandler)
{
this.userName = userName;
this.dBConnectionHandler = dBConnectionHandler;
}
protected void Page_Load(object sender, EventArgs e)
{
rd = (RadMenu)rdDBMenu;
rd1 = (RadMenu)rdDBMenu;
if (Request.QueryString["t"] == null)
{
if (Session["SubRole"] != null)
{
//nameLabel.Text = Session["SubRole"].ToString();
//int User_Role = Convert.ToInt32(User_Role_Id(Session["SubRole"]));
Session["x"] = Session["SubRole"].ToString();
//string x = Session["SubRole"].ToString();
if (Convert.ToInt32(Session["count"]) == 1)
{
MenuBind(User_Role_Id(Session["x"].ToString()));
}
if (Convert.ToInt32(Session["count1"]) == 1)
{
MenuBind(User_Role_Id(Session["x"].ToString()));
}
if (Convert.ToInt32(Session["count2"]) == 1)
{
MenuBind(User_Role_Id(Session["x"].ToString()));
}
if (Convert.ToInt32(Session["count3"]) == 1)
{
MenuBind(User_Role_Id(Session["x"].ToString()));
}
}
}
//-------------------------------------------------------------
//-----------change by rakesh jaiswal-----------------------
try
{
Session["User_Id"] = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
string x = (string)Session["User_id"];
//string User_Id = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.SPNames.USER_FIRSTNAME);
db.AddInParameter(dbCommand, "@UserID", DbType.String, Session["User_Id"].ToString());
IDataReader dr = db.ExecuteReader(dbCommand);
if (dr.Read())
{
if (dr.GetString(0).ToString() != "")
{
image1.ImageUrl = dr.GetString(0);
nameLabel.Text = dr.GetString(1);
Session["role"] = Session["user_role"] = dr.GetString(2);
}
else
{
nameLabel.Text = dr.GetString(1);
image1.ImageUrl = "~/Images/avatar.png";
//string x1 = dr.GetString(2);
Session["role"] = dr.GetString(2);
Session["role"] = Session["user_role"] = dr.GetString(2);
}
}
//=============================//
dr.Close();
dr.Dispose();
//=========================//
}
catch (Exception exc)
{
image1.ImageUrl = "~/Images/avatar.png";
}
//-----------end of change-----------------------------------------------------
//--------------------------------------------------------------------------
if (Session["SubRole"] == null)
{
if (Session["user_role"].ToString().ToLower() == "superuser")
{
}
else
{
Session["x2"] = Session["user_role"].ToString();
MenuBind(User_Role_Id(Session["x2"].ToString()));
}
}
}
protected void LoginCheck(string username,string password)
{
/*string getuserRole = string.Empty;
try
{
if (!AuthenticateUser())
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "Alert", "alert('Invalid User Name or Password');",true);
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "Referer", "location.href('index.html');", true);
}
else
{
DataTable dt = dal.getdata("select Role from UserInformation Where UserID='" + username.Trim() + "'");
Session["user_role"]=Session["role"] = dt.Rows[0][0].ToString();
Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER] = username;
getuserRole = GetAuthenticateUserRoleAndID();
Session["ManagementRole"] = getuserRole.Split(new string[] { "||" }, StringSplitOptions.None)[0];
Session["StaffID"] = getuserRole.Split(new string[] { "||" }, StringSplitOptions.None)[1];
// Session["LCID"] = "-select-";//int.Parse(ddlLocation.SelectedValue);
try
{
switch (Session["role"].ToString())
{
case "Security Officer":
Response.Redirect("SMSCommons/VerifyLogin.aspx");
break;
case "Supervisor":
Response.Redirect("SMSCommons/VerifyLogin.aspx");
break;
default:
Response.Redirect("SMSCommons/Default.aspx");
break;
}
switch (Session["user_role"].ToString())
{
case "Security Officer":
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("VerifyLogin.aspx");
break;
case "Supervisor":
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("VerifyLogin.aspx");
break;
default:
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("login.aspx");
break;
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}*/
try
{
if (!AuthenticateUser())
{
//errorLabel.Text = "Please Enter Valid UserID And Password";
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "Alert", "alert('Invalid User Name or Password');", true);
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "Referer", "location.href('index.html');", true);
}
else
{
string User_Id = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.SPNames.USER_FIRSTNAME);
db.AddInParameter(dbCommand, "@UserID", DbType.String, User_Id);
IDataReader dr = db.ExecuteReader(dbCommand);
if (dr.Read())
{
Session["user_role"] = dr.GetString(2);
Session["StaffID"] = dr.GetString(3);
}
string xx = Session["user_role"].ToString();
switch (Session["user_role"].ToString())
{
case "Security Officer":
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("master/VerifyLogin.aspx");
break;
case "Supervisor":
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("master/VerifyLogin.aspx");
break;
default:
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("master/login.aspx");
break;
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//------change by rakesh------------------
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
if (!AuthenticateUser())
{
Labelerror.Text = "Please Enter Valid UserID And Password";
}
else
{
string User_Id = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.SPNames.USER_FIRSTNAME);
db.AddInParameter(dbCommand, "@UserID", DbType.String, User_Id);
IDataReader dr = db.ExecuteReader(dbCommand);
if (dr.Read())
{
Session["user_role"] = dr.GetString(2);
Session["StaffID"] = dr.GetString(3);
Session["StaffID1"] = dr.GetString(3);
Session["NricNoOfStaff"] = dr.GetString(4);
}
dr.Close();
dr.Dispose();
//-----Alert Code start-----//
SqlParameter[] para1 = new SqlParameter[2];
para1[0] = new SqlParameter("@Staff_ID", SqlDbType.VarChar);
para1[0].Value = Session["StaffID"].ToString();
para1[1] = new SqlParameter("@ActiveStatus", SqlDbType.VarChar);
para1[1].Value = "1";
dal.exeprocedure("SP_UpdateuserinformationActiveStatus", para1);
//-----Alert Code End-----//
string xx = Session["user_role"].ToString();
switch (Session["user_role"].ToString())
{
case "Security Officer":
Session["ManagementRole"] = Session["user_role"];
int roleid = User_Role_Id("Security Officer");
Session["RoleID"] = roleid;
// Response.Redirect("VerifyLogin.aspx");
ModalPopupVerify.Show();
populatecontrol();
break;
case "Supervisor":
Session["ManagementRole"] = Session["user_role"];
int roleid2 = User_Role_Id("Supervisor");
Session["RoleID"] = roleid2;
//Response.Redirect("VerifyLogin.aspx");
ModalPopupVerify.Show();
populatecontrol();
break;
default:
Session["ManagementRole"] = Session["user_role"];
Response.Redirect("login.aspx");
break;
}
}
}
catch (Exception ex)
{
logger.Info("Error:" + ex.Message);
Response.Write(ex.Message);
}
//-----end of change----------------------
}
public QuestionViewUI(string username, int userid, DBConnectionHandler dBConnectionHandler)
{
this.userName = username;
this.userID = userid;
this.dBConnectionHandler = dBConnectionHandler;
}
public AskAQuestionUI(string username, int userID, DBConnectionHandler dBConnectionHandler)
{
this.username = username;
this.userID = userID;
this.dBConnectionHandler = dBConnectionHandler;
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Header.DataBind();
if (Session["StaffID1"] != null)
{
HiddenFieldID.Value = Session["StaffID1"].ToString();
}
if (Request.QueryString["t"] == null)
{
if (Session["SubRole"] != null)
{
Session["x"] = Session["SubRole"].ToString();
}
}
#region Dynamically Displaying Logo
DBConnectionHandler1 bd = new DBConnectionHandler1();
SqlConnection cn = bd.getconnection();
cn.Open();
SqlCommand cmd = new SqlCommand("select ImagePath,fullpathname from UploadLogo", cn);
SqlDataReader drLogo = cmd.ExecuteReader();
if (drLogo.Read())
{
if (drLogo.GetString(0) != "")
{
imgHeaderLogo.ImageUrl = drLogo.GetString(0);
drLogo.Close();
cn.Close();
}
}
else
{
imgHeaderLogo.ImageUrl = "../img/dsys_header_logo_new.png";
}
#endregion
//-------------------------------------------------------------
//-----------change by rakesh jaiswal-----------------------
try
{
Session["User_Id"] = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
string x = (string)Session["User_id"];
//string User_Id = Session[SMSAppUtilities.SessionKeys.SESSION_LOGIN_USER_ID].ToString();
Database db = DBConnectionHandler.GetDBConnection().DBConnection;
DbCommand dbCommand = db.GetStoredProcCommand(DALConstants.SPNames.USER_FIRSTNAME);
db.AddInParameter(dbCommand, "@UserID", DbType.String, Session["User_Id"].ToString());
IDataReader dr = db.ExecuteReader(dbCommand);
if (dr.Read())
{
if (dr.GetString(0).ToString() != "")
{
image1.ImageUrl = dr.GetString(0);
nameLabel.Text = dr.GetString(1);
Session["role"] = Session["user_role"] = dr.GetString(2);
}
else
{
nameLabel.Text = dr.GetString(1);
image1.ImageUrl = "~/Images/avatar.png";
//string x1 = dr.GetString(2);
Session["role"] = dr.GetString(2);
Session["role"] = Session["user_role"] = dr.GetString(2);
}
}
//=============================//
dr.Close();
dr.Dispose();
//=========================//
}
catch (Exception exc)
{
image1.ImageUrl = "~/Images/avatar.png";
}
//-----------end of change-----------------------------------------------------
//--------------------------------------------------------------------------
if (Session["SubRole"] == null)
{
if (Session["user_role"].ToString().ToLower() == "superuser")
{
}
else
{
Session["x2"] = Session["user_role"].ToString();
}
}
}
//open a connection with the DB for making queries
private void EstablishConnection()
{
this.dbconnectionHandle = new DBConnectionHandler(this.serverName, this.port, this.userName, this.dbName);
this.dbconnectionHandle.Connect();
}
public UserSelectionUI(DBConnectionHandler handle)
{
this.dbhandler = handle;
}
public void Connectionsetter()
{
DBConnectionHandler.SetConnectionString("Server = mssql.fhict.local; Database = dbi434548; User Id = dbi434548; Password = MijnFontysServer2020");
}
