//private void RefreshControls()
//{
// Control[] cntlArr = { hdfLvAppID, hdfLvPackStartDate, hdfLvPackEndDate, hdfLTypeNature, hdfIsUpdate, hdfPreLTypeId,
// hdfIsOffdayCounted, hdfLAbbrName, hdfLEnjoyed, hdfLDates,hdfPreLDates,hdfLeavePakId,hdfPreLEnjoyed,
// hdfFiscalYrId,dtpLeaveStart,dtpLeaveEnd,ddlIsHalfDay,dtpResumeDate,ddlLTypeId,txtAvailable,
// txtLDurInDays,txtLTReason,txtAddrAtLeave,txtPhoneNo};
// Common.EmptyTextBoxValues(cntlArr);
// dtpLeaveStart.Enabled = true;
// dtpLeaveEnd.Enabled = true;
// this.OpenRecord();
//}
private void SaveData(string cmdType)
{
try
{
clsEmpTravel objTravel = new clsEmpTravel();
objTravel.TravelId = hdfTvAppID.Value;
objTravel.EmpId = txtEmpID.Text;
objTravel.AppDate = dtpAppDate.Text;
objTravel.VisitTo = txtVisitTo.Text;
objTravel.Purpose = txtPurpose.Text.Trim();
objTravel.TravelMode = ddlTravelMode.SelectedValue.ToString();
objTravel.DepartureDate = dtpTravelStart.Text;
objTravel.ReturnDate = dtpTravelEnd.Text;
objTravel.OfficeJoinDate = dtpResumeDate.Text;
objTravel.TotalDays = txtTotalDays.Text.Trim();
objTravel.TravelInstruction = txtInstruction.Text.Trim();
objTravel.TravelStatus = "P";
objTravel.InsertedBy = Session["USERID"].ToString();
objTravel.InsertedDate = Common.SetDate(DateTime.Now.ToString());
objTravel.ProjectId = ddlProject.SelectedValue;
DataTable dtSupervisor = objEmpInfoMgr.SelectEmpInfoSbuWise(hdfSupervisorId.Value.ToString(), "-1");
if (dtSupervisor.Rows.Count > 0)
{
string intStaff = dtSupervisor.Rows[0]["IsCountryDirector"] == null ? "" : dtSupervisor.Rows[0]["IsCountryDirector"].ToString();
if (intStaff == "Y") //country director
{
objTravel.TravelStatus = "R";
}
}
objTravelMgr.InsertEmpTravel(objTravel, hdfIsUpdate.Value.ToString(), "N");
this.SendMail(txtTotalDays.Text);
//this.GenerateReport();
//lblMsg.Text = objMail.RequestForTravelApproval(Session["EMPID"].ToString(), Session["USERNAME"].ToString(),
// Session["DESIGNATION"].ToString(), Session["LOCATION"].ToString(),
// Session["USERID"].ToString().Trim().ToUpper() == "ADMIN" ? "Y" : "N", hfSupervisor.Value.ToString(),
// hfSupervisorEmail.Value.ToString(), grConcernPerson, objTravel, ddlTravelType.SelectedItem.Text,
// ddlCurrency.SelectedItem.Text, ddlTravelMode.SelectedItem.Text, Session["COUNTRYDIRECTOR"].ToString().Trim(), txtInstruction.Text.Trim());
//lblMsg.Text = "Travel application Posted and Mailed to Supervisor";
this.EntryMode(false);
//this.OpenRecord();
}
catch (Exception exc)
{
throw exc;
}
}
public void InsertEmpTravel(clsEmpTravel clTravel, string strIsUpdate, string strIsDelete)
{
SqlCommand[] cmd = new SqlCommand[1];
cmd[0] = new SqlCommand("proc_Insert_EmpTravel");
cmd[0].CommandType = CommandType.StoredProcedure;
SqlParameter p_EmpId = cmd[0].Parameters.Add("EmpId", SqlDbType.Char);
p_EmpId.Direction = ParameterDirection.Input;
p_EmpId.Value = clTravel.EmpId;
SqlParameter p_TravelId = cmd[0].Parameters.Add("TravelId", SqlDbType.BigInt);
p_TravelId.Direction = ParameterDirection.Input;
p_TravelId.Value = clTravel.TravelId;
SqlParameter p_AppDate = cmd[0].Parameters.AddWithValue("AppDate", DBNull.Value);
p_AppDate.Direction = ParameterDirection.Input;
p_AppDate.IsNullable = true;
if (clTravel.AppDate != "")
{
p_AppDate.Value = Common.ReturnDate(clTravel.AppDate);
}
SqlParameter p_VisitTo = cmd[0].Parameters.Add("VisitTo", SqlDbType.VarChar);
p_VisitTo.Direction = ParameterDirection.Input;
p_VisitTo.Value = clTravel.VisitTo;
SqlParameter p_Purpose = cmd[0].Parameters.Add("Purpose", SqlDbType.VarChar);
p_Purpose.Direction = ParameterDirection.Input;
p_Purpose.Value = clTravel.Purpose;
SqlParameter p_DepartureDate = cmd[0].Parameters.AddWithValue("DepartureDate", DBNull.Value);
p_DepartureDate.Direction = ParameterDirection.Input;
p_DepartureDate.IsNullable = true;
if (clTravel.DepartureDate != "")
{
p_DepartureDate.Value = Common.ReturnDate(clTravel.DepartureDate);
}
SqlParameter p_ReturnDate = cmd[0].Parameters.AddWithValue("ReturnDate", DBNull.Value);
p_ReturnDate.Direction = ParameterDirection.Input;
p_ReturnDate.IsNullable = true;
if (clTravel.ReturnDate != "")
{
p_ReturnDate.Value = Common.ReturnDate(clTravel.ReturnDate);
}
SqlParameter p_OfficeJoinDate = cmd[0].Parameters.AddWithValue("OfficeJoinDate", DBNull.Value);
p_OfficeJoinDate.Direction = ParameterDirection.Input;
p_OfficeJoinDate.IsNullable = true;
if (clTravel.OfficeJoinDate != "")
{
p_OfficeJoinDate.Value = Common.ReturnDate(clTravel.OfficeJoinDate);
}
SqlParameter p_TotalDays = cmd[0].Parameters.Add("TotalDays", SqlDbType.Decimal);
p_TotalDays.Direction = ParameterDirection.Input;
if (clTravel.TotalDays != "")
{
p_TotalDays.Value = clTravel.TotalDays;
}
else
{
p_TotalDays.Value = "0";
}
SqlParameter p_TravelMode = cmd[0].Parameters.Add("TravelModeId", SqlDbType.BigInt);
p_TravelMode.Direction = ParameterDirection.Input;
p_TravelMode.Value = clTravel.TravelMode;
SqlParameter p_ProjectId = cmd[0].Parameters.Add("ProjectId", SqlDbType.BigInt);
p_ProjectId.Direction = ParameterDirection.Input;
p_ProjectId.Value = clTravel.ProjectId;
SqlParameter p_TravelInstruction = cmd[0].Parameters.Add("TravelInstruction", SqlDbType.VarChar);
p_TravelInstruction.Direction = ParameterDirection.Input;
p_TravelInstruction.Value = clTravel.TravelInstruction;
SqlParameter p_TravelStatus = cmd[0].Parameters.Add("TravelStatus", SqlDbType.Char);
p_TravelStatus.Direction = ParameterDirection.Input;
p_TravelStatus.Value = clTravel.TravelStatus;
SqlParameter p_InsertedBy = cmd[0].Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clTravel.InsertedBy;
SqlParameter p_InsertedDate = cmd[0].Parameters.AddWithValue("InsertedDate", DBNull.Value);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.IsNullable = true;
p_InsertedDate.Value = clTravel.InsertedDate;
//if (clTravel.InsertedDate != "")
// p_InsertedDate.Value = Common.ReturnDate(clTravel.InsertedDate);
SqlParameter p_IsUpdate = cmd[0].Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate.Direction = ParameterDirection.Input;
p_IsUpdate.Value = strIsUpdate;
SqlParameter p_IsDelete = cmd[0].Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = strIsDelete;
try
{
objDAL.MakeTransaction(cmd);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
cmd = null;
}
}
