public async Task <ActionResult> ChangePassword(PasswordChange std)
{
await Task.Delay(0);
Response res = new Response();
var Id = EncryptionDecryption.Decrypt(std.id);
DataTable table = SQLDatabase.GetDataTable("SELECT * FROM users WHERE Id='" + Id + "' AND Password='******'");
if (table.Rows.Count > 0)
{
if (SQLDatabase.ExecNonQuery("update users set Password='******' where Id='" + Id + "'") > 0)
{
res.Status = "Password Update Successfully";
}
else
{
res.Status = "Password Updation Failed";
}
}
else
{
res.Status = "Old Password is Incorrect";
}
return(Ok(res));
}
public async Task <ActionResult> DeleteUser(Students std)
{
await Task.Delay(0);
Response res = new Response();
var Deactivebyid = std.Deactivebyid;
if (Deactivebyid == "" || Deactivebyid == null)
{
Deactivebyid = std.Deactivebyid;
}
else
{
Deactivebyid = EncryptionDecryption.Decrypt(std.Deactivebyid);
}
res.id = std.Id;
if (SQLDatabase.ExecNonQuery("update users set Status=0, DeactiveDateTime='" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "', Deactivebyid='" + Deactivebyid + "' where Id=" + std.Id) > 0)
{
res.Status = "Delete Successfully";
}
else
{
res.Status = "Deletion Failed";
}
return(Ok(res));
}
public async Task <ActionResult> UserProfile(Students std)
{
await Task.Delay(0);
Response res = new Response();
var Id = EncryptionDecryption.Decrypt(std.str1);
DataTable table = SQLDatabase.GetDataTable("select Name,FatherName,Email,PhoneNumber,Gender,Address,Username from users where Id=" + Id + "");
return(Ok(table));
}
public async Task <ActionResult> InsertData(Students std)
{
await Task.Delay(0);
Response res = new Response();
DataTable table = SQLDatabase.GetDataTable("select* from users where Email='" + std.Email + "'");
if (table.Rows.Count > 0)
{
res.Status = "Email Matched";
}
else
{
DataTable table1 = SQLDatabase.GetDataTable("select* from users where Username='******'");
if (table1.Rows.Count > 0)
{
res.Status = "Username Matched";
}
else
{
var UserImage = "/assets/img/faces/card-profile1-square.jpg";
var Insertedbyid = std.Insertedbyid;
if (Insertedbyid == "" || Insertedbyid == null)
{
Insertedbyid = std.Insertedbyid;
}
else
{
Insertedbyid = EncryptionDecryption.Decrypt(std.Insertedbyid);
}
if (SQLDatabase.ExecNonQuery("insert into users (Name,FatherName,PhoneNumber,Email,Gender,Address,Username,Password,Image,Status,InsertedDateTime,Insertedbyid) values ('" + std.Name + "','" + std.FatherName + "','" + std.PhoneNumber + "','" + std.Email + "','" + std.Gender + "','" + std.Address + "','" + std.Username + "','" + EncryptionDecryption.Encrypt(std.Password) + "','" + UserImage + "',1,'" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','" + Insertedbyid + "')") > 0)
{
res.Status = "Inserted Successfully";
}
else
{
res.Status = "Insertion failed";
}
}
}
return(Ok(res));
}
public async Task <ActionResult> UpdateUser(Students std)
{
await Task.Delay(0);
Response res = new Response();
if (SQLDatabase.ExecNonQuery("update users set Name='" + std.Name + "',FatherName='" + std.FatherName + "',PhoneNumber='" + std.PhoneNumber + "',Email='" + std.Email + "',Gender='" + std.Gender + "',Address='" + std.Address + "' where Id=" + std.Id) > 0)
{
res.Status = "Updated Successfully";
}
else
{
res.Status = "Updation Failed";
}
return(Ok(res));
}
public async Task <ActionResult> Login(Students std)
{
await Task.Delay(0);
Response res = new Response();
DataTable table = SQLDatabase.GetDataTable("SELECT * FROM users where Username='******' and Password='******' and Status='1'");
if (table.Rows.Count > 0)
{
res.Status = "Successfully Login";
string Id = table.Rows[0]["Id"].ToString();
res.str1 = EncryptionDecryption.Encrypt(Id);
}
else
{
res.Status = "Invalid UserName/Password";
}
return(Ok(res));
}