public Int32 UpdateStatus(int intEmpIdno, bool Status, Int32 empIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserMast objUsrs = (from mast in db.tblUserMasts
where mast.User_Idno == intEmpIdno
select mast).FirstOrDefault();
if (objUsrs != null)
{
objUsrs.Status = Status;
objUsrs.Emp_Idno = empIdno;
objUsrs.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch
{
}
return(value);
}
/// <summary>
/// To check record existence in login
/// </summary>
/// <param name="strUserName"></param>
/// <returns></returns>
public bool IsExists(string strLoginName, string strEmail, Int64 EmpIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserMast objtblUser = new tblUserMast();
if (EmpIdno <= 0)
{
objtblUser = (from mast in db.tblUserMasts
where mast.Emp_Name == strLoginName && mast.User_EmailId == strEmail
select mast).FirstOrDefault();
}
if (EmpIdno > 0)
{
objtblUser = (from mast in db.tblUserMasts
where mast.Emp_Name == strLoginName && mast.User_EmailId == strEmail && mast.User_Idno != EmpIdno
select mast).FirstOrDefault();
}
if (objtblUser != null && objtblUser.User_Idno > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Delete record from USER
/// </summary>
/// <param name="intEmpIdno"></param>
/// /// <param name="intCompIdno"></param>
/// <returns></returns>
public int Delete(Int64 intEmpIdno, Int32 intCompIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserMast objUseres = (from mast in db.tblUserMasts
where mast.User_Idno == intEmpIdno
select mast).FirstOrDefault();
if (objUseres != null)
{
db.tblUserMasts.DeleteObject(objUseres);
db.SaveChanges();
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
/// <summary>
/// Insert records in USER
/// </summary>
/// <returns></returns>
/// <summary>
/// Insert records in USER
/// </summary>
/// <returns></returns>
public Int64 Insert(string strName, string strFName, DateTime?dtDOB, DateTime?dtDOJ, DateTime?dtDOR, string strPhone, string strMobile, string strEmail, string strloginname,
string strPassword, string strAddress, Int64 intCityIdno, Int64 intStateIdno, Int64 intDesigIdno, string strPinCode,
string strPhoto, string strRemarks, bool bStatus, Int32 intYearIdno, Int32 intCompIdno, string Gndr, bool IntComputer, Int32 empIdno, Int32 LoginCompIdno)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserMast objUsers = new tblUserMast();
if (IsExists(strName, strEmail, 0) == true)
{
intValue = -1;
}
else
{
objUsers.Emp_Name = strName;
objUsers.User_FName = strFName;
objUsers.DOB = dtDOB;
objUsers.DOJ = dtDOJ;
objUsers.DOL = dtDOR;
objUsers.Emp_Idno = empIdno;
objUsers.Phone_No = strPhone;
objUsers.Mobile_No = strMobile;
objUsers.User_EmailId = strEmail;
objUsers.User_Name = strloginname;
objUsers.User_Password = strPassword;
objUsers.Address = strAddress;
objUsers.City_Idno = intCityIdno;
objUsers.State_Idno = intStateIdno;
objUsers.Desig_Idno = intDesigIdno;
objUsers.Class = "Staff";
objUsers.Pin_No = strPinCode;
objUsers.PHOTO = strPhoto;
objUsers.REMARKS = strRemarks;
objUsers.Status = bStatus;
objUsers.Comp_Idno = intCompIdno;
objUsers.Gender = Gndr;
objUsers.Computer_User = IntComputer;
objUsers.Date_Added = System.DateTime.Now;
objUsers.Date_Modified = System.DateTime.Now;
objUsers.LoginComp_Idno = LoginCompIdno;
db.tblUserMasts.AddObject(objUsers);
db.SaveChanges();
intValue = objUsers.User_Idno;
}
}
}
catch
{
intValue = 0;
}
return(intValue);
}
private void Populate(int userid)
{
EditProfileDal EditDAL = new EditProfileDal();
tblUserMast userMast = EditDAL.Select(userid);
string gender = "";
if (userMast != null)
{
txtAddress.Text = userMast.Address;
ddlState.SelectedValue = userMast.State_Idno.ToString();
ddlState_SelectedIndexChanged(null, null);
ddlCity.SelectedValue = userMast.City_Idno.ToString();
gender = userMast.Gender;
ddlGender.SelectedValue = gender;
//if (gender == "M")
//{
// rdbmale.Checked = true;
//}
//else
//{
// rdbfemale.Checked = true;
//}
if (Convert.ToString(userMast.DOB) != "")
{
txtDOB.Text = Convert.ToString(Convert.ToDateTime(userMast.DOB).ToString("dd-MM-yyyy"));
}
else
{
txtDOB.Text = "";
}
if (Convert.ToString(userMast.DOJ) != "")
{
txtDOJ.Text = Convert.ToString(Convert.ToDateTime(userMast.DOJ).ToString("dd-MM-yyyy"));
}
else
{
txtDOJ.Text = "";
}
var lst1 = EditDAL.SelectFromCity(userid);
var lst2 = EditDAL.SelectFromCityIdno(userid);
if (lst1.Count > 0)
{
chklistFromcity.DataSource = null;
chklistFromcity.DataSource = lst1;
chklistFromcity.DataTextField = "city_name";
chklistFromcity.DataValueField = "City_Idno";
chklistFromcity.DataBind();
if (lst2.Count > 0)
{
for (int i = 0; i < chklistFromcity.Items.Count; i++)
{
for (int j = 0; j < lst2.Count; j++)
{
if (Convert.ToInt64(chklistFromcity.Items[i].Value) == lst2[j].FrmCity_Idno)
{
chklistFromcity.Items[i].Selected = true;
}
}
}
}
}
txtEmail.Text = userMast.User_EmailId;
txtEmail.Enabled = false;
txtFatherName.Text = userMast.User_FName;
txtMobile.Text = userMast.Mobile_No;
txtPassword.Text = WebTransport.Classes.EncryptDecryptPass.decryptPassword(userMast.User_Password);
txtPassword.Attributes.Add("value", WebTransport.Classes.EncryptDecryptPass.decryptPassword(userMast.User_Password));
hidPass.Value = WebTransport.Classes.EncryptDecryptPass.decryptPassword(userMast.User_Password);
txtPhoneNo.Text = userMast.Phone_No;
txtUserName.Text = userMast.User_Name;
ddlDesig.SelectedValue = userMast.Desig_Idno.ToString();
ddlComputerUser.SelectedValue = userMast.Computer_User.ToString();
hid.Value = userMast.User_Idno.ToString();
}
EditDAL = null;
}
/// <summary>
/// Update records in USER
/// </summary>
/// <returns></returns>
public Int64 Update(Int64 intEmpIdno, string strName, string strFName, DateTime?dtDOB, DateTime?dtDOJ, DateTime?dtDOR, string strPhone, string strMobile, string strEmail,
string strloginname, string strPassword, string strAddress, Int64 intCityIdno, Int64 intStateIdno, Int64 intDesigIdno, string strPinCode,
string strPhoto, string strRemarks, bool bStatus, Int32 intCompIdno, string Gndr, bool bComputer, Int32 empIdno, Int32 LoginCompIdno)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserMast objUsers = (from mast in db.tblUserMasts
where mast.User_Idno == intEmpIdno && mast.Comp_Idno == intCompIdno
select mast).FirstOrDefault();
if (objUsers != null)
{
if (IsExists(strName, strEmail, intEmpIdno) == true)
{
intValue = -1;
}
else
{
objUsers.Emp_Name = strName;
objUsers.User_FName = strFName;
objUsers.DOB = dtDOB;
objUsers.DOJ = dtDOJ;
objUsers.DOL = dtDOR;
objUsers.Emp_Idno = empIdno;
objUsers.Phone_No = strPhone;
objUsers.Mobile_No = strMobile;
objUsers.User_EmailId = strEmail;
objUsers.User_Name = strloginname;
objUsers.User_Password = strPassword;
objUsers.Address = strAddress;
objUsers.City_Idno = intCityIdno;
objUsers.State_Idno = intStateIdno;
objUsers.Desig_Idno = intDesigIdno;
objUsers.Pin_No = strPinCode;
objUsers.Gender = Gndr;
objUsers.Computer_User = bComputer;
if (string.IsNullOrEmpty(strPhoto) == true)
{
objUsers.PHOTO = objUsers.PHOTO;
}
else
{
objUsers.PHOTO = strPhoto;
}
objUsers.REMARKS = strRemarks;
objUsers.Status = bStatus;
objUsers.Comp_Idno = intCompIdno;
objUsers.Date_Modified = System.DateTime.Now;
objUsers.LoginComp_Idno = LoginCompIdno;
intValue = objUsers.User_Idno;
db.SaveChanges();
}
}
}
}
catch
{
intValue = 0;
}
return(intValue);
}
