public bool sendemailtocompleteResigtration(UserBLL user, string body)
{
bool status = false;
try
{
MailMessage mail = new MailMessage();
LumexDBPlayer db = LumexDBPlayer.Start();
UserDAL userdal = new UserDAL();
DataTable dt = userdal.UpdateUserVarificationCode(user, db);
db.Stop();
if (dt.Rows.Count > 0)
{
UserMail = user.Email;
MailBody = body;
// MailBody = "Dear " + dt.Rows[0][0].ToString() + "\n To complete Your Resigtration Process \r\n\r\n\r\"Please Click the Link :" + user.ActivationUrl + "\r\n\r\n Your Login Name is : " + user.UserId + "\r\n\r\n If any problem feel free to contact site Admin. \r\n";
}
// SmtpClient SmtpServer = new SmtpClient("mail.lovetelsolution.com");
SmtpClient SmtpServer = new SmtpClient(SystemBLL.MailServer);
mail.From = new MailAddress(SystemBLL.MailAddess);
mail.IsBodyHtml = true;
mail.To.Add(UserMail);
mail.Subject = "Resigtration Conformation";
mail.Body = MailBody;
SmtpServer.Port = SystemBLL.Port;
SmtpServer.Credentials = new System.Net.NetworkCredential(SystemBLL.MailAddess, SystemBLL.MailPass);
//SmtpServer.EnableSsl = SystemBLL.Enablessl;
ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return true; };
SmtpServer.Send(mail);
status = true;
}
catch (Exception)
{
throw;
}
return status;
}
public bool SendEmailForPasswordReset(UserBLL userBll)
{
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
UserDAL userDAL = new UserDAL();
userDAL.UpdateUserVarificationCode(userBll, db);
db.Stop();
UserMail = userBll.Email;
MailSubject = "Password Reset Request";
MailBody = "Dear " + userBll.UserName + "\nTo Reset Your Access password \r\n\r\n\r\"Please Click the Link :" + userBll.ActivationUrl + "\r\n\r\n Your varification code is : " + userBll.varifycode + "\r\n\r\n If any problem feel free to contact site Admin \r\n";
status = sendemailToConfirm();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable SaveUser()
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt = user.SaveUser(this, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public void InsertIntoGenolgyTree(string placeId, string position, string referId, string UserId)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
user.InsertIntoGenolgyTree(placeId,position,referId,UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public DataTable getUserPasswordsetValidity()
{
UserDAL userDal = new UserDAL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = userDal.getUserPasswordsetValidity(db, this);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
userDal = null;
}
return dt;
}
public DataTable GetUserListByBruchId(string BranchId)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = user.GetUserListByBruchId(BranchId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public bool ValidateUser()
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
Boolean isValid = UserDAL.ValidateUser(this, db);
db.Stop();
return isValid;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public bool UpdateUserInfo(UserBLL aUser)
{
bool status = false;
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
status = user.UpdateUserInfo(aUser, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return status;
}
public DataTable GetDeletedUserListByDateRangeAll(string fromDate, string toDate, string search)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = user.GetDeletedUserListByDateRangeAll(fromDate, toDate, search, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public DataTable GetActiveUserList()
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = user.GetActiveUserList(db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public void DeleteUser(string userId)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
user.DeleteUser(userId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public DataTable checkuserPinchangevalidity(string UserId)
{
UserDAL userDal = new UserDAL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = userDal.checkuserPinchangevalidity(UserId,db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
userDal = null;
}
return dt;
}
public bool CheckUserIdOrMailForResetPass(string UserId)
{
UserDAL user = new UserDAL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = user.CheckUserIdOrMailForResetPass(UserId, db);
db.Stop();
if (dt.Rows.Count > 0)
{
UserId = dt.Rows[0]["UserId"].ToString();
Email = dt.Rows[0]["Email"].ToString();
UserName = dt.Rows[0]["UserName"].ToString();
status = true;
}
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return status;
}
public bool checkPlacementIdValidity(string UserId,string Position)
{
UserDAL user = new UserDAL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt= user.checkPlacementIdValidity(UserId, Position, db);
if (dt.Rows.Count > 0)
{
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return status;
}
public bool CheckDuplicateUser(string emailId)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
bool status = user.CheckDuplicateUser(emailId, db);
db.Stop();
return status;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public bool SaveUserInfo()
{
UserDAL aUserDal=new UserDAL();
bool status = false;
DataTable dt=new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUserDal.SaveUserInfo(this,db);
db.Stop();
if (dt.Rows.Count > 0)
{
status = true;
UserId = dt.Rows[0][0].ToString();
}
}
catch (Exception)
{
throw;
}
finally
{
dt.Clear();
}
return status;
}
public void UpdateUserActivation(string userId, string activationStatus)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
user.UpdateUserActivation(userId, activationStatus, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public DataTable GetUserByGroupId( UserBLL aUser)
{
DataTable dt = new DataTable();
UserDAL aUserDal = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUserDal.GetUserByGroupId(db,aUser);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
}
public bool UpdateUserPin(string userId, string pin)
{
UserDAL user = new UserDAL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
user.UpdateUserPin(userId, pin, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return status;
}
public DataTable GetUserInfoByIdForView(string userId)
{
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = user.GetUserInfoByIdforView(userId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
public bool varifypin(string userid, string UserPin)
{
bool status = false;
UserDAL user = new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
status = user.varifypin(userid,UserPin, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return status;
}
public DataTable GetUserInfoList()
{
DataTable dt=new DataTable();
UserDAL aUserDal=new UserDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUserDal.GetUserInfoList(db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
}
