public async Task <IActionResult> OnPostAsync(string savemore)
{
try
{
var princetonhive = new attendanceContext();
var passwordupdate = princetonhive.Login.Where(x => x.Username == (HttpContext.Session.GetString("Username"))).SingleOrDefault();
if (passwordupdate.Password == Encrypt(currentpassword))
{
passwordupdate.Password = Encrypt(newpassword);
princetonhive.SaveChanges();
await Response.WriteAsync("<script language='javascript'>window.alert('Password updated Successfully');window.location='logout';</script>");
}
else
{
await Response.WriteAsync("<script language='javascript'>window.alert('Current password not match.. ');window.location='changepassword';</script>");
}
}
catch (Exception ex)
{
await Response.WriteAsync("<script language='javascript'>window.alert('Something Went Wrong.');window.location='changepassword';</script>");
throw ex;
}
return(Page());
}
public loginModel(IConfiguration config, attendanceContext context)
{
_configuration = config;
_client = new HttpClient();
_client.BaseAddress = new Uri(_configuration["base_Url"]);
_client.DefaultRequestHeaders.Accept.Clear();
_client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
_context = context;
}
public monthlyreportModel(IConfiguration config, IHostingEnvironment hostingEnvironment, attendanceContext context)
{
_hostingEnvironment = hostingEnvironment;
_configuration = config;
_client = new HttpClient();
_client.BaseAddress = new Uri(_configuration["base_Url"]);
_client.DefaultRequestHeaders.Accept.Clear();
_client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
_connection = _configuration["ConnectionStrings:Princetonhive"];
_context = context;
}
//public void GetUser_IP()
//{
// string ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
// if (string.IsNullOrEmpty(ipAddress))
// {
// ipAddress = Request.ServerVariables["REMOTE_ADDR"];
// }
//}
public async Task <IActionResult> OnPostAsync(string savemore)
{
try
{
var princetonhive = new attendanceContext();
using (NpgsqlConnection connection = new NpgsqlConnection())
{
connection.ConnectionString = "Server=103.118.157.29;Port=5432;Database=attendance;User Id=postgres;Password=princetonhive@123;";
if (savemore == "Save")
{
connection.Open();
string sql = "select count(*) as id from employee where timein IS NOT NULL and SUBSTRING(date,1,5)=SUBSTRING('" + indianTime.ToString("dd-MM-yyyy") + "',1,5) and employeeid='" + HttpContext.Session.GetString("Username") + "' and timein IS NOT null";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
NpgsqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
count = Convert.ToString(dr["id"].ToString());
}
dr.Close();
if (count == "0")
{
var studentd = new Employee()
{
Employeeid = HttpContext.Session.GetString("Username"),
Timein = timein,
Date = indianTime.ToString("dd-MM-yyyy HH:mm")
};
princetonhive.Employee.Add(studentd);
princetonhive.SaveChanges();
await Response.WriteAsync("<script language='javascript'>window.alert('Data Saved Successfully');window.location='attendance';</script>");
}
else
{
await Response.WriteAsync("<script language='javascript'>window.alert('Attendance already exist');window.location='attendance';</script>");
}
connection.Close();
}
else
{
connection.Open();
string sql = "select count(*) as id from employee where SUBSTRING(date,1,5)=SUBSTRING('" + indianTime.ToString("dd-MM-yyyy") + "',1,5) and employeeid='" + HttpContext.Session.GetString("Username") + "' and timeout IS NOT null";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
NpgsqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
count = Convert.ToString(dr["id"].ToString());
}
dr.Close();
if (count == "0")
{
string sql2 = "select id from employee where SUBSTRING(date,1,5)=SUBSTRING('" + indianTime.ToString("dd-MM-yyyy") + "',1,5) and employeeid='" + HttpContext.Session.GetString("Username") + "'";
NpgsqlCommand cmd2 = new NpgsqlCommand(sql2, connection);
NpgsqlDataReader dr2;
dr2 = cmd2.ExecuteReader();
while (dr.Read())
{
EId = Convert.ToString(dr2["id"].ToString());
}
dr.Close();
if (EId != null)
{
var timeoutupdate = princetonhive.Employee.Where(x => x.Id == Convert.ToInt32(EId)).SingleOrDefault();
if (timeoutupdate != null)
{
timeoutupdate.Timeout = timeout;
timeoutupdate.Dateout = indianTime.ToString("dd-MM-yyyy HH:mm");
princetonhive.SaveChanges();
await Response.WriteAsync("<script language='javascript'>window.alert('Data Saved Successfully');window.location='attendance';</script>");
}
else
{
await Response.WriteAsync("<script language='javascript'>window.alert('Something went wrong');window.location='attendance';</script>");
}
}
}
else
{
await Response.WriteAsync("<script language='javascript'>window.alert('Attendance already exist');window.location='attendance';</script>");
}
}
}
}
catch (Exception ex)
{
await Response.WriteAsync("<script language='javascript'>window.alert('Something Went Wrong.');window.location='attendance';</script>");
throw ex;
}
return(Page());
}