protected void btnSave_Click(object sender, EventArgs e)
{
//save/update changed collection point & representative in database
int selectColPoint = ddlCollectPoint.SelectedIndex;
string repFullName = ddlRepName.SelectedItem.ToString();
if (selectColPoint == 0 || repFullName.Equals("Select---"))
{
lbDDLError1.Text = "Please select the required field!";
}
else
{
//show Full Name- save username
Dept_Registry depReg = context.Dept_Registry.SingleOrDefault(x => x.fullname == repFullName);
string repUserName = depReg.username;
var result = context.Departments.SingleOrDefault(c => c.name == sdept.name);
result.rep_user = repUserName;
result.collection_point = selectColPoint;
context.SaveChanges();
lbDDLError1.Text = "Sucessfully Save!";
_sendEmail(User.Identity.Name, repUserName);
}
}
public WCFDepartment GetDeptNamebycode(string deptName)
{
Department dept1 = context.Departments.Where(x => x.name == deptName).First();
Dept_Registry dr = context.Dept_Registry.Where(x => x.username == dept1.rep_user).First();
WCFDepartment wd = new WCFDepartment(dept1.dept_code, dr.fullname, dept1.contact_num);
return(wd);
}
private void FillPage()
{
// need to login
if (!User.Identity.IsAuthenticated)
{
Response.Redirect("~/login.aspx?return=Views/DepartmentHead/HeadDashboard.aspx");
}
string username = User.Identity.Name.ToString();
UserModel user = new UserModel(username);
string currentDept = user.Department.dept_code;
var requestInfo = (from o in context.Requests
where (currentDept == o.dept_code) && (o.current_status == RequestStatus.PENDING | o.current_status == RequestStatus.UPDATED)
select new { o.request_id, o.username, o.date_time, o.reason }).ToList();
GridView1.DataSource = requestInfo;
GridView1.DataBind();
string pendingnum = GridView1.Rows.Count.ToString();
lblPendingNum.Text = "You Have " + pendingnum + " Requests(s) to View";
string currentUser = Page.User.Identity.Name;
string fullName = "";
using (SSISEntities context = new SSISEntities())
{
fullName = context.Dept_Registry.Find(currentUser).fullname;
}
lblFullName.Text = "Welcome, " + fullName;
Department dept = context.Departments.Where(x => currentDept == x.dept_code).First();
Collection_Point colpoint = context.Collection_Point.Where(y => y.collection_pt_id == dept.collection_point).First();
Dept_Registry dr = context.Dept_Registry.Where(x => x.username == dept.rep_user).First();
lblrep.Text = dr.fullname;
lblcolpoint.Text = colpoint.location + " (" + colpoint.day_of_week + " - " + colpoint.date_time.ToShortTimeString() + ")";
var deldept = (from x in context.Approval_Duties select x.dept_code).ToList();
if (deldept.Contains(currentDept))
{
List <Approval_Duties> ads = context.Approval_Duties.Where(x => currentDept == x.dept_code).ToList();
foreach (Approval_Duties ad in ads)
{
DateTime start = ad.start_date;
DateTime end = ad.end_date;
if ((DateTime.Now > start && DateTime.Now < end) && (ad.deleted == "N"))
{
lbldelegation.Text = ad.username + " (" + start + " - " + end + ")";
break;
}
}
}
}
//public static readonly string[] ROLES = { "DeptHead", "Manager", "Supervisor", "Clerk", "Employee" };
//public enum UserRoles { DeptHead, Manager, Supervisor, Clerk, Employee }
public UserModel(string username)
{
SSISEntities context = new SSISEntities();
Dept_Registry user = context.Dept_Registry.Where(x => x.username.ToLower() == username.ToLower()).ToList().First();
Department dept = context.Departments.Where(x => x.dept_code == user.dept_code).ToList().First();
//Membership.FindUsersByName(username);
this.username = user.username;
// Cannot enable yet, as members do not exist in asp.net db
MembershipUser thisUser = Membership.GetUser(username);
this.email = thisUser != null ? thisUser.Email : "sa44ssisteamtwo+" + username + "@gmail.com";
this.department = dept;
var roles = Roles.GetRolesForUser(username);
if (roles.Count() > 0)
{
var filteredRoles = ROLES.Where(w => roles.Contains(w));
this.role = filteredRoles.Count() > 0 ? filteredRoles.First() : ROLES.Last();
}
else
{
this.role = "Employee";
}
//this.fullname = UserPrincipal.Current.DisplayName;
this.fullname = user.fullname;
if (user.mobile_no == null)
{
this.mobilenum = "";
}
else
{
this.mobilenum = user.mobile_no;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//show FUll Name- save username
delegateFullName = ddlEmployee.SelectedItem.ToString();
//Select Dropdown List Validation
try
{
if (delegateFullName.Equals("Select---"))
{
Label1.Text = "Please Choose One Delegate!";
}
else
{
Label1.Text = "";
}
//Date Validation
selectStartDate = tbStartDate.Text;
selectEndDate = tbEndDate.Text;
if (selectStartDate == "" || selectEndDate == "")
{
lbDateError.Text = "Please choose the Date!";
}
else
{
if (selectStartDate.CompareTo(currentDate) == -1 || selectEndDate.CompareTo(currentDate) == -1)
{
lbDateError.Text = "cannot choose previous date!";
}
else if (selectEndDate.CompareTo(selectStartDate) == -1)
{
lbDateError.Text = "Start Date should before End Date!";
}
else
{
lbDateError.Text = "";
Dept_Registry depReg = context.Dept_Registry.SingleOrDefault(x => x.fullname == delegateFullName);
delegateUserName = depReg.username;
Approval_Duties ad = new Approval_Duties
{
//delegateFullName
username = delegateUserName,
start_date = Convert.ToDateTime(tbStartDate.Text),
end_date = Convert.ToDateTime(tbEndDate.Text),
dept_code = currentDeptCode,
created_date = Convert.ToDateTime(currentDate),
deleted = "N",
reason = tbReason.Text
};
context.Approval_Duties.Add(ad);
context.SaveChanges();
lbDateError.Text = "Successfully Saved!";
}
}
}
catch (Exception ex)
{
ex.StackTrace.ToString();
}
}
public Dept_Registry login(string user)
{
Dept_Registry dr = context.Dept_Registry.Where(x => x.username == user).First();
return(dr);
}
