private UserDom GetUserDetailFromDataReader(IDataReader reader)
{
UserDom userdom = new UserDom();
userdom.UserId = GetIntegerFromDataReader(reader, "User_Id");
userdom.FirstName = GetStringFromDataReader(reader, "First_Name");
userdom.MiddleName = GetStringFromDataReader(reader, "Middle_Name");
userdom.LastName = GetStringFromDataReader(reader, "Last_Name");
userdom.LoginId = GetStringFromDataReader(reader, "Login_Id");
userdom.Password = GetStringFromDataReader(reader, "Password");
userdom.EmailId = GetStringFromDataReader(reader, "Email_Id");
userdom.PhoneNo = GetStringFromDataReader(reader, "Phone");
userdom.MobileNo = GetStringFromDataReader(reader, "Mobile");
userdom.DateOfBirth = GetDateFromReader(reader, "DOB");
userdom.MaritalStatus = GetStringFromDataReader(reader, "Marital_Status");
userdom.Gender = GetStringFromDataReader(reader, "Gender");
userdom.EmpCode = GetStringFromDataReader(reader, "EmpCode");
//userdom.UserTypeId = new MetaData();
userdom.UserTypeId = GetIntegerFromDataReader(reader, "UserTypeId");
userdom.UserLocation = new LocationMaster();
userdom.UserLocation.LocationId = GetIntegerFromDataReader(reader, "Location_Id");
//userdom.UserLocation.City = GetStringFromDataReader(reader, "Location_Name");
userdom.Address = GetStringFromDataReader(reader, "Address");
userdom.OfficeExtentionNo = GetStringFromDataReader(reader, "OfficeExtentionNo");
userdom.Created_By = GetStringFromDataReader(reader, "Created_By");
userdom.Created_Date = GetDateFromReader(reader, "Created_Date");
userdom.Modified_By = GetStringFromDataReader(reader, "Modified_By");
userdom.Modified_Date = GetDateFromReader(reader, "Modified_Date");
userdom.LastLoginDate = GetDateFromReader(reader, "LastLogin_Date");
return(userdom);
}
protected void gvDetails_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
UserDom user = new UserDom();
user = userBal.ReadUserByLoginId(basePage.LoggedInUser.LoginId);
LinkButton lnkEdit = (LinkButton)e.Row.FindControl("linbtn_edit");
LinkButton lnkDelete = (LinkButton)e.Row.FindControl("linbtn_delete");
for (int i = 0; i < user.UserTask.Count; i++)
{
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.Edit_Agent))))
{
if (lnkEdit != null)
{
lnkEdit.Visible = false;
}
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.Delete_Agent))))
{
if (lnkDelete != null)
{
lnkDelete.Visible = false;
}
}
}
}
}
protected void gridViewConsignment_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
UserDom user = new UserDom();
user = userBal.ReadUserByLoginId(basePage.LoggedInUser.LoginId);
LinkButton lnkEdit = (LinkButton)e.Row.FindControl("linbtn_edit");
LinkButton LinbtnViewConsign = (LinkButton)e.Row.FindControl("LinbtnViewConsign");
if (basePage.LoggedInUser.UserTypeId != Convert.ToInt32(UserType.Admin) && user.UserTask.Count > 0)
{
for (int i = 0; i < user.UserTask.Count; i++)
{
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.UpdateConsignmentStatus))))
{
if (lnkEdit != null)
{
lnkEdit.Visible = true;
}
}
else
{
lnkEdit.Visible = false;
}
}
}
}
}
private void SerchData(int UserId)
{
UserBAL userBal = new UserBAL();
UserDom user = new UserDom();
user = userBal.ReadUserById(UserId);
lblUserName.Text = user.FirstName + " " + user.MiddleName + " " + user.LastName;
hdfldUserId.Value = user.UserId.ToString();
List <UserTaskMaping> lst = new List <UserTaskMaping>();
lst = userBal.ReadUserTask(UserId);
BindCheckBoxList();
//foreach (ListItem item in chbxUserTask.Items)
//{
// item.Selected = false;
//}
foreach (ListItem item in chbxUserTask.Items)
{
foreach (UserTaskMaping pop in lst)
{
if (Convert.ToInt32(item.Value) == pop.MetadataUserTask.Id)
{
item.Selected = true;
}
}
}
}
public int UpdateUserMaster(UserDom userdom)
{
int userid = 0;
userid = userdal.UpdateUserMaster(userdom);
return(userid);
}
public UserDom ReadUserById(int userid)
{
UserDom userdom = new UserDom();
userdom = userdal.ReadUserById(userid);
return(userdom);
}
public int CreateUser(UserDom userdom)
{
int userid = 0;
userid = userdal.CreateUser(userdom);
return(userid);
}
protected void Visa_gridshow_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
UserDom user = new UserDom();
user = userBal.ReadUserByLoginId(basePage.LoggedInUser.LoginId);
LinkButton lnkDelete = (LinkButton)e.Row.FindControl("lnkButtonDelete");
lnkDelete.Visible = false;
if (basePage.LoggedInUser.UserTypeId == Convert.ToInt32(UserType.Admin))
{
lnkDelete.Visible = true;
}
else if (basePage.LoggedInUser.UserTypeId != Convert.ToInt32(UserType.Admin) && user.UserTask.Count > 0)
{
for (int i = 0; i < user.UserTask.Count; i++)
{
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.DeleteVisaForm))))
{
if (lnkDelete != null)
{
lnkDelete.Visible = true;
}
}
}
}
}
}
private UserDom ReadUserByLoginId(string loginId)
{
UserBAL userBal = new UserBAL();
UserDom user = userBal.ReadUserByLoginId(loginId);
return(user);
}
protected void btnSave_Click1(object sender, EventArgs e)
{
int out1 = 0;
UserDom user = new UserDom();
user.FirstName = txtFName.Text;
user.MiddleName = txtMiddleName.Text;
user.LastName = txtlname.Text;
user.Password = txtpassword.Text;
user.EmpCode = txtEmpCode.Text;
user.UserLocation = new LocationMaster();
user.UserLocation.LocationId = (Convert.ToInt32(ddllocation.SelectedItem.Value));
user.LoginId = txtLoginId.Text;
user.EmailId = txtemail.Text;
user.PhoneNo = txtphn.Text;
user.MobileNo = txtmobile.Text;
user.OfficeExtentionNo = txtofficeextno.Text;
user.Gender = rdbgender.SelectedItem.Text;
user.Address = txtaddress.Text;
user.UserTypeId = Convert.ToInt32(rbtnUserType.SelectedValue);
user.MaritalStatus = rdbMaritalstatus.SelectedItem.Text;
user.DateOfBirth = Convert.ToDateTime(txtdob.Text);
out1 = ob.CreateUser(user);
if (out1 > 0)
{
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "test", "alert('User created successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "test", "alert('EmpCode already exist')", true);
}
BindgvwUser();
CancelUserDetails();
}
public void SetControlsName(UserDom userdom)
{
//UserDom userdom = new UserDom();
txtFName.Text = userdom.FirstName;
txtMiddleName.Text = userdom.MiddleName;
txtlname.Text = userdom.LastName;
if (userdom.DateOfBirth != DateTime.MinValue)
{
txtdob.Text = Convert.ToString(userdom.DateOfBirth);
}
else
{
}
txtemail.Text = userdom.EmailId;
txtEmpCode.Text = userdom.EmpCode;
txtaddress.Text = userdom.Address;
rdbgender.SelectedValue = userdom.Gender;
rdbMaritalstatus.SelectedValue = userdom.MaritalStatus;
txtLoginId.Text = userdom.LoginId;
txtmobile.Text = userdom.MobileNo;
txtofficeextno.Text = userdom.OfficeExtentionNo;
txtpassword.Text = userdom.Password;
//txtConfirmPassword.Text = userdom.Password;
txtphn.Text = userdom.PhoneNo;
ddllocation.SelectedValue = userdom.UserLocation.LocationId.ToString();
rdbgender.SelectedValue = userdom.Gender;
rdbMaritalstatus.SelectedValue = userdom.MaritalStatus;
rbtnUserType.SelectedValue = userdom.UserTypeId.ToString();
}
public List <UserDom> GetUserDetails()
{
List <UserDom> lstdom = new List <UserDom>();
UserDom userdom = new UserDom();
lstdom = ob.ReadUserMaster();
return(lstdom);
}
protected void gridViewConsignment_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridView gvChildGrid = (GridView)e.Row.FindControl("gvChildGrid");
ConsignmentBusinessAccess conbal = new ConsignmentBusinessAccess();
Label lblConsignmentId = (Label)e.Row.FindControl("lblConsignmentId");
int ConsignmentId = Convert.ToInt32(lblConsignmentId.Text);
int locationId = LoggedInUser.UserLocation.LocationId;
int usertype = LoggedInUser.UserTypeId;
List <Pax> lstpax = null;
if (usertype == Convert.ToInt32(UserType.Admin) || usertype == Convert.ToInt32(UserType.SuperAdmin))
{
locationId = 0;
lstpax = conbal.ReadDataByPaxsConsignmentId(ConsignmentId, locationId);
}
else
{
lstpax = conbal.ReadDataByPaxsConsignmentId(ConsignmentId, locationId);
}
var lst = lstpax.Select(a => new { a.PaxName }).Distinct();
gvChildGrid.DataSource = lst;
gvChildGrid.DataBind();
gvChildGrid.ShowHeader = false;
UserDom user = new UserDom();
user = userBal.ReadUserByLoginId(LoggedInUser.LoginId);
LinkButton lnkEdit = (LinkButton)e.Row.FindControl("btnEdit");
LinkButton lnkDelete = (LinkButton)e.Row.FindControl("btnDelete");
lnkEdit.Visible = false;
lnkDelete.Visible = false;
if (LoggedInUser.UserTypeId == Convert.ToInt32(UserType.Admin) || LoggedInUser.UserTypeId == Convert.ToInt32(UserType.SuperAdmin))
{
lnkEdit.Visible = true;
lnkDelete.Visible = true;
}
else if (LoggedInUser.UserTypeId != Convert.ToInt32(UserType.Admin) && user.UserTask.Count > 0)
{
for (int i = 0; i < user.UserTask.Count; i++)
{
if (LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.EditConsignment))))
{
if (lnkEdit != null)
{
lnkEdit.Visible = true;
}
}
if (LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.DeleteConsignment))))
{
if (lnkDelete != null)
{
lnkDelete.Visible = true;
}
}
}
}
}
}
//public void DeleteUserTask(int taskId, string modifiedBy, DateTime modifieddate)
//{
// userdal.DeleteUserTask(taskId, modifiedBy, modifieddate);
//}
public UserDom ReadUserByLoginId(String loginId)
{
UserDom user = userdal.ReadUserByLoginID(loginId);
try
{
user.UserTask = userdal.ReadUserTaskByUserId(user.UserId);
}
catch (Exception exp)
{
throw exp;
}
return(user);
}
public UserDom ReadUserByLoginID(String loginId)
{
UserDom users = new UserDom();
DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.READ_USER_BYLOGIN_ID);
myDataBase.AddInParameter(dbcommand, "@in_LoginId", DbType.String, loginId);
using (IDataReader reader = myDataBase.ExecuteReader(dbcommand))
{
while (reader.Read())
{
users = GetUserDetailFromDataReader(reader);
}
}
return(users);
}
public List <UserDom> ReadUserMaster()
{
List <UserDom> lstdom = new List <UserDom>();
UserDom userdom = null;
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.READ_USER_MASTER);
using (IDataReader reader = myDataBase.ExecuteReader(dbCommand))
{
while (reader.Read())
{
userdom = GetUserDetailFromDataReader(reader);
lstdom.Add(userdom);
}
}
return(lstdom);
}
public UserDom ReadUserById(int userId)
{
UserDom userdom = new UserDom();
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.READ_USER_MASTER);
myDataBase.AddInParameter(dbCommand, "@UserId", DbType.Int32, userId);
using (IDataReader reader = myDataBase.ExecuteReader(dbCommand))
{
while (reader.Read())
{
userdom = GetUserDetailFromDataReader(reader);
}
}
return(userdom);
}
protected void LoginUser_Authenticate(object sender, AuthenticateEventArgs e)
{
if (ValidateUser())
{
UserBAL userBL = new UserBAL();
UserDom user = userBL.ReadUserByLoginId(LoginUser.UserName);
if (user.UserTypeId == 2 || user.UserTypeId == 3)
{
DateTime lastloginDate = user.LastLoginDate;
DateTime CurrentDate = DateTime.Today;
TimeSpan ts = CurrentDate.Subtract(lastloginDate);
int Days = Convert.ToInt32(ts.TotalDays);
if (Days > 10)
{
ScriptManager.RegisterClientScriptBlock(LoginUser, GetType(), "a", "alert('Your password has been expired..')", true);
}
else if (user == null)
{
LoginUser.FailureText = "User not Found..";
return;
}
else
{
FormsAuthentication.RedirectFromLoginPage(LoginUser.UserName, LoginUser.RememberMeSet);
UpdateLoginDate(DateTime.Now, user.LoginId);
Session["LoginUser"] = user.FullName;
Session["MobileNo"] = user.MobileNo;
Session["EmailId"] = user.EmailId;
}
}
else
{
FormsAuthentication.RedirectFromLoginPage(LoginUser.UserName, LoginUser.RememberMeSet);
UpdateLoginDate(DateTime.Now, user.LoginId);
Session["LoginUser"] = user.FullName;
Session["MobileNo"] = user.MobileNo;
Session["EmailId"] = user.EmailId;
}
}
else
{
LoginUser.FailureText = "User name or password incorrect. Please try again..";
}
}
protected void gvPrintInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
UserDom user = new UserDom();
UserBAL userBal = new UserBAL();
user = userBal.ReadUserByLoginId("12");
// Removinfg Aspx page acton CommandName lnkEdit
//LinkButton lnkEdit = (LinkButton)e.Row.FindControl("lbtnEdit");
//lnkEdit.Visible = false;
//if (1 == 1)
//{
// lnkEdit.Visible = true;
//}
}
}
protected void gvw_RowCommand(object sender, GridViewCommandEventArgs e)
{
int userId = 0;
userId = Convert.ToInt32(e.CommandArgument);
this.UserId = userId;
if (e.CommandName == "cmdEditt")
{
SetControlsName(GetUserById(userId));
btnSave.Visible = false;
btnupdate.Visible = true;
}
if (e.CommandName == "cmdDelete")
{
ob.DeleteUserMaster(userId, "Admin", DateTime.Now);
BindgvwUser();
}
if (e.CommandName == "cmdDetails")
{
UserDom userdom = new UserDom();
userdom = ob.ReadUserById(userId);
lblname.Text = userdom.FullName;
lblLid.Text = userdom.LoginId;
lbladd.Text = userdom.Address;
lblemail.Text = userdom.EmailId;
lblEmpCode.Text = userdom.EmpCode;
lblgender.Text = userdom.Gender;
lblphone.Text = userdom.PhoneNo;
lblDOB.Text = userdom.DateOfBirth.ToString();
lbllocation.Text = userdom.UserLocation.City;
lblMobNo.Text = userdom.MobileNo;
lblOfficeExtNo.Text = userdom.OfficeExtentionNo;
lblPwd.Text = userdom.Password;
lblMarritalS.Text = userdom.MaritalStatus;
ModalPopupExtender1.Show();
BindgvwUser();
}
if (e.CommandName == "cmdUserTaskMapping")
{
Response.Redirect("UserTaskMapping.aspx?UserId=" + userId);
}
}
public int UpdateUserMaster(UserDom userdom)
{
int userId = 0;
string sqlcommand = DBConstant.EDIT_USER_MASTER;
// String sqlcommand = DBContact.Update_User_Master;
DbCommand dbcommand = myDataBase.GetStoredProcCommand(sqlcommand);
myDataBase.AddInParameter(dbcommand, "@User_Id", DbType.String, userdom.UserId);
myDataBase.AddInParameter(dbcommand, "@First_Name", DbType.String, userdom.FirstName);
myDataBase.AddInParameter(dbcommand, "@Last_Name", DbType.String, userdom.LastName);
myDataBase.AddInParameter(dbcommand, "@Middle_Name", DbType.String, userdom.MiddleName);
myDataBase.AddInParameter(dbcommand, "@Login_Id", DbType.String, userdom.LoginId);
myDataBase.AddInParameter(dbcommand, "@Password", DbType.String, userdom.Password);
myDataBase.AddInParameter(dbcommand, "@Email_Id", DbType.String, userdom.EmailId);
myDataBase.AddInParameter(dbcommand, "@Gender", DbType.String, userdom.Gender);
myDataBase.AddInParameter(dbcommand, "@Phone", DbType.String, userdom.PhoneNo);
myDataBase.AddInParameter(dbcommand, "@Mobile", DbType.String, userdom.MobileNo);
if (userdom.DateOfBirth == DateTime.MinValue)
{
myDataBase.AddInParameter(dbcommand, "@DOB", DbType.DateTime, DBNull.Value);
}
else
{
myDataBase.AddInParameter(dbcommand, "@DOB", DbType.DateTime, userdom.DateOfBirth);
}
myDataBase.AddInParameter(dbcommand, "@MaritalStatus", DbType.String, userdom.MaritalStatus);
myDataBase.AddInParameter(dbcommand, "@EmpCode", DbType.String, userdom.EmpCode);
myDataBase.AddInParameter(dbcommand, "@OfficeExtNo", DbType.String, userdom.OfficeExtentionNo);
myDataBase.AddInParameter(dbcommand, "@Location_Id", DbType.Int32, userdom.UserLocation.LocationId);
myDataBase.AddInParameter(dbcommand, "@Address", DbType.String, userdom.Address);
// myDataBase.AddInParameter(dbcommand, "@Created_By", DbType.String, userdom..Created_By);
myDataBase.AddInParameter(dbcommand, "@Modified_by", DbType.String, userdom.Modified_By);
myDataBase.AddInParameter(dbcommand, "@Modified_date", DbType.DateTime, userdom.Modified_Date);
myDataBase.AddOutParameter(dbcommand, "@out_User_Id ", DbType.Int32, 10);
myDataBase.ExecuteNonQuery(dbcommand);
int.TryParse(myDataBase.GetParameterValue(dbcommand, "@out_User_Id ").ToString(), out userId);
return(userId);
}
public ActionResult Login(FormCollection collection)
{
if (ModelState.IsValid)
{
var dao = new UserDom();
var result = dao.Login(collection["inputUserName"].ToString(), collection["UserPassword"].ToString());
if (result == 1)
{
var user = dao.GetById(collection["inputUserName"].ToString());
var userSession = new UserLogin();
userSession.UserName = user.Username;
userSession.UserID = user.ID;
Session.Add(CommonConstants.USER_SESSION, userSession.UserName);
Session.Add(CommonConstants.ID_SESSION, userSession.UserID);
return(RedirectToAction("Index", "Home"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Account isn't exist");
}
else if (result == -1)
{
ModelState.AddModelError("", "Account is locked");
}
else if (result == -2)
{
ModelState.AddModelError("", "Password is wronged");
}
else
{
ModelState.AddModelError("", "đăng nhập không đúng");
}
}
else
{
}
return(View("Index"));
}
protected void btnSave_Click(object sender, EventArgs e)
{
//BasePage basepage=new BasePage();
//List<UserTaskMaping> lst = new List<UserTaskMaping>();
//lst = userBal.ReadUserTask(UserId);
//BindCheckBoxList();
//foreach (ListItem item in chbxUserTask.Items)
//{
// foreach (UserTaskMaping pop in lst)
// {
// if (Convert.ToInt32(item.Value) == pop.MetadataUserTask.Id)
// {
// item.Selected = true;
// userBal.DeleteUserTask(UserId,basepage.LoggedInUser.LoginId,DateTime.Now);
// }
// }
//}
UserDom user = new UserDom();
user.UserId = Convert.ToInt32(hdfldUserId.Value);
user.UserTask = new List <UserTaskMaping>();
foreach (ListItem item in chbxUserTask.Items)
{
if (item.Selected == true)
{
UserTaskMaping usertaskMap = new UserTaskMaping();
usertaskMap.UserTaskMappingId = Convert.ToInt32(item.Value);
usertaskMap.Description = item.Text;
usertaskMap.Created_By = "Admin";
usertaskMap.Created_Date = DateTime.Now;
user.UserTask.Add(usertaskMap);
}
}
userBal.CreateUserTask(user.UserTask, user.UserId);
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "a", "alert('User Task Mapping Updated successfully...')", true);
chbxUserTask.Enabled = false;
Response.Redirect("UserMaster.aspx");
}
protected void btnupdate_Click(object sender, EventArgs e)
{
int out1 = 0;
UserDom user = new UserDom();
user.UserId = this.UserId;
user.FirstName = txtFName.Text;
user.MiddleName = txtMiddleName.Text;
user.LastName = txtlname.Text;
user.Password = txtpassword.Text;
user.EmpCode = txtEmpCode.Text;
user.UserLocation = new LocationMaster();
user.UserLocation.LocationId = (Convert.ToInt32(ddllocation.SelectedItem.Value));
user.LoginId = txtLoginId.Text;
user.EmailId = txtemail.Text;
user.PhoneNo = txtphn.Text;
user.MobileNo = txtmobile.Text;
user.OfficeExtentionNo = txtofficeextno.Text;
user.Gender = rdbgender.SelectedItem.Text;
user.Address = txtaddress.Text;
user.MaritalStatus = rdbMaritalstatus.SelectedItem.Text;
user.UserTypeId = Convert.ToInt32(rbtnUserType.SelectedValue);
user.DateOfBirth = Convert.ToDateTime(txtdob.Text);
user.Modified_By = basePage.LoggedInUser.LoginId;
user.Modified_Date = DateTime.Now;
out1 = ob.UpdateUserMaster(user);
if (out1 > 0)
{
ScriptManager.RegisterClientScriptBlock(btnupdate, GetType(), "a", "alert('User Updated successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(btnupdate, GetType(), "a", "alert('Can't Enter duplicate Emp Code')", true);
}
BindgvwUser();
CancelUserDetails();
btnupdate.Visible = false;
}
protected void gvw_RowCommand(object sender, GridViewCommandEventArgs e)
{
int userId = 0;
userId = Convert.ToInt32(e.CommandArgument);
this.UserId = userId;
if (e.CommandName == "cmdEditt")
{
SetControlsName(GetUserById(userId));
btnSave.Visible = false;
}
if (e.CommandName == "cmdDelete")
{
ob.DeleteUserMaster(userId, "Admin", DateTime.Now);
BindgvwUser();
}
if (e.CommandName == "cmdDetails")
{
UserDom userdom = new UserDom();
userdom = ob.ReadUserById(userId);
lblname.Text = userdom.FirstName;
lblLid.Text = userdom.LoginId;
ddllocation.SelectedValue = (userdom.UserLocation.LocationName).ToString();
lbladd.Text = userdom.Address;
lblemail.Text = userdom.EmailId;
lblEmpCode.Text = userdom.EmpCode;
lblgender.Text = userdom.Gender;
lblphone.Text = userdom.PhoneNo;
//this.modalpopupExt.Show();
BindgvwUser();
}
if (e.CommandName == "cmdUserTaskMapping")
{
Response.Redirect("UserTaskMapping.aspx?UserId=" + userId);
}
}
protected void Page_Load(object sender, EventArgs e)
{
LblLoginUser.Text = basePage.LoggedInUser.FullName;
if (!IsPostBack)
{
UserDom user = new UserDom();
user = userBal.ReadUserByLoginId(basePage.LoggedInUser.LoginId);
if (basePage.LoggedInUser.UserTypeId != Convert.ToInt32(UserType.Admin) && basePage.LoggedInUser.UserTypeId != Convert.ToInt32(UserType.SuperAdmin))
{
agentlist.Visible = false;
viewConsignment.Visible = false;
updateConsignment.Visible = false;
embassyFee.Visible = false;
embassyMaster.Visible = false;
searchEmbassyFee.Visible = false;
miscellaneous.Visible = false;
addVisaForm.Visible = false;
showvisaForm.Visible = false;
addVisaInfo.Visible = false;
viewVisaInfo.Visible = false;
addHoliday.Visible = false;
holidayList.Visible = false;
addAgent.Visible = false;
agentEditUpdate.Visible = false;
listAgent.Visible = false;
exportAgent.Visible = false;
agentEmailList.Visible = false;
admin.Visible = false;
advanceSearchReport.Visible = false;
receiptGen.Visible = false;
editReceipt.Visible = false;
dataExportTally.Visible = false;
newsLetter.Visible = false;
viewnewsLetter.Visible = false;
invoiceList.Visible = false;
printInvoice.Visible = false;
reprintInvoice.Visible = false;
billRegister.Visible = false;
statementOfAccnt.Visible = false;
bankStatement.Visible = false;
agingAnalysis.Visible = false;
summaryReport.Visible = false;
miscellaneousReport.Visible = false;
EditDeleteConsignment.Visible = false;
city.Visible = false;
for (int i = 0; i < user.UserTask.Count; i++)
{
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddConsignment))))
{
agentlist.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewConsignment))))
{
viewConsignment.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.EditConsignment))))
{
EditDeleteConsignment.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.DeleteConsignment))))
{
EditDeleteConsignment.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.UpdateConsignmentStatus))))
{
updateConsignment.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.EmbassyFeeMaster))))
{
embassyFee.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.EmbassyMaster))))
{
embassyMaster.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.SearchEmbassyFee))))
{
searchEmbassyFee.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.MiscellaneousCharges))))
{
miscellaneous.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddVisaForm))))
{
addVisaForm.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewVisaForm))))
{
showvisaForm.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddVisaInfo))))
{
addVisaInfo.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewVisaInfo))))
{
viewVisaInfo.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddHoliday))))
{
addHoliday.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewHoliday))))
{
holidayList.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddAgent))))
{
addAgent.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ManageAgent))))
{
agentEditUpdate.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AgentList))))
{
listAgent.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ExportAgent))))
{
exportAgent.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AgentEmailList))))
{
agentEmailList.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.Admin))))
{
admin.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AdvanceSearch))))
{
advanceSearchReport.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ReceiptGeneration))))
{
receiptGen.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.EditReceipt))))
{
editReceipt.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ExportDataToTally))))
{
dataExportTally.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddNewsLetter))))
{
newsLetter.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewNewsLetter))))
{
viewnewsLetter.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.InvoiceReceiptPrinting))))
{
invoiceList.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.InvoicePrinting))))
{
printInvoice.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.InvoiceReprinting))))
{
reprintInvoice.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.BillRegister))))
{
billRegister.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.StatementOfAccount))))
{
statementOfAccnt.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.BankStatement))))
{
bankStatement.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AgingAnalysis))))
{
agingAnalysis.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.SummaryReport))))
{
summaryReport.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.MiscellaneousReport))))
{
miscellaneousReport.Visible = true;
}
if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddCity))))
{
city.Visible = true;
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateUser())
{
UserBAL userBL = new UserBAL();
UserDom user = userBL.ReadUserByLoginId(LoginUser.UserName);
if (user.UserTypeId == 2 || user.UserTypeId == 3)
{
DateTime lastloginDate = user.LastLoginDate;
DateTime CurrentDate = DateTime.Today;
TimeSpan ts = CurrentDate.Subtract(lastloginDate);
int Days = Convert.ToInt32(ts.TotalDays);
if (Days > 10)
{
ScriptManager.RegisterClientScriptBlock(LoginUser, GetType(), "a", "alert('Your password has been expired..')", true);
}
else if (user == null)
{
LoginUser.FailureText = "User not Found..";
return;
}
else
{
string role = string.Empty;
if (user.UserTypeId == 1)
{
role = "Admin";
}
else if (user.UserTypeId == 2)
{
role = "CompanyUser";
}
else if (user.UserTypeId == 3)
{
role = "AgentUser";
}
else if (user.UserTypeId == 4)
{
role = "SuperAdmin";
}
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, user.FullName, DateTime.Now, DateTime.Now.AddMinutes(30), false, role);
string encTicket = FormsAuthentication.Encrypt(ticket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
Response.Cookies.Add(faCookie);
//HttpCookie MyCookies = new HttpCookie("myCookie");
//MyCookies.Values.Add("userId", user.LoginId.ToString());
//Response.Cookies.Add(MyCookies);
//Session["LoginId"] = user.LoginId;
//Response.Redirect("Index.aspx");
//FormsAuthentication.RedirectFromLoginPage(LoginUser.UserName, LoginUser.RememberMeSet);
//UpdateLoginDate(DateTime.Now, user.LoginId);
}
}
else
{
// added by divaker
//if (chkRem.Checked)
//{
// Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(30);
// Response.Cookies["Password"].Expires = DateTime.Now.AddDays(30);
//}
//else
//{
// Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(-1);
// Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1);
//}
//Response.Cookies["UserName"].Value = UserName.Text.Trim();
//Response.Cookies["Password"].Value = Password.Text.Trim();
string role = string.Empty;
if (user.UserTypeId == 1)
{
role = "Admin";
}
else if (user.UserTypeId == 2)
{
role = "CompanyUser";
}
else if (user.UserTypeId == 3)
{
role = "AgentUser";
}
else if (user.UserTypeId == 4)
{
role = "SuperAdmin";
}
// var userRoles = Roles(UserId, SFConfig.ApplicationName, SFConfig.RoleDBConnString);
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(user.UserId, user.FullName, DateTime.Now, DateTime.Now.AddMinutes(30), false, role, FormsAuthentication.FormsCookiePath);
string encTicket = FormsAuthentication.Encrypt(ticket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
Response.Cookies.Add(faCookie);
HttpCookie MyCookies = new HttpCookie("myCookie");
MyCookies.Values.Add("userId", user.LoginId.ToString());
Response.Cookies.Add(MyCookies);
//FormsAuthentication.RedirectFromLoginPage(LoginUser.UserName, LoginUser.RememberMeSet);
//UpdateLoginDate(DateTime.Now, user.LoginId);
//Session["LoginUser"] = user.FullName;
//Session["MobileNo"] = user.MobileNo;
//Session["EmailId"] = user.EmailId;
Session["LoginId"] = user.UserId;
Session["AgentId"] = null;
bool adminVal = ValidateUser();
Session["adminValidate"] = adminVal;
Response.Redirect("Index.aspx");
}
}
else if (ValidateAgent())
{
Agent agent = new Agent();
UserDom user = new UserDom();
agent = agentBal.ReadAgentById(LoginUser.UserName);
string role = string.Empty;
role = "AgentUser";
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(agent.AgentLocationId, agent.AgentName, DateTime.Now, DateTime.Now.AddMinutes(30), false, role, FormsAuthentication.FormsCookiePath);
string encTicket = FormsAuthentication.Encrypt(ticket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
Response.Cookies.Add(faCookie);
HttpCookie MyCookies = new HttpCookie("myCookie");
MyCookies.Values.Add("userId", agent.AgentName.ToString());
// basePage.LoggedInUser.LoginId = agent.AgentLocationId.ToString();
Session["AgentId"] = agent.AgentId;
Response.Cookies.Add(MyCookies);
Session["LocationId"] = agent.AgentLocationId;
bool agentVal = ValidateAgent();
Session["agentValidate"] = agentVal;
Response.Redirect("Index.aspx");
}
else
{
Response.Write("<Script language='javascript'>alert('Your User Id or Password is incorrect. please try again');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Header.DataBind();
//if (basePage.LoggedInUser.UserTypeId == Convert.ToInt32(UserType.Admin) && basePage.LoggedInUser.UserTypeId == Convert.ToInt32(UserType.SuperAdmin))
//{
// agentMenuSection.Visible = false;
// adminMenuSection.Visible = true;
//}
//else
//{
// agentMenuSection.Visible = true;
// adminMenuSection.Visible = false;
//}
HttpCookie getcookies = Request.Cookies["myCookie"];
//Response.Cache.SetCacheability(HttpCacheability.NoCache);
//Response.Cache.SetExpires(DateTime.UtcNow.AddHours(-1));
if (getcookies != null)
{
menulogin.Visible = true;
LeaderBoardLogin3.Visible = false;
}
else
{
menulogin.Visible = false;
LeaderBoardLogin3.Visible = true;
}
#region Assign task Admin And Agent
if (!IsPostBack)
{
UserDom user = new UserDom();
Agent agent = new Agent();
user = userBal.ReadUserByLoginId(basePage.LoggedInUser.LoginId);
if (basePage.LoggedInUser.UserTypeId != Convert.ToInt32(UserType.Admin) && basePage.LoggedInUser.UserTypeId != Convert.ToInt32(UserType.SuperAdmin))
{
viewConsignment.Visible = false;
//updateConsignment.Visible = false;
addVisaForm.Visible = false;
//showvisaForm.Visible = false;
addVisaInfo.Visible = false;
viewVisaInfo.Visible = false;
addHoliday.Visible = false;
holidayList.Visible = false;
addAgent.Visible = false;
agentEditUpdate.Visible = false;
//listAgent.Visible = false;
//exportAgent.Visible = false;
//agentEmailList.Visible = false;
admin.Visible = false;
newsLetter.Visible = false;
viewnewsLetter.Visible = false;
invoiceList.Visible = false;
// printInvoice.Visible = false;
billRegister.Visible = false;
city.Visible = false;
agentMenuSection.Visible = false;
#region Task Assign
//for (int i = 0; i < user.UserTask.Count; i++)
//{
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewConsignment))))
// {
// viewConsignment.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.UpdateConsignmentStatus))))
// {
// //updateConsignment.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddVisaForm))))
// {
// addVisaForm.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewVisaForm))))
// {
// showvisaForm.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddVisaInfo))))
// {
// addVisaInfo.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewVisaInfo))))
// {
// viewVisaInfo.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddHoliday))))
// {
// addHoliday.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewHoliday))))
// {
// holidayList.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddAgent))))
// {
// addAgent.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ManageAgent))))
// {
// agentEditUpdate.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AgentList))))
// {
// //listAgent.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ExportAgent))))
// {
// // exportAgent.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AgentEmailList))))
// {
// // agentEmailList.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.Admin))))
// {
// admin.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddNewsLetter))))
// {
// newsLetter.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.ViewNewsLetter))))
// {
// viewnewsLetter.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.InvoiceReceiptPrinting))))
// {
// invoiceList.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.InvoicePrinting))))
// {
// // printInvoice.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.InvoiceReprinting))))
// {
// //reprintInvoice.Visible = true;
// }
// if (basePage.LoggedInUser.UserTask[i].MetadataUserTask.Id.Equals(Convert.ToInt32((UserTaskId.AddCity))))
// {
// city.Visible = true;
// }
//}
#endregion
}
// int agentlogin = agentBal.ValidateAgent(LoginUser.UserName, LoginUser.Password);
if (Session["agentValidate"] != null)
{
bool b = (bool)Session["agentValidate"];
if (b)
{
viewConsignment.Visible = true;
//showvisaForm.Visible = true;
//viewVisaInfo.Visible = false;
holidayList.Visible = true;
viewnewsLetter.Visible = true;
invoiceList.Visible = true;
billRegister.Visible = true;
Liagent.Visible = false;
viewVisaInfo.Visible = true;
adminMenuSection.Visible = false;
agentMenuSection.Visible = true;
}
}
else
{
agentMenuSection.Visible = false;
adminMenuSection.Visible = true;
}
}
#endregion
}
