public static List <ATTGeneralTippaniSummary> GetCommitteeTippaniDetail(int orgID, int tippaniID)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetCommitteeTippaniDetail(orgID, tippaniID);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["emp_id"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.CommitteeOrgID = int.Parse(row["comm_org_id"].ToString());
tippani.CommitteeID = int.Parse(row["committee_ID"].ToString());
tippani.CommitteeOrgName = row["comm_org_name"].ToString();
tippani.CommitteeName = row["COMMITTEE_NAME"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
private ATTGeneralTippaniSummary GetPostingDetail(int orgID, int tippaniID, double empID, string entryBy)
{
string strCreationDate;
int intPostID;
strCreationDate = this.ddlAvailablePost_Rqd.SelectedValue.ToString();
intPostID = int.Parse(strCreationDate.Substring(0, strCreationDate.IndexOf('/')));
strCreationDate = strCreationDate.Substring(strCreationDate.IndexOf('/') + 1);
ATTGeneralTippaniSummary posting = new ATTGeneralTippaniSummary();
if (this.grdPostList.SelectedIndex < 0)
{
posting.OrgID = orgID;
posting.TippaniID = tippaniID;
posting.TippaniSNO = 0;
posting.EmpID = empID;
posting.EmpName = this.EmpName;
posting.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.PostingList[this.grdPostList.SelectedIndex] as ATTGeneralTippaniSummary;
posting.OrgID = detail.OrgID;
posting.TippaniID = detail.TippaniID;
posting.TippaniSNO = detail.TippaniSNO;
posting.EmpID = detail.EmpID;
posting.EmpName = detail.EmpName;
if (this.PostingList[this.grdPostList.SelectedIndex].Action == "A")
{
posting.Action = "A";
}
else
{
posting.Action = "E";
}
}
posting.PostOrgID = int.Parse(this.ddlOrg_Rqd.SelectedValue);
posting.PostOrgName = this.ddlOrg_Rqd.SelectedItem.Text;
posting.DesID = int.Parse(this.ddlPost_Rqd.SelectedValue);
posting.PostDesName = this.ddlPost_Rqd.SelectedItem.Text;
posting.CreatedDate = strCreationDate;
posting.PostID = intPostID;
posting.PostName = this.ddlAvailablePost_Rqd.SelectedItem.Text;
posting.FromDate = txtPostingDate_Rdt.Text.Trim();
posting.ToDate = "";
posting.PostingTypeID = int.Parse(this.ddlPostingType_rqd.SelectedValue);
posting.PostingTypeName = this.ddlPostingType_rqd.SelectedItem.Text;
posting.JoiningDate = this.txtJoiningDate_Dt.Text.Trim();
posting.DecisionDate = this.txtDecisionDate_Dt.Text.Trim();
posting.LeaveDate = this.txtLeaveDate_Dt.Text;
posting.PostingRemark = this.txtPostingRemarks.Text;
//posting.Action = "A";
posting.EntryBy = entryBy;
return(posting);
}
public static List <ATTGeneralTippaniSummary> GetAwardTippaniDetail(int orgID, int tippaniID)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetAwardTippaniDetail(orgID, tippaniID);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["emp_id"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.Award = row["award"].ToString();
tippani.AwardDate = row["award_date"].ToString();
tippani.AwardRemark = row["awd_remark"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void grdPostList_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[0].Visible = false;
e.Row.Cells[2].Visible = false;
e.Row.Cells[3].Visible = false;
e.Row.Cells[4].Visible = false;
e.Row.Cells[5].Visible = false;
e.Row.Cells[14].Visible = false;
e.Row.Cells[15].Visible = false; //select command
if (e.Row.RowType == DataControlRowType.DataRow)
{
ATTGeneralTippaniSummary summary = e.Row.DataItem as ATTGeneralTippaniSummary;
System.Drawing.Color c = BLLGeneralTippani.GetActionColor(summary.Action);
e.Row.ForeColor = c;
if (summary.Action == "D")
{
((LinkButton)e.Row.Cells[16].Controls[0]).Text = "Undo";
}
else if (summary.Action == "N" || summary.Action == "A" || summary.Action == "E")
{
((LinkButton)e.Row.Cells[16].Controls[0]).Text = "Delete";
}
}
}
public static List <ATTGeneralTippaniSummary> GetLeaveTippaniDetail(int orgID, int tippaniID, int tippaniProcessID, LeaveMode mode)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetLeaveTippaniDetail(orgID, tippaniID, tippaniProcessID, mode);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["Emp_ID"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.ApplicationDate = row["APPL_DATE"].ToString();
tippani.LeaveType = row["LEAVE_TYPE_NAME"].ToString();
tippani.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString());
tippani.ReqFromDate = row["REQ_FROM_DATE"].ToString();
tippani.ReqToDate = row["REQ_TO_DATE"].ToString();
tippani.ReqNoOfDays = row["REQ_NO_OF_DAYS"].ToString() == "" ? 0 : int.Parse(row["REQ_NO_OF_DAYS"].ToString());
tippani.ReqReason = row["REQ_REASON"].ToString();
tippani.RecBy = row["REC_BY"].ToString() == "" ? 0 : double.Parse(row["REC_BY"].ToString());
tippani.RecDate = row["REC_DATE"].ToString();
tippani.RecFromDate = row["REC_FROM_DATE"].ToString();
tippani.RecToDate = row["REC_TO_DATE"].ToString();
tippani.RecNoOfDays = row["REC_NO_OF_DAYS"].ToString() == "" ? 0 : int.Parse(row["REC_NO_OF_DAYS"].ToString());
tippani.RecYesNo = row["REC_YES_NO"].ToString();
tippani.RecReason = row["REC_REASON"].ToString();
tippani.AppBy = row["APP_BY"].ToString() == "" ? 0 : double.Parse(row["APP_BY"].ToString());
tippani.AppDate = row["APP_DATE"].ToString();
tippani.AppFromDate = row["APP_FROM_DATE"].ToString();
tippani.AppToDate = row["APP_TO_DATE"].ToString();
tippani.AppNoOfDays = row["APP_NO_OF_DAYS"].ToString() == "" ? 0 : int.Parse(row["APP_NO_OF_DAYS"].ToString());
tippani.AppYesNo = row["APP_YES_NO"].ToString();
tippani.AppReason = row["APP_REASON"].ToString();
tippani.LeaveFY = row["LEAVE_FY"].ToString();
tippani.LeavePeriodUnit = row["LEAVE_PERIOD_UNIT"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public void SetVisitTipppaniDetail(ATTGeneralTippaniSummary summary)
{
//this.txtLocation_Rqd.Text = summary.TippaniDetail.VisitLocation;
//this.ddlCountry_Rqd.SelectedValue = summary.TippaniDetail.VisitCountryID.ToString();
//this.txtFromDate_Rdt.Text = summary.TippaniDetail.VisitFromDate;
//this.txtToDate_Rdt.Text = summary.TippaniDetail.VisitToDate;
//this.txtSubject_Rqd.Text = summary.TippaniDetail.VisitPurpose;
//this.txtRemarks_Rdt.Text = summary.TippaniDetail.VisitRemark;
//this.txtNote.Text = summary.Note;
//this.ddlTippaniStatus.SelectedValue = summary.ProcessStatus.ToString();
}
public static List <ATTGeneralTippaniSummary> GetPostingTippaniDetail(int orgID, int tippaniID, int subjectID, int tippaniProcessID)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetPostingTippaniDetail(orgID, tippaniID, subjectID, tippaniProcessID);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["emp_id"].ToString());
//tippani.TippaniSubjectID = int.Parse(row["tippani_subject_id"].ToString());
//tippani.TippaniText = row["tippani_text"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
//tippani.Note = row["note"].ToString();
//tippani.Note = "";
tippani.PostOrgID = int.Parse(row["post_org_id"].ToString());
tippani.PostOrgName = row["post_org_name"].ToString();
tippani.DesID = int.Parse(row["des_id"].ToString());
tippani.PostDesName = row["post_des_name"].ToString();
tippani.PostingTypeID = int.Parse(row["posting_type_id"].ToString());
tippani.PostingTypeName = row["posting_type_name"].ToString();
tippani.CreatedDate = row["created_date"].ToString();
tippani.PostID = int.Parse(row["post_id"].ToString());
//tippani.PostName = row["post_name"].ToString();
//tippani.PostID = 0;
tippani.PostName = "";
tippani.FromDate = row["post_from_date"].ToString();
tippani.ToDate = row["POST_TO_DATE"].ToString();
tippani.JoiningDate = row["joining_date"].ToString();
tippani.DecisionDate = row["decision_date"].ToString();
tippani.LeaveDate = row["leave_date"].ToString();
tippani.Action = "N";
lst.Add(tippani);
//tippani.ProcessStatus = (row["status"].ToString() == "") ? 0 : int.Parse(row["status"].ToString());
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void grdRecommendation_SelectedIndexChanged(object sender, EventArgs e)
{
this.grdLeave.SelectedIndex = -1;
this.lblDetail.Text = "";
ATTGeneralTippaniSummary leave = this.LeaveRec[this.grdRecommendation.SelectedIndex];
this.txtFromDate_Rdt.Text = leave.RecFromDate;
this.txtToDate_Rdt.Text = leave.RecToDate;
this.txtTotalDays_Rqd.Text = leave.RecNoOfDays.ToString();
this.txtRemark.Text = leave.RecReason;
this.chkRec.Checked = leave.RecYesNo == "Y" ? true : false;
this.hdnFromDate.Value = leave.OldFromDate;
this.hdnToDate.Value = leave.OldToDate;
}
private ATTGeneralTippaniSummary GetDeputationDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary deputation = new ATTGeneralTippaniSummary();
if (this.grdDeputation.SelectedIndex < 0)
{
deputation.OrgID = orgID;
deputation.TippaniID = tippaniID;
deputation.TippaniSNO = 0;
deputation.EmpID = empID;
deputation.EmpName = this.EmpName;
deputation.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.DeputationList[this.grdDeputation.SelectedIndex] as ATTGeneralTippaniSummary;
deputation.OrgID = detail.OrgID;
deputation.TippaniID = detail.TippaniID;
deputation.TippaniSNO = detail.TippaniSNO;
deputation.EmpID = detail.EmpID;
deputation.EmpName = detail.EmpName;
if (this.DeputationList[this.grdDeputation.SelectedIndex].Action == "A")
{
deputation.Action = "A";
}
else
{
deputation.Action = "E";
}
}
deputation.DepOrgID = 0;
deputation.DepDesID = 0;
deputation.DepCreatedDate = "";
deputation.DepPostID = 0;
deputation.DepFromDate = this.txtSendDate_Rdt.Text;
deputation.DepDecisionDate = this.txtDecisionDate_Rdt.Text;
deputation.DepToOrgID = int.Parse(this.ddlOrg_Rqd.SelectedValue);
deputation.DepToOrgName = this.ddlOrg_Rqd.SelectedItem.Text;
deputation.DepLeaveDate = this.txtLeaveDate_Rdt.Text;
deputation.DepResponsibility = this.txtResponsibility_Rqd.Text;
//deputation.Action = "A";
deputation.DepEntryBy = entryBy;
return(deputation);
}
protected void grdRequest_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int orgID = int.Parse(this.grdRequest.SelectedRow.Cells[0].Text);
int tippaniID = int.Parse(this.grdRequest.SelectedRow.Cells[2].Text);
int tippaniProcessID = int.Parse(this.grdRequest.SelectedRow.Cells[3].Text);
//ATTGeneralTippaniSummary summary = BLLGeneralTippani.GetVisitTippaniDetail(orgID, tippaniID, tippaniProcessID);
ATTGeneralTippaniSummary summary = new ATTGeneralTippaniSummary();
//this.lblTippaniText.Text = summary.TippaniText;
//this.lblName.Text = summary.EmpName;
//this.lblOrgName.Text = summary.OrgName;
//this.lblDesName.Text = summary.DesName;
//this.lblVisitSubject.Text = summary.TippaniDetail.VisitPurpose;
//this.lblVisitLocation.Text = summary.TippaniDetail.VisitLocation;
//this.lblVisitCountry.Text = summary.VisitCountryName;
//this.lblVisitRemark.Text = summary.TippaniDetail.VisitRemark;
//this.lblVisitFromDate.Text = summary.TippaniDetail.VisitFromDate;
//this.lblVisittoDate.Text = summary.TippaniDetail.VisitToDate;
//this.txtNote.Text = summary.Note;
if (summary.ProcessStatus > 0)
{
this.ddlDStatus_Rqd.SelectedValue = summary.ProcessStatus.ToString();
}
else
{
this.ddlDStatus_Rqd.SelectedIndex = -1;
}
if (this.hdnForm.Value == "0")
{
this.ddlDStatus_Rqd.Enabled = true;
this.btnSendBack.Enabled = true;
}
else if (this.hdnForm.Value == "1")
{
this.ddlDStatus_Rqd.Enabled = false;
this.btnSendBack.Enabled = false;
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
private ATTGeneralTippaniSummary GetLeaveDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary leave = new ATTGeneralTippaniSummary();
if (this.grdLeave.SelectedIndex < 0)
{
leave.OrgID = orgID;
leave.TippaniID = tippaniID;
leave.TippaniSNO = 0;
leave.EmpID = empID;
leave.EmpName = this.EmpName;
leave.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.LeaveList[this.grdLeave.SelectedIndex] as ATTGeneralTippaniSummary;
leave.OrgID = detail.OrgID;
leave.TippaniID = detail.TippaniID;
leave.TippaniSNO = detail.TippaniSNO;
leave.EmpID = detail.EmpID;
leave.EmpName = detail.EmpName;
if (this.LeaveList[this.grdLeave.SelectedIndex].Action == "A")
{
leave.Action = "A";
}
else
{
leave.Action = "E";
}
}
leave.LeaveTypeID = int.Parse(this.ddlLeaveType_Rqd.SelectedValue);
leave.LeaveType = this.ddlLeaveType_Rqd.SelectedItem.Text;
leave.ReqFromDate = this.txtFromDate_Rdt.Text;
leave.ReqToDate = this.txtToDate_Rdt.Text;
leave.ApplicationDate = this.txtApplicationDate_Rdt.Text;
leave.ReqNoOfDays = BLLGeneralTippani.GetDateDifference(leave.ReqToDate, leave.ReqFromDate) + 1;
leave.ReqReason = this.txtRemark.Text.Trim();
leave.LeaveLevel = LeaveMode.Request;
//leave.Action = "A";
leave.LeaveEntryBy = entryBy;
return(leave);
}
public ATTGeneralTippaniSummary GetVisitorDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary visit = new ATTGeneralTippaniSummary();
if (this.grdVisiterDetail.SelectedIndex < 0)
{
visit.OrgID = orgID;
visit.TippaniID = tippaniID;
visit.TippaniSNO = 0;
visit.EmpID = empID;
visit.EmpName = this.EmpName;
visit.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.VisitorList[this.grdVisiterDetail.SelectedIndex] as ATTGeneralTippaniSummary;
visit.OrgID = detail.OrgID;
visit.TippaniID = detail.TippaniID;
visit.TippaniSNO = detail.TippaniSNO;
visit.EmpID = detail.EmpID;
visit.EmpName = detail.EmpName;
if (this.VisitorList[this.grdVisiterDetail.SelectedIndex].Action == "A")
{
visit.Action = "A";
}
else
{
visit.Action = "E";
}
}
visit.VisitLocation = this.txtLocation_Rqd.Text;
visit.VisitCountryID = int.Parse(this.ddlCountry_Rqd.SelectedValue);
visit.VisitCountryName = this.ddlCountry_Rqd.SelectedItem.Text;
visit.VisitFromDate = this.txtFromDate_Rdt.Text;
visit.VisitToDate = this.txtToDate_Rdt.Text;
visit.VisitVehicle = this.txtVehicle_Rqd.Text;
visit.VisitPurpose = this.txtSubject_Rqd.Text;
visit.VisitRemark = this.txtRemarks.Text;
visit.VisitEntryBy = entryBy;
//visit.Action = "A";
return(visit);
}
protected void grdVisiterDetail_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ATTGeneralTippaniSummary summary = e.Row.DataItem as ATTGeneralTippaniSummary;
System.Drawing.Color c = BLLGeneralTippani.GetActionColor(summary.Action);
e.Row.ForeColor = c;
if (summary.Action == "D")
{
((LinkButton)e.Row.Cells[9].Controls[0]).Text = "Undo";
}
else if (summary.Action == "N" || summary.Action == "A" || summary.Action == "E")
{
((LinkButton)e.Row.Cells[9].Controls[0]).Text = "Delete";
}
}
}
private ATTGeneralTippaniSummary GetTrainingDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary training = new ATTGeneralTippaniSummary();
if (this.grdTraining.SelectedIndex < 0)
{
training.OrgID = orgID;
training.TippaniID = tippaniID;
training.TippaniSNO = 0;
training.EmpID = empID;
training.EmpName = this.EmpName;
training.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.TrainingList[this.grdTraining.SelectedIndex] as ATTGeneralTippaniSummary;
training.OrgID = detail.OrgID;
training.TippaniID = detail.TippaniID;
training.TippaniSNO = detail.TippaniSNO;
training.EmpID = detail.EmpID;
training.EmpName = detail.EmpName;
if (this.TrainingList[this.grdTraining.SelectedIndex].Action == "A")
{
training.Action = "A";
}
else
{
training.Action = "E";
}
}
training.TrnSubject = this.txtSubject_Rqd.Text;
training.TrnInstitutionID = int.Parse(this.ddlInstitution_Rqd.SelectedValue);
training.TrnInstitutionName = this.ddlInstitution_Rqd.SelectedItem.Text;
training.TrnFromDate = this.txtFromDate_Rdt.Text;
training.TrnToDate = this.txtToDate_Rdt.Text;
training.TrnRemark = this.txtRemark.Text;
//training.Action = "A";
training.TrnEntryBy = entryBy;
return(training);
}
public ATTGeneralTippaniSummary GetCommitteeMemberDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary comm = new ATTGeneralTippaniSummary();
if (this.grdCommittee.SelectedIndex < 0)
{
comm.OrgID = orgID;
comm.TippaniID = tippaniID;
comm.TippaniSNO = 0;
comm.EmpID = empID;
comm.EmpName = this.EmpName;
comm.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.CommitteeMemberList[this.grdCommittee.SelectedIndex] as ATTGeneralTippaniSummary;
comm.OrgID = detail.OrgID;
comm.TippaniID = detail.TippaniID;
comm.TippaniSNO = detail.TippaniSNO;
comm.EmpID = detail.EmpID;
comm.EmpName = detail.EmpName;
if (this.CommitteeMemberList[this.grdCommittee.SelectedIndex].Action == "A")
{
comm.Action = "A";
}
else
{
comm.Action = "E";
}
}
comm.CommitteeOrgID = int.Parse(this.ddlOrg_Rqd.SelectedValue);
comm.CommitteeOrgName = this.ddlOrg_Rqd.SelectedItem.Text;
comm.CommitteeID = 0;
comm.CommitteeName = this.txtCommittee_Rqd.Text;
comm.EntryBy = entryBy;
//visit.Action = "A";
return(comm);
}
private ATTGeneralTippaniSummary GetAwardDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary award = new ATTGeneralTippaniSummary();
if (this.grdAward.SelectedIndex < 0)
{
award.OrgID = orgID;
award.TippaniID = tippaniID;
award.TippaniSNO = 0;
award.EmpID = empID;
award.EmpName = this.EmpName;
award.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.AwardList[this.grdAward.SelectedIndex] as ATTGeneralTippaniSummary;
award.OrgID = detail.OrgID;
award.TippaniID = detail.TippaniID;
award.TippaniSNO = detail.TippaniSNO;
award.EmpID = detail.EmpID;
award.EmpName = detail.EmpName;
if (this.AwardList[this.grdAward.SelectedIndex].Action == "A")
{
award.Action = "A";
}
else
{
award.Action = "E";
}
}
award.Award = this.txtAward_Rqd.Text;
award.AwardDate = this.txtAwardDate_Rdt.Text;
award.AwardRemark = this.txtRemark.Text;
//award.Action = "A";
award.AwdEntryBy = entryBy;
return(award);
}
private ATTGeneralTippaniSummary GetPunishmentDetail(int orgID, int tippaniID, double empID, string entryBy)
{
ATTGeneralTippaniSummary punishment = new ATTGeneralTippaniSummary();
if (this.grdPunishment.SelectedIndex < 0)
{
punishment.OrgID = orgID;
punishment.TippaniID = tippaniID;
punishment.TippaniSNO = 0;
punishment.EmpID = empID;
punishment.EmpName = this.EmpName;
punishment.Action = "A";
}
else
{
ATTGeneralTippaniSummary detail = this.PunishmentList[this.grdPunishment.SelectedIndex] as ATTGeneralTippaniSummary;
punishment.OrgID = detail.OrgID;
punishment.TippaniID = detail.TippaniID;
punishment.TippaniSNO = detail.TippaniSNO;
punishment.EmpID = detail.EmpID;
punishment.EmpName = detail.EmpName;
if (this.PunishmentList[this.grdPunishment.SelectedIndex].Action == "A")
{
punishment.Action = "A";
}
else
{
punishment.Action = "E";
}
}
punishment.Punishment = this.txtPunishment_Rqd.Text;
punishment.PunishmentDate = this.txtPunishmentDate_Rdt.Text;
punishment.PunishmentRemark = this.txtRemark.Text;
//punishment.Action = "A";
punishment.PunEntryBy = entryBy;
return(punishment);
}
public static List <ATTGeneralTippaniSummary> GetVisitTippaniDetail(int orgID, int tippaniID, int tippaniProcessID)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetVisitTippaniDetail(orgID, tippaniID, tippaniProcessID);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["emp_id"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.VisitPurpose = row["purpose"].ToString();
tippani.VisitLocation = row["location"].ToString();
tippani.VisitCountryID = int.Parse(row["country"].ToString());
tippani.VisitCountryName = row["Country_nep_name"].ToString();
tippani.VisitFromDate = row["visit_from_date"].ToString();
tippani.VisitToDate = row["visit_to_date"].ToString();
tippani.VisitRemark = row["remarks"].ToString();
tippani.VisitVehicle = row["Vehicle"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTGeneralTippaniSummary> GetDeputationTippaniDetail(int orgID, int tippaniID)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetDeputationTippaniDetail(orgID, tippaniID);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["emp_id"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.DepToOrgID = int.Parse(row["dep_to_org_id"].ToString());
tippani.DepToOrgName = row["dep_to_org_name"].ToString();
tippani.DepFromDate = row["dep_from_date"].ToString();
tippani.DepDecisionDate = row["DEP_DECISION_DATE"].ToString();
tippani.DepLeaveDate = row["dep_leave_date"].ToString();
tippani.DepResponsibility = row["DEP_RESPONSIBLITY"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTGeneralTippaniSummary> GetTrainingTippaniDetail(int orgID, int tippaniID)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetTrainingTippaniDetail(orgID, tippaniID);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["emp_id"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.TrnSubject = row["trn_subject"].ToString();
tippani.TrnInstitutionID = int.Parse(row["trn_institution_ID"].ToString());
tippani.TrnInstitutionName = row["institution_name"].ToString();
tippani.TrnFromDate = row["trn_from_date"].ToString();
tippani.TrnToDate = row["trn_to_date"].ToString();
tippani.TrnRemark = row["trn_remark"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.grdRecommendation.SelectedIndex <= -1)
{
if (this.grdLeave.SelectedIndex <= -1)
{
this.lblStatusMessage.Text = "कृपया कर्मचारीको बिदाको अनुरोध बिबरण छन्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
}
if (this.chkRec.Checked == true)
{
if (this.txtFromDate_Rdt.Text.Trim() == "" || this.txtToDate_Rdt.Text.Trim() == "" || this.txtTotalDays_Rqd.Text.Trim() == "")
{
this.lblStatusMessage.Text = "कृपया सिफरिस गरेको कर्मचारीको लागी बिदाको सिफारिस बिबरण राख्नुहोस।";
this.programmaticModalPopup.Show();
return;
}
if (string.Compare(this.txtToDate_Rdt.Text.Trim(), this.txtFromDate_Rdt.Text.Trim()) < 0)
{
this.lblStatusMessage.Text = "बिदाको अवधि देखि मिति अवधि सम्म मिति भन्दा सानो हुनुपर्छ ।";
this.programmaticModalPopup.Show();
return;
}
if (string.Compare(this.hdnFromDate.Value.Trim(), this.txtFromDate_Rdt.Text.Trim()) > 0)
{
this.lblStatusMessage.Text = "सिफारिसको अवधि देखि मिति अनुरोधको अवधि देखि मिति भन्दा सानो हुन सक्दैन् ।";
this.programmaticModalPopup.Show();
return;
}
if (string.Compare(this.hdnToDate.Value.Trim(), this.txtToDate_Rdt.Text.Trim()) < 0)
{
this.lblStatusMessage.Text = "सिफारिसको अवधि सम्म मिति अनुरोधको अवधि सम्म मिति भन्दा ठुलो हुन सक्दैन् ।";
this.programmaticModalPopup.Show();
return;
}
}
ATTGeneralTippaniSummary leave = new ATTGeneralTippaniSummary();
GridViewRow row;
if (this.grdRecommendation.SelectedIndex < 0)
{
row = this.grdLeave.SelectedRow;
}
else
{
row = this.grdRecommendation.SelectedRow;
}
leave.OrgID = int.Parse(row.Cells[0].Text);
leave.TippaniID = int.Parse(row.Cells[1].Text);
leave.EmpID = double.Parse(row.Cells[2].Text);
leave.EmpName = row.Cells[3].Text;
if (this.grdRecommendation.SelectedIndex < 0)
{
bool exist = this.LeaveRec.Exists
(
delegate(ATTGeneralTippaniSummary l)
{
return(l.OrgID == leave.OrgID &&
l.TippaniID == leave.TippaniID &&
l.EmpID == leave.EmpID);
}
);
if (exist == true)
{
this.lblStatusMessage.Text = "यस कर्मचारीको बिदाको सिफारिस बिबरण दिइसकेको छ।";
this.programmaticModalPopup.Show();
return;
}
}
//leave.LeaveTypeID = int.Parse(this.ddlLeaveType_Rqd.SelectedValue);
//leave.LeaveType = this.ddlLeaveType_Rqd.SelectedItem.Text;
leave.RecFromDate = this.txtFromDate_Rdt.Text;
leave.RecToDate = this.txtToDate_Rdt.Text;
leave.OldFromDate = this.hdnFromDate.Value;
leave.OldToDate = this.hdnToDate.Value;
leave.RecDate = ""; //set nepali date from database
leave.RecNoOfDays = BLLGeneralTippani.GetDateDifference(leave.RecToDate, leave.RecFromDate) + 1;
leave.RecYesNo = this.chkRec.Checked == true ? "Y" : "N";
leave.RecReason = this.txtRemark.Text.Trim();
leave.LeaveLevel = LeaveMode.Recommend;
leave.Action = "A";
leave.RecBy = this.User.PID;
if (this.grdRecommendation.SelectedIndex < 0)
{
this.LeaveRec.Add(leave);
}
else
{
this.LeaveRec[this.grdRecommendation.SelectedIndex] = leave;
}
this.grdRecommendation.DataSource = this.LeaveRec;
this.grdRecommendation.DataBind();
this.ClearLeaveDetail();
}
