//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; } }