public string CreateAdmin(AdminRegistration adminData)
{
MySqlConnection connection = _context.GetConnection();
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = "insert into adminregistration (aname,aemail,adob,amobile) VALUES (@aname, @aemail, @adob, @amobile)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aname", adminData.AdminName);
cmd.Parameters.AddWithValue("@aemail", adminData.AdminEmail);
cmd.Parameters.AddWithValue("@adob", adminData.AdminDob);
cmd.Parameters.AddWithValue("@amobile", adminData.AdminMobile);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return("Created");
}
public ActionResult Registration(AdminRegistration adminRegist)
{
TryValidateModel(adminRegist);
if (ModelState.IsValid)
{
Admin newadmin = new Admin
{
//adminid = id,
fname = adminRegist.First_Name,
lname = adminRegist.Last_Name,
email = adminRegist.Email,
contact = adminRegist.Contact,
password = adminRegist.Password
};
bool status = BussinessManager.adminregister(newadmin);
if (status)
{
return(this.RedirectToAction("Login", "Admin"));
}
}
return(View());
}
public static bool Insert(AdminRegistration adminReg)
{
bool status = false;
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string qyery = "Insert into AdminRegistration(AdminId,AdminEmail,AdminPassword,AdminName,AdminContact)" +
"Values(@AdminId,@AdminEmail,@AdminPassword,@AdminName,@AdminContact)";
SqlCommand cmd = new SqlCommand(qyery, con);
cmd.Parameters.Add(new SqlParameter("@AdminId", adminReg.AdminId));
cmd.Parameters.Add(new SqlParameter("@AdminEmail", adminReg.AdminEmail));
cmd.Parameters.Add(new SqlParameter("@AdminPassword", adminReg.AdminPassword));
cmd.Parameters.Add(new SqlParameter("@AdminName", adminReg.AdminName));
cmd.Parameters.Add(new SqlParameter("@AdminContact", adminReg.AdminContact));
cmd.ExecuteNonQuery();
if (con.State == ConnectionState.Open)
{
con.Close();
}
status = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(status);
}
public IActionResult RegisterAdmin(AdminRegistration admin)
{
try
{
if (this.adminBL.RegisterAdmin(admin))
{
return(this.Ok(new { success = true, Message = "Admin record added successfully" }));
}
else
{
return(StatusCode(StatusCodes.Status500InternalServerError,
new { success = false, Message = "Admin record is not added " }));
}
}
catch (Exception exception)
{
if (exception != null)
{
return(StatusCode(StatusCodes.Status409Conflict,
new { success = false, ErrorMessage = "Cannot insert duplicate Email values." }));
}
else
{
return(this.BadRequest(new { success = false, Message = exception.Message }));
}
}
}
public async Task <ActionResult> RegisterAdmin(AdminRegistration model)
{
string email = User.Identity.Name;
string type = null;
string Type1 = null;
UETCSEDbEntities dbo = new UETCSEDbEntities();
foreach (AddAdmin reg in dbo.AddAdmins)
{
if (reg.Email == email)
{
type = reg.Type;
Type1 = reg.Type1;
break;
}
}
if (type == null && Type1 == null)
{
return(RedirectToAction("Login", "Account"));
}
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user /*, model.Password*/);
if (result.Succeeded)
{
//await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false);
UETCSEDbEntities db = new UETCSEDbEntities();
var AdminName = model.AdminName;
var Email = model.Email;
var Type = "Admin";
AddAdmin ad = new AddAdmin();
ad.Email = Email;
ad.Name = AdminName;
ad.Type = Type;
db.AddAdmins.Add(ad);
db.SaveChanges();
SendMailToUser(model.Email);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
//var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
//await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
return(RedirectToLocal("~/Admin/SuperAdmin"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public bool RegisterAdmin(AdminRegistration register)
{
try
{
return(this.adminRL.RegisterAdmin(register));
}
catch (Exception e)
{
throw e;
}
}
public bool AdminRegister(AdminRegistration registration)
{
try
{
return(this.adminRL.AdminRegister(registration));
}
catch (Exception e)
{
throw e;
}
}
public ActionResult LogIn(AdminRegistration admin)
{
if (db.registrations.Any(x => x.UserName == admin.UserName && x.password == admin.password))
{
Session["UserName"] = admin.UserName;
return(RedirectToAction("index", "DashBoard"));
}
else
{
ModelState.AddModelError("", "UserName or Password invalid.");
return(PartialView());
}
}
public ActionResult Registration(AdminRegistration admin)
{
if (ModelState.IsValid)
{
db.registrations.Add(admin);
db.SaveChanges();
return(RedirectToAction("index", "DashBoard"));
}
else
{
ModelState.AddModelError("", "UserName or Password invalid.");
return(View());
}
}
public static List <AdminRegistration> GetAll()
{
List <AdminRegistration> adminReg = new List <AdminRegistration>();
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "SELECT * FROM AdminRegistration";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
AdminRegistration adminData = new AdminRegistration()
{
AdminId = int.Parse(reader["AdminId"].ToString()),
AdminEmail = reader["AdminEmail"].ToString(),
AdminPassword = reader["AdminPassword"].ToString(),
AdminName = reader["AdminName"].ToString(),
AdminContact = float.Parse(reader["AdminContact"].ToString()),
};
adminReg.Add(adminData);
}
reader.Close();
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(adminReg);
}
public AdminRegistration AdminLogin(AdminLogin login)
{
AdminRegistration adminRegistration = new AdminRegistration();
try
{
using (this.sqlconnection)
{
var password = Encryptdata(login.Password);
SqlCommand command = new SqlCommand("spAdminLogin", sqlconnection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Email", login.Email);
command.Parameters.AddWithValue("@Password", password);
this.sqlconnection.Open();
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
adminRegistration.AdminId = sqlDataReader.GetInt32(0);
adminRegistration.FullName = sqlDataReader.GetString(1);
adminRegistration.Phone = sqlDataReader.GetString(2);
adminRegistration.Email = sqlDataReader.GetString(3);
adminRegistration.Password = sqlDataReader.GetString(4);
}
}
}
return(adminRegistration);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
finally
{
this.sqlconnection.Close();
}
}
public ActionResult Registration(AdminRegistration admin)
{
if (ModelState.IsValid)
{
var user = AgroExpressDBAccess.IsUserExist(admin.UserName);
if (user != null)
{
ModelState.AddModelError("UserName", "User name already exist");
return(View(admin));
}
if (AgroExpressDBAccess.AddAdmin(admin))
{
ViewBag.success = "Registration Successsfull";
ModelState.Clear();
AdminRegistration registration = new AdminRegistration();
return(View(registration));
}
}
return(View(admin));
}
public bool RegisterAdmin(AdminRegistration register)
{
try
{
using (this.sqlconnection)
{
var password = Encryptdata(register.Password);
SqlCommand sqlCommand = new SqlCommand("spAddAdmin", this.sqlconnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@FullName", register.FullName);
sqlCommand.Parameters.AddWithValue("@Phone", register.Phone);
sqlCommand.Parameters.AddWithValue("@Email", register.Email);
sqlCommand.Parameters.AddWithValue("@Password", password);
this.sqlconnection.Open();
var result = sqlCommand.ExecuteNonQuery();
if (result != 0)
{
return(true);
}
return(false);
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
finally
{
this.sqlconnection.Close();
}
}
public static bool Update(AdminRegistration adminReg)
{
bool status = false;
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "UPDATE AdminRegistration SET AdminEmail=@AdminEmail, " +
"AdminPassword=@AdminPassword, AdminName=@AdminName, AdminContact=@AdminContact" +
"WHERE AdminId=@AdminId";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(new SqlParameter("@AdminId", adminReg.AdminId));
cmd.Parameters.Add(new SqlParameter("@AdminEmail", adminReg.AdminEmail));
cmd.Parameters.Add(new SqlParameter("@AdminPassword", adminReg.AdminPassword));
cmd.Parameters.Add(new SqlParameter("@AdminName", adminReg.AdminName));
cmd.Parameters.Add(new SqlParameter("@AdminContact", adminReg.AdminContact));
cmd.ExecuteNonQuery();
if (con.State == ConnectionState.Open)
{
con.Close();
}
status = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(status);
}
public List <AdminRegistration> GetAll()
{
string query = "select * from AdminRegistration ;";
List <AdminRegistration> datalist = new List <AdminRegistration>();
try
{
if (db.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, db.connection);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
AdminRegistration data = new AdminRegistration()
{
AdminId = int.Parse(reader["AdminId"].ToString()),
AdminEmail = reader["AdminEmail"].ToString(),
AdminPassword = reader["AdminPassword"].ToString(),
AdminName = reader["AdminName"].ToString(),
AdminContact = float.Parse(reader["AdminContact"].ToString())
};
datalist.Add(data);
}
reader.Close();
}
}
db.connection.Close();
}
}
catch (Exception ex) { throw ex; }
return(datalist);
}
public bool AdminRegister(AdminRegistration registration)
{
try
{
using (this.connection)
{
var password = Encryptdata(registration.Password);
SqlCommand command = new SqlCommand("spAdminRegister", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@FullName", registration.FullName);
command.Parameters.AddWithValue("@Email", registration.Email);
command.Parameters.AddWithValue("@Password", password);
command.Parameters.AddWithValue("@MobileNumber", registration.MobileNumber);
command.Parameters.AddWithValue("@Role", "Admin");
this.connection.Open();
var result = command.ExecuteNonQuery();
var result1 = command.ExecuteNonQueryAsync();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
this.connection.Close();
}
}
public string CreateAdmin(AdminRegistration adminData)
{
return(_adminContext.CreateAdmin(adminData));
}
