public static int AddNewAdminLogin(mAdminLogin pAdminLogin)
{
int isSucess = 0;
using (SqlConnection con = new SqlConnection(Global.connString))
{
con.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO tblAdminLogin ( AdminLoginName, AdminLoginEmail, AdminLoginPassword ,AdminPicture, IsEmailVerified, LastLoginDateTime, IsActive, AdminSignupDate) " +
" VALUES (@AdminLoginName ,@AdminLoginEmail, @AdminLoginPassword, @AdminPicture, @IsEmailVerified, @LastLoginDateTime, @IsActive, @AdminSignupDate) SELECT SCOPE_IDENTITY() ", con))
{
command.Parameters.AddWithValue("@AdminLoginName", pAdminLogin.AdminLoginName);
command.Parameters.AddWithValue("@AdminLoginEmail", pAdminLogin.AdminLoginEmail);
command.Parameters.AddWithValue("@AdminLoginPassword", pAdminLogin.AdminLoginPassword);
command.Parameters.AddWithValue("@AdminPicture", pAdminLogin.AdminPicture);
command.Parameters.AddWithValue("@IsEmailVerified", pAdminLogin.IsEmailVerified);
command.Parameters.AddWithValue("@LastLoginDateTime", DateTime.Now);
command.Parameters.AddWithValue("@IsActive", pAdminLogin.IsActive);
command.Parameters.AddWithValue("@AdminSignupDate", DateTime.Now);
isSucess = Convert.ToInt32(command.ExecuteScalar());
}
}
return(isSucess);
}
public static int UpdateAdminLogin(mAdminLogin pAdminLogin)
{
int isSucess = 0;
using (SqlConnection con = new SqlConnection(Global.connString))
{
con.Open();
using (SqlCommand command = new SqlCommand("UPDATE tblAdminLogin SET [AdminLoginName] = @AdminLoginEmail, [AdminLoginEmail] = @AdminLoginName, [AdminLoginPassword] = @AdminLoginPassword, [AdminPicture]= @AdminPicture, [IsEmailVerified]= @IsEmailVerified, [LastLoginDateTime] = @LastLoginDateTime, " +
"[IsActive] = @IsActive, [AdminSignupDate] = @AdminSignupDate WHERE AdminLoginID = @AdminLoginID ", con))
{
command.Parameters.AddWithValue("@AdminLoginID", pAdminLogin.AdminLoginID);
command.Parameters.AddWithValue("@AdminLoginName", pAdminLogin.AdminLoginName);
command.Parameters.AddWithValue("@AdminLoginEmail", pAdminLogin.AdminLoginEmail);
command.Parameters.AddWithValue("@AdminLoginPassword", pAdminLogin.AdminLoginPassword);
command.Parameters.AddWithValue("@AdminPicture", pAdminLogin.AdminPicture);
command.Parameters.AddWithValue("@IsEmailVerified", pAdminLogin.IsEmailVerified);
command.Parameters.AddWithValue("@LastLoginDateTime", DateTime.Now);
command.Parameters.AddWithValue("@IsActive", pAdminLogin.IsActive);
command.Parameters.AddWithValue("@AdminSignupDate", DateTime.Now);
isSucess = command.ExecuteNonQuery();
}
}
return(isSucess);
}
public static mAdminLogin VerifyAdminInformation(string pAdminLoginEmail, string pAdminLoginPassword)
{
mAdminLogin collectmAdmin = new mAdminLogin();
using (SqlConnection con = new SqlConnection(Global.connString))
{
con.Open();
using (SqlCommand command = new SqlCommand("select * from tblAdminLogin where AdminLoginEmail = @AdminLoginEmail and AdminLoginPassword = @AdminLoginPassword", con))
{
command.Parameters.AddWithValue("@AdminLoginEmail", pAdminLoginEmail);
command.Parameters.AddWithValue("@AdminLoginPassword", pAdminLoginPassword);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
collectmAdmin.AdminLoginID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("AdminLoginID")));
collectmAdmin.AdminIDEncrypted = UtilityClasses.ucEDOperations.EncryptString(Global.gEDKey, Convert.ToString(reader.GetValue(reader.GetOrdinal("AdminLoginID"))));
collectmAdmin.AdminLoginName = reader.GetValue(reader.GetOrdinal("AdminLoginName")).ToString();
if (reader.GetValue(reader.GetOrdinal("AdminLoginEmail")) == null)
{
collectmAdmin.AdminLoginEmail = null;
}
else
{
collectmAdmin.AdminLoginEmail = reader.GetValue(reader.GetOrdinal("AdminLoginEmail")).ToString();
}
//collectmBusinessUser.LastLogin = reader.GetDateTime(reader.GetOrdinal("LastLogin")); //reader.GetDateTime(16);
collectmAdmin.IsActive = reader.GetBoolean(reader.GetOrdinal("IsActive")); //reader.GetBoolean(17);
collectmAdmin.IsEmailVerified = reader.GetBoolean(reader.GetOrdinal("IsEmailVerified")); //reader.GetBoolean(17);
}
}
else
{
collectmAdmin = null;
}
}
}
}
return(collectmAdmin);
}
public static DataTable GetAdminListWithNoDuplicates(mAdminLogin pAdminLogin)
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(Global.connString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM tblAdminLogin WHERE AdminLoginEmail = @AdminLoginEmail", con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@AdminLoginEmail", pAdminLogin.AdminLoginEmail);
sda.Fill(dt);
}
}
}
return(dt);
}
