private string UserInsert(string firstname, string Lastname, string username, string password, string countername, string groupname, string subdivisioncode, string accountno, string phoneno, string emailid, string IPAddress)
{
users_Prop userprop = new users_Prop();
userprop.FirstName = firstname;
userprop.LastName = Lastname;
userprop.UserName = username;
userprop.Password = Common.EncryptText(password);
userprop.CounterID = Convert.ToInt16(countername);
userprop.GroupID = Convert.ToInt16(groupname);
userprop.SubdivisionCode = subdivisioncode;
userprop.AccountNo = accountno;
userprop.PhoneNo = phoneno;
userprop.EmailID = emailid;
userprop.IPAddress = IPAddress;
users_bal userbal = new users_bal();
string strMsg = userbal.UserInsert(userprop);
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
return(userbal.ErrMessage);
}
else
{
return(strMsg);
}
}
public void TimeOut(string a_strUserName)
{
try
{
users_Prop userprop = new users_Prop();
userprop.UserName = a_strUserName;
users_bal userbal = new users_bal();
userbal.LogOut(userprop);
}
catch (Exception ex)
{
throw ex;
}
}
private string UserBlock(string username)
{
users_Prop userprop = new users_Prop();
userprop.UserName = username;
users_bal userbal = new users_bal();
string strMsg = userbal.UserBlock(userprop);
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
return(userbal.ErrMessage);
}
else
{
return(strMsg);
}
}
private string UserEdit(string username)
{
users_Prop userprop = new users_Prop();
userprop.UserName = username;
users_bal userbal = new users_bal();
DataTable dt = userbal.UserSelect(userprop);
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
return(userbal.ErrMessage);
}
else
{
return(dt.Rows[0]["username"].ToString() + "#" + dt.Rows[0]["firstname"].ToString() + "#" + dt.Rows[0]["lastname"].ToString() + "#" + dt.Rows[0]["counterid"].ToString() + "#" + dt.Rows[0]["groupid"].ToString());
}
}
private string UserUpdatePwd(string username, string password)
{
users_Prop userprop = new users_Prop();
userprop.UserName = username;
userprop.Password = Common.EncryptText(password);
users_bal userbal = new users_bal();
string strMsg = userbal.UserUpdatePassword(userprop);
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
return(userbal.ErrMessage);
}
else
{
return(strMsg);
}
}
private string CheckLogin(string username, string Password, string IPAddress)
{
users_Prop userprop = new users_Prop();
userprop.UserName = username;
userprop.Password = Common.EncryptText(Password);
userprop.IPAddress = IPAddress;
users_bal userbal = new users_bal();
string strmsg = userbal.UserCheckLogin(userprop);
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
return(userbal.ErrMessage);
}
else
{
return(strmsg);
}
}
private string UserSearch(string username, string groupname, string countername)
{
users_Prop userprop = new users_Prop();
userprop.UserName = username;
userprop.GroupName = groupname;
userprop.CounterName = countername;
users_bal userbal = new users_bal();
DataTable dt = userbal.UserSearch(userprop);
StringBuilder sb = new StringBuilder();
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
sb.Append("<tr><td >" + userbal.ErrMessage + "</td><td></td><td></td><td></td><td></td></tr>");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td >No Record Found</td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["username"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["firstname"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["countername"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["groupname"].ToString() + "</td>");
sb.Append("<td ><img src='images/user_block.png' alt='block' onclick=BlockUser('");
sb.Append(dt.Rows[i]["Username"].ToString());
sb.Append("') /><img src='images/resetpwd.png' alt='reset' onclick=ResetPassword('" + dt.Rows[i]["Username"].ToString() + "') /><img src='images/editrec.png' alt='edit' onclick=EditRecord('" + dt.Rows[i]["username"].ToString() + "') ></td>");
sb.Append("</tr>");
}
}
}
return(sb.ToString());
}
private string UserUpdate(string firstname, string Lastname, string username, string countername, string groupname)
{
users_Prop userprop = new users_Prop();
userprop.FirstName = firstname;
userprop.LastName = Lastname;
userprop.UserName = username;
userprop.CounterID = Convert.ToInt16(countername);
userprop.GroupID = Convert.ToInt16(groupname);
users_bal userbal = new users_bal();
string strMsg = userbal.UserUpdate(userprop);
if (userbal.ErrMessage != "" && userbal.ErrMessage != null)
{
return(userbal.ErrMessage);
}
else
{
return(strMsg);
}
}
