private void possession()
{
long id;
Int64.TryParse(hdnSelected.Value, out id);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
tbAllotmentApplication app = AllotementApplications.GetApplication(id);
tblAllottee _allotte = Allottee.getAllotteByApplicationid(id);
if (_allotte != null)
{
DateTime _dateofPossession;
DateTime.TryParse(txtDateOfPossession.Text, out _dateofPossession);
_allotte.Status = (int)AllotementStatus.Possessed;
_allotte.DateOfPossession = _dateofPossession;
Allottee.Update(_allotte);
}
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Possession";
_userhistory.description = _user.Username + " has marked possesed application with " + id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
}
protected void GridRowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Verify")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
Response.Redirect(string.Format("~/user/submission.aspx?applicationid={0}&returnurl=admin/verification.aspx&verify=true", id));
}
if (e.CommandName == "view")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
Response.Redirect(string.Format("~/user/submission.aspx?applicationid={0}&returnurl=admin/verification.aspx", id));
}
if (e.CommandName == "reject")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
tbAllotmentApplication application = AllotementApplications.GetApplication(id);
application.Status = (int)ApplicationStatus.rejected;
AllotementApplications.SaveApplications(application);
lblMessage.Text = "Application has been rejected sucessfully!";
lblMessage.Visible = true;
BindData();
}
}
protected void GridRowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Verify")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
Response.Redirect(string.Format("~/user/submission.aspx?applicationid={0}&returnurl=admin/verification.aspx&verify=true", id));
}
if (e.CommandName == "view")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
//or Admin is viewing the application,application is pending, allow user through this step
if (AllotementApplications.GetApplication(id).Status == 0 || _user.Roleid == 1)
{
Response.Redirect(string.Format("~/user/submission.aspx?applicationid={0}&returnurl=user/application.aspx", id));
}
else
{
Response.Redirect(string.Format("~/user/processapplication.aspx?applicationId={0}", id));
}
}
}
public void grdAllotte_command(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "vacant")
{
long id = Convert.ToInt64(e.CommandArgument);
hdnselected.Value = id.ToString();
//Allottee.VacantAllottement(id);
//BindData();
//tbluserhistory _userhistory = new tbluserhistory();
//_userhistory.Action = "Allotement";
//_userhistory.description = _user.Username + " has marked vacant with id " + id;
//_userhistory.time = DateTime.Now;
//_userhistory.useraan = _user.AAN;
//userHistory.Save(_userhistory);
tblAllottee _allotte = Allottee.GetAllottee(Convert.ToInt64(e.CommandArgument));
txtName.Text = AllotementApplications.GetApplication(_allotte.ApplicationId.Value).tblUser.fullName;
txtQuarternumber.Text = _allotte.QuarterNumber;
popVacant.Show();
}
else if (e.CommandName == "Retention")
{
long id = Convert.ToInt64(e.CommandArgument);
tblAllottee _allotte = Allottee.GetAllottee(Convert.ToInt64(e.CommandArgument));
txtRetName.Text = AllotementApplications.GetApplication(_allotte.ApplicationId.Value).tblUser.fullName;
txtRetQuarerNumber.Text = _allotte.QuarterNumber;
txtDateOfRetension.Text = string.Empty;
txtdateofretensionupto.Text = string.Empty;
txtRemarks.Text = string.Empty;
ddlRetentionPeriod.SelectedIndex = -1;
ddlRetentionRule.SelectedIndex = -1;
hdnselected.Value = id.ToString();
ModalPopupExtender1.Show();
}
}
protected void gridCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Allotte")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
var gridRow = ((LinkButton)e.CommandSource).NamingContainer as GridViewRow;
HiddenField hidApplicationId = gridRow.FindControl("hidApplicationId") as HiddenField;
//AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Allotted);
Response.Redirect("~/admin/Allottee.aspx?appid=" + hidApplicationId.Value + "&ChangeRequestID=" + id + "&returnurl=admin/ViewChangeRequest.aspx");
}
else if (e.CommandName == "Withdraw")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
DataClassesDataContext dataContext = new DataClassesDataContext();
var requests = from request in dataContext.tblChangeRequests where request.Id == id select request;
tblChangeRequest tblreject = requests.FirstOrDefault();
if (tblreject != null)
{
//Added on January 24,2017
tblAllottee allottee = Allottee.GetAllotteeByAAN(tblreject.AAN);
Quarters.UpdateQuarterStatus(allottee.QuarterNumber, QuarterStatus.Vacant);
//update allottee
//Reset the quarter to previous one at the time of change request
allottee.QuarterNumber = tblreject.QuarterNumber;
Allottee.Update(allottee);
//Added on January 24,2017 end
dataContext.tblChangeRequests.DeleteOnSubmit(tblreject);
dataContext.SubmitChanges();
}
BindGrid();
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.rejected);
//Quarters.UpdateQuarterStatus(tblreject.QuarterNumber, QuarterStatus.Vacant); //Commented on Dec 12,2016 purposely
}
else if (e.CommandName == "Possesed")
{
var gridRow = ((LinkButton)e.CommandSource).NamingContainer as GridViewRow;
LinkButton lnkAllotte = gridRow.FindControl("lnkAllotte") as LinkButton;
hdnChangeRequestId.Value = lnkAllotte.CommandArgument;
hdnSelected.Value = e.CommandArgument.ToString();
tblAllottee _allotte = Allottee.getAllotteByApplicationid(Convert.ToInt64(e.CommandArgument));
txtName.Text = AllotementApplications.GetApplication(Convert.ToInt64(e.CommandArgument)).tblUser.fullName;
if (_allotte != null)
{
txtQuarternumber.Text = _allotte.QuarterNumber;
}
pop.Show();
}
}
private void possession()
{
long id;
Int64.TryParse(hdnSelected.Value, out id);
long changeRequestId;
Int64.TryParse(hdnChangeRequestId.Value, out changeRequestId);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
tbAllotmentApplication app = AllotementApplications.GetApplication(id);
tblAllottee _allotte = Allottee.getAllotteByApplicationid(id);
if (_allotte != null)
{
DateTime _dateofPossession;
DateTime.TryParse(txtDateOfPossession.Text, out _dateofPossession);
_allotte.Status = (int)AllotementStatus.Possessed;
_allotte.DateOfPossession = _dateofPossession;
Allottee.Update(_allotte);
}
if (id > 0)
{
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
}
DataClassesDataContext dataContext = new DataClassesDataContext();
var requests = from request in dataContext.tblChangeRequests where request.Id == changeRequestId select request;
/*tblChangeRequest tblDelete = requests.FirstOrDefault();
* if (tblDelete != null)
* {
* dataContext.tblChangeRequests.DeleteOnSubmit(tblDelete);
* dataContext.SubmitChanges();
* } //Finally deleting the change request changed on 02-06-2016*/
tblChangeRequest tblUpdate = requests.FirstOrDefault();
if (tblUpdate != null)
{
tblUpdate.Status = (int)ChangeRequestStatus.Approved;
dataContext.SubmitChanges(); //Updating the status of request to approved
}
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Possession";
_userhistory.description = _user.Username + " has marked possesed application with " + id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
}
private void BindData()
{
List <AllotementApplication> lstAllotmentApplications = AllotementApplications.GetAllotedUsers(ApplicationStatus.Allotted, Convert.ToInt64(drpQuarterCatergory.SelectedValue));
if (lstAllotmentApplications != null)
{
lstAllotmentApplications = lstAllotmentApplications.OrderBy(x => x.UserName).ToList(); //Order by
}
grdQuarters.DataSource = lstAllotmentApplications;
grdQuarters.DataBind();
}
private void BindPriorityListGrid()
{
List <AllotementApplication> lstAllottmentApplication = AllotementApplications.GetPendingApplications(ApplicationStatus.Verified, Convert.ToInt64(drpQuarterCatergory.SelectedValue));
//lstAllottmentApplication = lstAllottmentApplication.OrderBy(x => x.UserName).ToList(); //Order by name
long floor = 2; //First floor
if (!string.IsNullOrEmpty(Request["type"]) && Convert.ToString(Request["type"]) == "medical")
{
floor = 1; //Ground floor
}
List <Quarerinfo> lstQuarterInfo = Quarters.GetAllVacantQuarters(Convert.ToInt64(drpQuarterCatergory.SelectedValue));
if (floor == 2)
{
lstQuarterInfo = lstQuarterInfo.Where(quarter => quarter.QuarterNumber.Contains('A') ||
quarter.QuarterNumber.Contains('B') ||
quarter.QuarterNumber.Contains('C') ||
quarter.QuarterNumber.Contains('D')).ToList();
}
else if (floor == 1)
{
lstQuarterInfo = lstQuarterInfo.Where(quarter => !(quarter.QuarterNumber.Contains('A') ||
quarter.QuarterNumber.Contains('B') ||
quarter.QuarterNumber.Contains('C') ||
quarter.QuarterNumber.Contains('D'))).ToList();
if (lstAllottmentApplication != null)
{
//Filter allotment applications as per medical conditions
lstAllottmentApplication = lstAllottmentApplication.Where(x => x.MedicalCategory).ToList();
}
}
lstQuarterInfo = lstQuarterInfo.Take(lstAllottmentApplication.Count).ToList(); //Taking as many records there
int totalApplications = Math.Min(lstAllottmentApplication.Count, lstQuarterInfo.Count);
for (int count = 0; count < totalApplications; count++)
{
string quarterNumber = "N/A";
if (lstQuarterInfo.Any() && lstQuarterInfo[count] != null && !string.IsNullOrEmpty(lstQuarterInfo[count].QuarterNumber))
{
quarterNumber = lstQuarterInfo[count].QuarterNumber;
}
lstAllottmentApplication[count].QuarterNumber = quarterNumber;
}
grdQuarters.DataSource = lstAllottmentApplication;
grdQuarters.DataBind();
}
private void bindAAN()
{
if (applicationid <= 0)
{
tblUser _usr = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
txtAAN.Text = _usr.AAN;
txtUsername.Text = _usr.fullName;
}
else
{
txtAAN.Text = AllotementApplications.GetApplication(applicationid).tblUser.AAN;
}
}
private void BindApplicationData()
{
tbAllotmentApplication appication = AllotementApplications.GetApplication(applicationid);
tblUser user = Users.getUserByAAN(appication.tblUser.AAN);
drpOffice.SelectedValue = user.BaseOfficeId.ToString();
drpQuarterCatergory.SelectedValue = appication.QuarterCategory.ToString();
txtDor.Text = user.DateOfRetirement.Value.ToShortDateString();
txtDoj.Text = user.DateOfJoining.Value.ToShortDateString();
txtAllotteeName.Text = user.AAN;
bindQuarter();
drpQuarterCatergory.Enabled = false;
drpOffice.Enabled = false;
drpDesignation.Enabled = false;
}
private void BindData()
{
tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
if (_user.tblRole.name.ToLower().Contains("entry"))
{
grdQuarters.DataSource = AllotementApplications.GetPendingApplications(ApplicationStatus.Pending, _user.BaseOfficeId.Value);
grdQuarters.DataBind();
}
else
{
grdQuarters.DataSource = AllotementApplications.GetPendingApplications(ApplicationStatus.Pending);
grdQuarters.DataBind();
}
}
private void bindAAN()
{
if (applicationid <= 0)
{
/*tblUser _usr = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
* txtAAN.Text = _usr.AAN;
* txtUsername.Text = _usr.fullName;
* if (_usr.BaseOfficeId.HasValue)
* drpOffice.SelectedValue = _usr.BaseOfficeId.Value.ToString();
* if (_usr.designation.HasValue)
* drpdesignations.SelectedValue = _usr.designation.Value.ToString();*/
}
else
{
txtAAN.Text = AllotementApplications.GetApplication(applicationid).tblUser.AAN;
}
}
protected void btnApplyNew_Click(object sender, EventArgs e)
{
tbAllotmentApplication application = AllotementApplications.GetApplication(Convert.ToInt64(applicationId));
if (application.Status == (int)ApplicationStatus.Verified)
{
lblStatus.Text = "You have already applied for the new allotment application, and your application is under process.";
}
else if (application.Status == (int)ApplicationStatus.Pending ||
application.Status == (int)ApplicationStatus.withdraw) //added on 30.12.2016 as per request from amrinder
{
//Change application status to verified
AllotementApplications.UpdateApplicationStaus(Convert.ToInt64(applicationId), ApplicationStatus.Verified);
lblStatus.Text = "Your application request is processed further, thanks for your application";
Response.Redirect("~/user/confirmation.aspx");
}
}
private void BindData()
{
tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
if (_user.Roleid == 1) //Admin
{
lblStatus.Text = "User applications";
pnlSearch.Visible = true;
}
if (pnlSearch.Visible)
{
_user.AAN = txtSearch.Text.Trim();
}
grdQuarters.DataSource = AllotementApplications.GetApplicationsByAAn(_user.AAN);
grdQuarters.DataBind();
}
protected void gridCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Allotte")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
// AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Allotted);
Response.Redirect("~/admin/Allottee.aspx?Applicationid=" + id + "&returnurl=admin/Prioritizeapplications.aspx");
}
else if (e.CommandName == "Possesed")
{
hdnSelected.Value = e.CommandArgument.ToString();
tblAllottee _allotte = Allottee.getAllotteByApplicationid(Convert.ToInt64(e.CommandArgument));
txtName.Text = AllotementApplications.GetApplication(Convert.ToInt64(e.CommandArgument)).tblUser.fullName;
txtQuarternumber.Text = _allotte.QuarterNumber;
pop.Show();
}
else if (e.CommandName == "Withdraw")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.withdraw);
Allottee.UpdateAllottementStatus(id, AllotementStatus.withdraw);
tblAllottee _allotte = Allottee.getAllotteByApplicationid(id);
if (_allotte != null)
{
long quarterid = _allotte.tblQuarter.Id;
_allotte.Status = (int)AllotementStatus.withdraw;
_allotte.DateOfwithdraw = DateTime.Now;
Allottee.Update(_allotte);
Quarters.UpdateQuarterStatus(_allotte.tblQuarter.Id, QuarterStatus.Vacant);
}
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Withdraw";
_userhistory.description = _user.Username + " has marked Withdraw application with " + id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
// Response.Redirect("~/admin/Allottee.aspx?Applicationid=" + id + "&returnurl=admin/Prioritizeapplications.aspx");
}
else if (e.CommandName == "CancelApplication")
{
//Move quarter to vacant list
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.rejected);
Allottee.UpdateAllottementStatus(id, AllotementStatus.vacant);
tblAllottee _allotte = Allottee.getAllotteByApplicationid(id);
if (_allotte != null)
{
long quarterid = _allotte.tblQuarter.Id;
_allotte.Status = (int)AllotementStatus.vacant;
_allotte.DateOfVacation = DateTime.Now;
Allottee.Update(_allotte);
Quarters.UpdateQuarterStatus(_allotte.tblQuarter.Id, QuarterStatus.Vacant);
}
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Cancel";
_userhistory.description = _user.Username + " has marked cancel application with " + id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
}
BindData();
//DataNavigateUrlFormatString="~/admin/Allottee.aspx?Applicationid={0}&returnurl=admin/Prioritizeapplications.aspx"
}
private void BindData()
{
grdQuarters.DataSource = AllotementApplications.GetPendingApplications(ApplicationStatus.Verified, Convert.ToInt64(drpQuarterCatergory.SelectedValue));
grdQuarters.DataBind();
}
protected void btnadd_Click(object sender, EventArgs e)
{
if (chkDeclaration.Checked == true)
{
validatedeclaration.Visible = false;
tbAllotmentApplication application = new tbAllotmentApplication();
if (applicationid <= 0)
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/submissionVerfication.xml"));
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (!Convert.ToBoolean(dt.Rows[0][0]))
{
lblmessage.Text = "Application submission has been closed";
lblmessage.Visible = true;
return;
}
}
/*application = AllotementApplications.GetApplicationByAAN(Users.getUserByUserName(HttpContext.Current.User.Identity.Name).AAN);
* if (application == null)
* {
* application = new tbAllotmentApplication();
* application.SubmissionDate = DateTime.Now;
* }
* else
* {
* lblmessage.Text = "Only one application can be submitted!";
* lblmessage.Visible = true;
* return;
* }*/
}
else
{
application = AllotementApplications.GetApplication(applicationid);
}
DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
DateTime.TryParse(txtDob.Text, out DateOfBirth);
DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
application.DateOfBirth = DateOfBirth;
application.DateOfjoining = DateOfjoining;
application.GradePay = drpGradePay.SelectedValue;
application.Name = txtUsername.Text;
application.Designation = Convert.ToInt64(drpdesignations.SelectedValue);
application.OfficeId = Convert.ToInt32(drpOffice.SelectedValue);
application.OtherQuarterAddress = txtAuditAddress.Text;
if ((txtQuartertype.SelectedValue != null) && (txtQuartertype.SelectedValue != "-1") && (txtQuartertype.SelectedValue != ""))
{
application.OtherQuarterType = Convert.ToInt32(txtQuartertype.SelectedValue);
}
application.OtherQuarterNumber = drpAllotedQuarter.SelectedValue;
application.MedicalCategory = Convert.ToInt32(ddlMedicalCategory.SelectedValue);
application.JobType = Convert.ToInt32(drpJobType.SelectedValue);
application.Sex = Convert.ToInt32(drpSex.SelectedValue);
application.Status = 0;
application.ContactNumber = txtContactNumber.Text;
application.SubmissionDate = DateTime.Now;
if (applicationid <= 0)
{
tblUser user = new tblUser();
//user.Username = txtUsername.Text;
user.EmailID = txtEmailAddress.Text;
user.EmployeeCode = txtPUCDACode.Text;
user.IsPasswordChanged = false;
user.fullName = txtUsername.Text;
user.AAN = Offices.GetOfficeCode(Convert.ToInt32(drpOffice.SelectedValue)) + user.EmployeeCode;
user.Username = user.AAN;
user.Password = "******";
user.BaseOfficeId = Convert.ToInt32(drpOffice.SelectedValue);
user.Roleid = 4;//by default viewer role
user.designation = Convert.ToInt64(drpdesignations.SelectedValue);
user.bIsDeleted = false;
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
//tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
user.DateOfJoining = DateOfjoining;
user.DateOfRetirement = dateofret;
user.AadharNumber = txtAadharNumber.Text.Trim();
user.PanNumber = txtPAN.Text.Trim();
var app = AllotementApplications.GetApplicationByAAN(user.AAN);
if (app != null)
{
lblmessage.Text = "Only one application can be submitted!";
lblmessage.Visible = true;
return;
}
Users.SaveUser(user);
string emailBody = "Your username/AAN = " + user.AAN + " and Password is " + user.Password;
try
{
SendmailMessage.SendMail(user.EmailID, "*****@*****.**", emailBody, "Account created");
}
catch (Exception ex)
{
}
//Send email here for user AAN and Password
//Send SMS
try
{
//new IntegratedMessageSender().SendMessage("NEW_USER", "Username:"******",Password:"******"The application cannot be saved, because specified category is not active";
lblmessage.Visible = true;
return;
}
application = AllotementApplications.SaveApplications(application);
if (Session["members"] != null)
{
List <tblMember> mem = (List <tblMember>)Session["members"];
foreach (tblMember meminfo in mem)
{
meminfo.ApplicationId = application.ID;
}
Tblmemberinfo.Save(mem);
Session["members"] = null;
}
lblmessage.Visible = true;
lblmessage.Text = "Information saved sucessfully";
Empty();
lblmessage.Font.Bold = true;
Response.Redirect("~/user/Confirmation.aspx");
}
else
{
validatedeclaration.Visible = true;
}
}
protected void gridCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Allotte")
{
long id;
string aan = string.Empty;
string quarterNumber = string.Empty;
Int64.TryParse(e.CommandArgument.ToString(), out id);
//AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Allotted);
tblAllottee _Allottee = null;
//if (id > 0)
//{
// _Allottee = Allottee.GetAllottee(id);
//}
//else
//{
var gridRow = ((LinkButton)e.CommandSource).NamingContainer as GridViewRow;
var hidAAN = gridRow.FindControl("hidAAN") as HiddenField;
aan = hidAAN.Value;
tblAllottee a = Allottee.GetAllotteeByAAN(aan);
if (a != null)
{
//lblMessage.Text = "User has already allotted quarter!";
//lblMessage.Visible = true;
//return;
_Allottee = a;
}
else
{
_Allottee = new tblAllottee();
}
Label lblQuarterNumber = gridRow.FindControl("lblQuarterNumber") as Label;
quarterNumber = lblQuarterNumber.Text;
tblQuarter quarter = Quarters.GetQuarter(quarterNumber);
if (quarter == null)
{
lblMessage.Text = "Quarter number selected is not valid";
lblMessage.Visible = true;
return;
}
else if (quarter.Status.HasValue && quarter.Status != (int)QuarterStatus.Vacant)
{
lblMessage.Text = "Quarter is not vacant!";
lblMessage.Visible = true;
return;
}
quarter.DateOfAllottement = DateTime.Now;
quarter.Status = (int)QuarterStatus.Alloted;
Quarters.Save(quarter);
//_Allottee = new tblAllottee();
//}
_Allottee.QuarterNumber = quarterNumber;
_Allottee.AAN = aan;
_Allottee.ApplicationId = id;
_Allottee.Status = (int)AllotementStatus.Allotted;
_Allottee.DateOfAllotement = DateTime.Now;
//_Allottee.OfficeId = Convert.ToInt32(drpOffice.SelectedValue);
//_Allottee.Designation =Convert.ToInt32( drpDesignation.SelectedValue);
//_Allottee.DateOfJoining = Convert.ToDateTime(txtDoj.Text);
//_Allottee.DateOfRetirement = Convert.ToDateTime(txtDor.Text);
//_Allottee.Name = txtAllotteeName.Text;
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Allotement";
_userhistory.description = _user.Username + " has allotted quarter " + _Allottee.QuarterNumber + " to user " + _Allottee.AAN;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
Allottee.Save(_Allottee);
if (id > 0)
{
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Allotted);
try
{
//SEND SMS
new IntegratedMessageSender().SendMessage("QUARTER_ALLOTTED", _Allottee.QuarterNumber, AllotementApplications.GetApplicationByAAN(aan).ContactNumber);
}
catch (Exception)
{
throw;
}
}
BindData();
///Response.Redirect("~/admin/Allottee.aspx?Applicationid="+id+"&returnurl=admin/Prioritizeapplications.aspx");
}
else if (e.CommandName == "Withdraw")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.withdraw);
BindData();
// AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.Pos);
}
else if (e.CommandName == "Allotte")
{
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
//AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.withdraw);
Response.Redirect("~/admin/Allottee.aspx?Applicationid=" + id + "&returnurl=admin/Prioritizeapplications.aspx");
}
else if (e.CommandName == "AllotteManual")
{
//Manual allocation
long id;
Int64.TryParse(e.CommandArgument.ToString(), out id);
//AllotementApplications.UpdateApplicationStaus(id, ApplicationStatus.withdraw);
Response.Redirect("~/admin/Allottee.aspx?Applicationid=" + id + "&returnurl=admin/Prioritizeapplications.aspx?selectedCategory=" + drpQuarterCatergory.SelectedValue);
}
//DataNavigateUrlFormatString="~/admin/Allottee.aspx?Applicationid={0}&returnurl=admin/Prioritizeapplications.aspx"
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (chkDeclaration.Checked == true)
{
validatedeclaration.Visible = false;
tbAllotmentApplication application;
if (applicationid <= 0)
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/submissionVerfication.xml"));
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (!Convert.ToBoolean(dt.Rows[0][0]))
{
lblmessage.Text = "Application submission has been closed";
lblmessage.Visible = true;
return;
}
}
application = AllotementApplications.GetApplication(applicationid);
if (application == null)
{
application = new tbAllotmentApplication();
application.SubmissionDate = DateTime.Now;
}
else
{
lblmessage.Text = "Only one application can be submitted!";
lblmessage.Visible = true;
return;
}
}
else
{
application = AllotementApplications.GetApplication(applicationid);
}
DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
DateTime.TryParse(txtDob.Text, out DateOfBirth);
DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
application.DateOfBirth = DateOfBirth;
application.DateOfjoining = DateOfjoining;
application.GradePay = drpGradePay.SelectedValue;
application.Name = txtUsername.Text;
application.Designation = Convert.ToInt64(drpdesignations.SelectedValue);
application.OfficeId = Convert.ToInt32(drpOffice.SelectedValue);
application.OtherQuarterAddress = txtAuditAddress.Text;
if ((txtQuartertype.SelectedValue != null) && (txtQuartertype.SelectedValue != "-1") && (txtQuartertype.SelectedValue != ""))
{
application.OtherQuarterType = Convert.ToInt32(txtQuartertype.SelectedValue);
}
application.MedicalCategory = Convert.ToInt32(ddlMedicalCategory.SelectedValue);
application.OtherQuarterNumber = drpAllotedQuarter.SelectedValue;
application.JobType = Convert.ToInt32(drpJobType.SelectedValue);
application.Sex = Convert.ToInt32(drpSex.SelectedValue);
//application.Status = 0;
application.ContactNumber = txtContactNumber.Text;
//if (applicationid <= 0)
{
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
tblUser user = Users.getUser(application.Userid.Value);
//user.Username = txtUsername.Text;
user.EmailID = txtEmailAddress.Text;
user.fullName = txtUsername.Text;
user.BaseOfficeId = Convert.ToInt32(drpOffice.SelectedValue);
user.Roleid = 4;//by default viewer role
user.designation = Convert.ToInt64(drpdesignations.SelectedValue);
user.EmployeeCode = txtPUCDACode.Text;
user.AadharNumber = txtAadharNumber.Text.Trim();
user.PanNumber = txtPAN.Text.Trim();
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
//tblUser _user = Users.getUserByUserName(HttpContext.Current.User.Identity.Name);
user.DateOfJoining = DateOfjoining;
user.DateOfRetirement = dateofret;
Users.SaveUser(user);
}
//else
//{
//}
application.Cast = drpcategory.SelectedItem.Text;
application.IsSublet = isSubletTrue.Checked;
application.IsDebarred = isDebarred.Checked;
//int quarterCategoryId = Convert.ToInt32(drpQuarterCategory.SelectedValue);
long quarterCategoryId = GradePay.GetQuarterCategoryByGradePay(Convert.ToInt32(drpGradePay.SelectedValue));
if (application.QuarterCategory != quarterCategoryId) //Previous category is different than the new one
{
//Put status of the application under pending state again, to be reviewed further
application.Status = 0;
//Delete the change requests taken by the user if any to changerequested state
//And when user category is changed
tblUser user = Users.getUser(application.Userid.Value);
var dataContext = new DataClassesDataContext();
tblChangeRequest changeRequestToUpdate = dataContext.tblChangeRequests
.Where(x => x.AAN.ToLower() == user.AAN.ToLower() &&
(x.Status == (int)ChangeRequestStatus.Pending ||
x.Status == (int)ChangeRequestStatus.Approved)).FirstOrDefault();
if (changeRequestToUpdate != null)
{
//changeRequestToUpdate.Status = (int)ChangeRequestStatus.Done;
changeRequestToUpdate.Status = (int)ChangeRequestStatus.Pending;
//dataContext.tblChangeRequests.DeleteOnSubmit(changeRequestToDelete);
dataContext.SubmitChanges();
}
}
application.QuarterCategory = quarterCategoryId;
if (isDebarred.Checked)
{
DateTime.TryParse(txtDebaredDate.Text, out DateOfDebared);
application.DebarredDate = DateOfDebared;
}
application.IsOtherAccomendation = isauditpooyes.Checked;
if (isauditpooyes.Checked)
{
application.OtherAllotteName = txtAuditAllotteName.Text;
application.OtherQuarterAddress = txtAuditAddress.Text;
application.OtherQuarterType = Convert.ToInt32(txtQuartertype.SelectedValue);
application.OtherQuarterNumber = drpAllotedQuarter.SelectedValue;
}
if (!IsQuarterCategoryActive(quarterCategoryId))
{
lblmessage.Text = "The application cannot be saved, because specified category is not active";
lblmessage.Visible = true;
return;
}
application = AllotementApplications.SaveApplications(application);
if (Session["members"] != null)
{
List <tblMember> mem = (List <tblMember>)Session["members"];
foreach (tblMember meminfo in mem)
{
meminfo.ApplicationId = application.ID;
}
Tblmemberinfo.Save(mem);
Session["members"] = null;
}
lblmessage.Visible = true;
lblmessage.Text = "Information saved sucessfully";
Empty();
lblmessage.Font.Bold = true;
if (!string.IsNullOrEmpty(Request["returnurl"]))
{
Response.Redirect("~/" + Request["returnurl"]);
}
else
{
Response.Redirect("~/user/Confirmation.aspx");
}
}
else
{
validatedeclaration.Visible = true;
}
}
private void BindApplicationData()
{
tbAllotmentApplication application = AllotementApplications.GetApplication(applicationid);
if (application != null)
{
//DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
//DateTime.TryParse(txtDob.Text, out DateOfBirth);
//DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
//DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
drpGradePay.SelectedValue = application.GradePay;
txtUsername.Text = application.Name;
if (application.Designation.HasValue)
{
drpdesignations.SelectedValue = application.Designation.Value.ToString();
}
if (application.OfficeId.HasValue)
{
drpOffice.SelectedValue = application.OfficeId.Value.ToString();
}
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.SelectedValue = Convert.ToString(application.OtherQuarterType);
drpAllotedQuarter.SelectedValue = application.OtherQuarterNumber;
if (application.JobType.HasValue)
{
drpJobType.SelectedValue = application.JobType.Value.ToString();
}
drpSex.SelectedValue = application.Sex.ToString();
ddlMedicalCategory.SelectedValue = application.MedicalCategory.ToString();
txtContactNumber.Text = application.ContactNumber;
//application.Status = 0;
//application.Userid = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).Id;
tblUser _user = Users.getUser(application.Userid.Value);
if (application.DateOfBirth.HasValue)
{
txtDob.Text = application.DateOfBirth.Value.ToShortDateString();
}
//txtPayBand.Text = application.QuarterNumber;
foreach (ListItem ino in drpcategory.Items)
{
if (!string.IsNullOrEmpty(application.Cast) && ino.Text.ToLower() == application.Cast.ToLower())
{
ino.Selected = true;
}
}
if (_user.DateOfJoining.HasValue)
{
txtEmployedfrom.Text = _user.DateOfJoining.Value.ToShortDateString();
}
if (_user.DateOfRetirement.HasValue)
{
txtDateOfRetirement.Text = _user.DateOfRetirement.Value.ToShortDateString();
}
txtAAN.Text = _user.AAN;
txtEmailAddress.Text = _user.EmailID;
txtPUCDACode.Text = _user.EmployeeCode;
txtAadharNumber.Text = _user.AadharNumber;
txtPAN.Text = _user.PanNumber;
//_user.DateOfJoining = DateOfjoining;
//_user.DateOfRetirement = dateofret;
if (application.IsSublet.HasValue)
{
isSubletTrue.Checked = application.IsSublet.Value;
}
if (!isSubletTrue.Checked)
{
isSubletFalse.Checked = true;
}
if (application.IsDebarred.HasValue)
{
isDebarred.Checked = application.IsDebarred.Value;
}
if (application.QuarterCategory.HasValue)
{
drpQuarterCategory.SelectedValue = application.QuarterCategory.Value.ToString();
}
if (isDebarred.Checked)
{
if (application.DebarredDate.HasValue)
{
txtDebaredDate.Text = application.DebarredDate.Value.ToShortDateString();
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showdebarred", "showbarredDate(1);", true);
}
else
{
isDebarredNO.Checked = true;
}
if (application.IsOtherAccomendation.HasValue)
{
isauditpooyes.Checked = application.IsOtherAccomendation.Value;
}
if (!isauditpooyes.Checked)
{
isauditpoono.Checked = true;
}
else
{
txtAuditAllotteName.Text = application.OtherAllotteName;
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.SelectedValue = Convert.ToString(application.OtherQuarterType);
drpAllotedQuarter.SelectedValue = application.OtherQuarterNumber;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showaudit", "showAudit(1);", true);
}
grdmembers.DataSource = Tblmemberinfo.GetMemberinfo(application.ID);
grdmembers.DataBind();
}
}
private void BindApplicationData()
{
tbAllotmentApplication application = AllotementApplications.GetApplication(applicationid);
if (application != null)
{
//DateTime DateOfBirth, DateOfjoining, DateOfDebared, dateofret;
//DateTime.TryParse(txtDob.Text, out DateOfBirth);
//DateTime.TryParse(txtEmployedfrom.Text, out DateOfjoining);
//DateTime.TryParse(txtDateOfRetirement.Text, out dateofret);
lblGradePay.Text = GradePay.GetPayGradesById(Convert.ToInt64(application.GradePay));
txtUsername.Text = application.Name;
if (application.Designation.HasValue)
{
lbldesignations.Text = Allottee.GetDesignationName(application.Designation.Value).ToString();
}
if (application.OfficeId.HasValue)
{
lblOffice.Text = Offices.GetOfficeName(application.OfficeId.Value).ToString();
}
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.Text = application.OtherQuarterNumber;
txtContactNumber.Text = application.ContactNumber;
if (application.JobType.Value == 0)
{
drpJobType.Text = "Permanent";
}
else
{
drpJobType.Text = "Temporary";
}
if (application.Sex.Value == 0)
{
lblSex.Text = "Female";
}
else
{
lblSex.Text = "Male";
}
tblUser _user = Users.getUser(application.Userid.Value);
if (application.DateOfBirth.HasValue)
{
txtDob.Text = application.DateOfBirth.Value.ToShortDateString();
}
lblcategory.Text = application.Cast;
if (_user.DateOfJoining.HasValue)
{
txtEmployedfrom.Text = _user.DateOfJoining.Value.ToShortDateString();
}
if (_user.DateOfRetirement.HasValue)
{
txtDateOfRetirement.Text = _user.DateOfRetirement.Value.ToShortDateString();
}
//_user.DateOfJoining = DateOfjoining;
//_user.DateOfRetirement = dateofret;
if (application.IsSublet.HasValue)
{
isSubletTrue.Checked = application.IsSublet.Value;
}
if (!isSubletTrue.Checked)
{
lblSublet.Text = "Yes";
isSubletFalse.Checked = true;
}
else
{
lblSublet.Text = "No";
}
if (application.IsDebarred.HasValue)
{
isDebarred.Checked = application.IsDebarred.Value;
}
if (application.QuarterCategory.HasValue)
{
lblQuarterCategory.Text = Quarters.GetQuarterCategoryName(application.QuarterCategory.Value).ToString();
}
if (isDebarred.Checked)
{
lblDebarred.Text = "Yes";
if (application.DebarredDate.HasValue)
{
txtDebaredDate.Text = application.DebarredDate.Value.ToShortDateString();
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showdebarred", "showbarredDate(1);", true);
}
else
{
lblDebarred.Text = "No";
isDebarredNO.Checked = true;
}
if (application.IsOtherAccomendation.HasValue)
{
isauditpooyes.Checked = application.IsOtherAccomendation.Value;
}
if (!isauditpooyes.Checked)
{
lblauditpooyes.Text = "No";
isauditpoono.Checked = true;
}
else
{
lblauditpooyes.Text = "Yes";
txtAuditAllotteName.Text = application.OtherAllotteName;
txtAuditAddress.Text = application.OtherQuarterAddress;
txtQuartertype.Text = application.OtherQuarterNumber;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "showaudit", "showAudit(1);", true);
}
grdmembers.DataSource = Tblmemberinfo.GetMemberinfo(application.ID);
grdmembers.DataBind();
}
}
protected void btnverify_Click(object sender, EventArgs e)
{
AllotementApplications.UpdateApplicationStaus(applicationid, ApplicationStatus.Verified);
Response.Redirect("~/" + Request["returnurl"]);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["applicationId"] == null)
{
Response.Redirect("~/user/application.aspx");
}
else if (Request["applicationId"] != null)
{
applicationId = Convert.ToString(Request["applicationId"]);
}
tbAllotmentApplication application = AllotementApplications.GetApplication(Convert.ToInt64(applicationId));
categoryId = application.QuarterCategory.Value;
if (!Page.IsPostBack)
{
tblUser user = Users.getUser(application.Userid.Value);
DateTime?dt = null;
//Check if user is debarred or deferred
if (Users.IsUserDeferred(user.Id, out dt))
{
Response.Redirect("~/user/notallowed.aspx");
}
if (Users.IsUserDebarred(user.Id, out dt))
{
Response.Redirect("~/user/notallowed.aspx?debar=true");
}
lblFullname.Text = user.fullName;
lblDesignation.Text = Users.GetUserDesignation(user.Id);
lblAllottedQuarter.Text = "N/A";
var allottee = Allottee.GetAllotteeByAAN(user.AAN);
if (allottee != null && (allottee.Status.Value == ((int)AllotementStatus.Possessed) || allottee.Status.Value == ((int)AllotementStatus.ChangeRequested)))
{
string allottedQuarter = allottee.QuarterNumber;
lblAllottedQuarter.Text = allottedQuarter;
}
if (application.QuarterCategory.HasValue && !Quarters.IsQuarterCategoryActive(application.QuarterCategory.Value))
{
submissionClosedPanel.Visible = true;
return;
}
else
{
//Quarter category is active
if (lblAllottedQuarter.Text == "N/A" || application.Status == (int)ApplicationStatus.Pending) //New allottment cases
{
if (application.MedicalCategory.HasValue && application.MedicalCategory.Value >= 0) //Medical grounds
{
applyForQuarterMedicalGroundsPanel.Visible = true;
btnNewAllottmentMedical.Enabled = true;
}
else
{
applyForQuarterPanel.Visible = true;
btnNewAllottment.Enabled = true;
}
}
else
{
if (application.MedicalCategory.HasValue && application.MedicalCategory.Value >= 0) //Medical grounds
{
applyForQuarterMedicalGroundsPanel.Visible = true;
btnChangeRequestMedical.Enabled = true;
}
else
{
applyForQuarterPanel.Visible = true;
btnChangeRequest.Enabled = true;
}
}
DataClassesDataContext dataContext = new DataClassesDataContext();
string aan = Users.getUserByUserName(HttpContext.Current.User.Identity.Name).AAN;
var _alreadyRequested = from _requested in dataContext.tblChangeRequests
where _requested.AAN == aan &&
(_requested.Status == (int)ChangeRequestStatus.Pending ||
_requested.Status == (int)ChangeRequestStatus.Approved)
select _requested;
if (_alreadyRequested.FirstOrDefault() != null)
{
var changeRequest = _alreadyRequested.FirstOrDefault();
pnlChangeRequestInformation.Visible = true;
btnChangeRequest.Enabled = false;
btnChangeRequestMedical.Enabled = false;
lblRequestID.Text = changeRequest.Id.ToString();
lblFirstPreference.Text = changeRequest.FirstPerference ?? "N/A";
lblSecondPreference.Text = changeRequest.SecondPerference ?? "N/A";
lblThirdPreference.Text = changeRequest.ThirdPerference ?? "N/A";
}
else
{
pnlChangeRequestInformation.Visible = false;
}
}
BindData();
}
changeRequests = new DataClassesDataContext().tblChangeRequests.ToList();
grdQuarters.RowDataBound += new GridViewRowEventHandler(grdQuarters_RowDataBound);
}
protected void btnadd_Click(object sender, EventArgs e)
{
tblAllottee _Allottee = null;
if (id > 0)
{
_Allottee = Allottee.GetAllottee(id);
}
else
{
tblAllottee a = Allottee.GetAllotteeByAAN(txtAllotteeName.Text);
if (a != null)
{
_Allottee = a;
//lblmessage.Text = "User has already allotted quarter!";
//lblmessage.Visible = true;
//return;
}
if (a == null)
{
_Allottee = new tblAllottee();
}
tblQuarter quarter = Quarters.GetQuarter(drpQuarter.SelectedValue);
if (quarter == null)
{
lblmessage.Text = "Please enter valid number";
lblmessage.Visible = true;
return;
}
else if (quarter.Status.HasValue && quarter.Status != (int)QuarterStatus.Vacant)
{
lblmessage.Text = "Quarter is not vacant!";
lblmessage.Visible = true;
return;
}
quarter.DateOfAllottement = DateTime.Now;
quarter.Status = (int)QuarterStatus.Alloted;
Quarters.Save(quarter);
//_Allottee = new tblAllottee();
}
_Allottee.QuarterNumber = drpQuarter.SelectedValue;
_Allottee.AAN = txtAllotteeName.Text;
_Allottee.ApplicationId = applicationid;
_Allottee.Status = btnAddUpdate.Text == "Add Change Request" ? (int)AllotementStatus.ChangeRequested : (int)AllotementStatus.Possessed;
_Allottee.DateOfAllotement = DateTime.Now;
//_Allottee.OfficeId = Convert.ToInt32(drpOffice.SelectedValue);
//_Allottee.Designation =Convert.ToInt32( drpDesignation.SelectedValue);
//_Allottee.DateOfJoining = Convert.ToDateTime(txtDoj.Text);
//_Allottee.DateOfRetirement = Convert.ToDateTime(txtDor.Text);
//_Allottee.Name = txtAllotteeName.Text;
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "Allotement";
_userhistory.description = _user.Username + " has allotted quarter " + _Allottee.QuarterNumber + " to user " + _Allottee.AAN;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
Allottee.Save(_Allottee);
if (applicationid > 0)
{
AllotementApplications.UpdateApplicationStaus(applicationid, btnAddUpdate.Text == "Add Change Request" ? ApplicationStatus.ChangeRequested : ApplicationStatus.Allotted);
}
if (!string.IsNullOrEmpty(Request["returnurl"]))
{
Response.Redirect("~/" + Request["returnurl"]);
}
else
{
Response.Redirect("~/admin/Allottees.aspx");
}
}
