/// <summary>
/// This Method is a updates the Taxi Requests in Sharepoint list
/// </summary>
/// <param name="PReqNo_SI"></param>
/// <returns></returns>
/// <history>
/// Hari haran 07/05/2012 created
/// </history>
public TRT_OutputEntity updateTaxiRequestDetails_SI(TRT_InputEntity TRT_EntrySI)
{
try
{
logger.Debug("TaxiRequest Interface: updateTaxiRequestDetails_SI() called");
logger.DebugFormat("Input parameter Location ID : {0} ", TRT_EntrySI.empNo);
TRT_BAL updateTRD_BAL = new TRT_BAL();
return (updateTRD_BAL.updateTaxiRequestDetails_BAL(TRT_EntrySI));
}
catch (SqlException dbEx)
{
logger.Error("Exception At TRTInterface - updateTaxiRequestDetails_SI : " + dbEx.Message.ToString());
logger.Error("TaxiRequest Interface: updateTaxiRequestDetails_SI() returning error");
throw dbEx;
}
catch (Exception ex)
{
logger.Error("Exception At TRTInterface - updateTaxiRequestDetails_SI : " + ex.Message.ToString());
logger.Error("TaxiRequest Interface: updateTaxiRequestDetails_SI() returning error");
throw ex;
}
}
/// <summary>
/// This function fetches the Location Details from the Sharepoint web service
/// </summary>
/// <param name="PST_InputEntity"></param>
/// <returns>
/// <paramref name="PST_OutputEntity"/>
/// </returns>
/// <history>
/// Hari haran 07/05/2012 created
/// </history>
///
public TRT_OutputEntity updateTaxiRequestDetails_DAL_New(TRT_InputEntity TRT_EntryDAL)
{
logger.Debug("TaxiRequest_DAL: updateTaxiRequestDetails_DAL_New() called");
try
{
string flag = string.Empty;
TRT_OutputEntity Result = new TRT_OutputEntity();
string empDetailXmlString = TaxiWebService.GetEmployeeDetails(TRT_EntryDAL.empNo);
XmlDocument xmlEmpDoc = new XmlDocument();
xmlEmpDoc.LoadXml(empDetailXmlString);
//XmlNode root = xmlDoc.DocumentElement;
//XmlNode AllocCCode = root.SelectSingleNode("/NewDataSet/Projects");
//GeneralInformationNode.SelectSingleNode("ProjectId").InnerText;
XmlNode EmpNode;
EmpNode = xmlEmpDoc.SelectSingleNode("/NewDataSet/Employees");
if (EmpNode == null)
{
Result.statusFlag = 1;
Result.statusMsg = TRT_Constants.InvalidEmpID;
}
else
{
string EmpName = EmpNode.SelectSingleNode("employeename").InnerText;
string OrgUnit = EmpNode.SelectSingleNode("DeptName").InnerText;
string Supervisor= EmpNode.SelectSingleNode("SupervisorName").InnerText;
string SupervisorMailID = EmpNode.SelectSingleNode("SupervisorMailID").InnerText;
string EmpMailID = EmpNode.SelectSingleNode("EmpEmailID").InnerText;
string ReportTime = TRT_EntryDAL.hhTime + ":" + TRT_EntryDAL.mmTime;
TaxiSPService.Credentials = new NetworkCredential("bgh29309", "Password1", "asian");
XmlDocument xmlDoc = new XmlDocument();
TaxiSPService.Url = "http://awstage.intra.aricent.com/sites/applications/TaxiRequest/_vti_bin/Lists.asmx";
string listName = "TaxiRequestDetails";
//string viewName = "{7137FFF8-48FF-4C69-8C76-0E3BBD1EA7F9}";
//string rowLimit = "150";
System.Xml.XmlNode ndListView = TaxiSPService.GetListAndView(listName, "");
string strListID = ndListView.ChildNodes[0].Attributes["Name"].Value;
string strViewID = ndListView.ChildNodes[1].Attributes["Name"].Value;
/*Create an XmlDocument object and construct a Batch element and its
attributes. Note that an empty ViewName parameter causes the method to use the default view. */
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
System.Xml.XmlElement batchElement = doc.CreateElement("Batch");
batchElement.SetAttribute("OnError", "Continue");
batchElement.SetAttribute("ListVersion", "1");
batchElement.SetAttribute("ViewName", strViewID);
/*Specify methods for the batch post using CAML. To update or delete,
specify the ID of the item, and to update or add, specify
the value to place in the specified column.*/
XmlNode listXml = TaxiSPService.GetList(listName);
batchElement.InnerXml = "<Method ID='1' Cmd='New'>" +
"<Field Name='EmployeeNumber'>" + TRT_EntryDAL.empNo + "</Field>" +
"<Field Name='Title'>" + EmpName + "</Field>" +
"<Field Name='OUCode'>" + OrgUnit + "</Field>" +
"<Field Name='ChargeCode'>" + TRT_EntryDAL.chargeCode + "</Field>" +
"<Field Name='PurposeCode'>" + TRT_EntryDAL.purpose + "</Field>" +
"<Field Name='VehcileType'>" + TRT_EntryDAL.vehicleType + "</Field>" +
"<Field Name='PlotCode'>" + TRT_EntryDAL.plot + "</Field>" +
"<Field Name='Requireddate'>" + TRT_EntryDAL.reqDate + "</Field>" +
"<Field Name='FromPlace'>" + TRT_EntryDAL.fromPlace + "</Field>" +
"<Field Name='ToPlace'>" + TRT_EntryDAL.toPlace + "</Field>" +
"<Field Name='LandMark'>" + TRT_EntryDAL.landmark + "</Field>" +
"<Field Name='ContactNo'>" + TRT_EntryDAL.contactNum + "</Field>" +
"<Field Name='FlightDetails'>" + TRT_EntryDAL.flightDetails + "</Field>" +
"<Field Name='Comments'>" + TRT_EntryDAL.comments + "</Field>" +
//"<Field Name='Minutes'>" + "SBU" + "</Field>" +
"<Field Name='Duration'>" + TRT_EntryDAL.duration + "</Field>" +
"<Field Name='RowStatus'>" + ReportTime + "</Field>" +
"<Field Name='LocationCode'>" + TRT_EntryDAL.location + "</Field>" +
"<Field Name='Approved_x0020_By'>" + Supervisor + "</Field>" +
"</Method>";
/*Update list items. This example uses the list GUID, which is recommended,
but the list display name will also work.*/
XmlNode opRes = TaxiSPService.UpdateListItems(strListID, batchElement);
flag = opRes.InnerText;
if (flag.CompareTo("0x00000000") == 0)
{
Result.statusFlag = 0;
Result.statusMsg = TRT_Constants.Success;
logger.Info("In Success case : Flag = " + Result.statusFlag.ToString());
logger.Info("In Success case : Message = " + Result.statusMsg);
string mailBody = string.Format(TRT_Constants.mail_BodyFormat, TRT_EntryDAL.empNo, EmpName, OrgUnit, Supervisor, TRT_EntryDAL.chargeCode,
TRT_EntryDAL.purpose, TRT_EntryDAL.vehicleType, TRT_EntryDAL.reqDate,TRT_EntryDAL.fromPlace, TRT_EntryDAL.toPlace, TRT_EntryDAL.plot,
TRT_EntryDAL.flightDetails, ReportTime, TRT_EntryDAL.duration, TRT_EntryDAL.landmark, TRT_EntryDAL.contactNum, TRT_EntryDAL.comments,
System.DateTime.Today.ToString("dd/MM/yyyy HH:mm:ss"));
webServiceExHandling.Send_Email(TRT_Constants.Email_Dic, mailBody);
}
else
{
Result.statusFlag = 1;
Result.statusMsg = TRT_Constants.Error;
logger.Error("Flag = " + Result.statusFlag.ToString());
logger.Error("Message = " + Result.statusMsg);
}
}
logger.Debug("TaxiRequest_DAL: updateTaxiRequestDetails_DAL_New() Stop");
return Result;
}
catch (SqlException dbEx)
{
logger.Error("Exception Occured At TRT_DAL - updateTaxiRequestDetails_DAL_New");
logger.Error("Exception Code : " + dbEx.ErrorCode.ToString());
logger.Error("Exception Description : " + dbEx.Message.ToString());
logger.Error("TaxiRequest_DAL: updateTaxiRequestDetails_DAL_New() Stop");
//tsTrans.Rollback();
throw dbEx;
}
catch (Exception ex)
{
logger.Error("Exception Occured At TRT_DAL - updateTaxiRequestDetails_DAL_New : " + ex.Message.ToString());
logger.Error("TaxiRequest_DAL: updateTaxiRequestDetails_DAL_New() Stop");
// tsTrans.Rollback();
//throw new myCustomException(31, ex.Message);
throw ex;
}
}
/// <summary>
/// This function fetches the Location Details from the Sharepoint web service
/// </summary>
/// <param name="PST_InputEntity"></param>
/// <returns>
/// <paramref name="PST_OutputEntity"/>
/// </returns>
/// <history>
/// Hari haran 07/05/2012 created
/// </history>
///
public TRT_OutputEntity updateTaxiRequestDetails_DAL(TRT_InputEntity TRT_EntryDAL)
{
databaseLayer dbConStr = new databaseLayer();
string ConnStr = dbConStr.connectionInfo;
logger.Debug("Connection string : " + ConnStr);
SqlConnection Conn = new SqlConnection(ConnStr);
if (Conn.State == System.Data.ConnectionState.Closed)
{
Conn.Open();
logger.Debug("Connection Status opened ");
}
logger.Info("Connetion to the database established");
try
{
int flag = 0;
string reportTime = TRT_EntryDAL.hhTime.ToString() + ":" + TRT_EntryDAL.mmTime.ToString();
string Query = "INSERT INTO [AricentMobileAppDB].[dbo].[TaxiReqDetails]";
Query += "([EmpNo],[Location],[Plot],[Purpose],[VehicleType],[ChargeCode],[FromPlace],[ToPlace],[Landmark],[ContactNo],[FlightDetails],[Comments],[RequiredDate],[ReportTime],[Duration])";
Query += "VALUES(@EmpNo,@Location,@Plot,@Purpose,@VehicleType,@ChargeCode,@FromPlace,@ToPlace,@Landmark,@ContactNo,@FlightDetails,@Comments,@RequiredDate,@ReportTime,@Duration)";
SqlCommand cmd = new SqlCommand();
cmd.Connection = Conn;
cmd.CommandText = Query;
cmd.Parameters.AddWithValue("@EmpNo", TRT_EntryDAL.empNo);
cmd.Parameters.AddWithValue("@Location", TRT_EntryDAL.location);
cmd.Parameters.AddWithValue("@Plot", TRT_EntryDAL.plot);
cmd.Parameters.AddWithValue("@Purpose", TRT_EntryDAL.purpose);
cmd.Parameters.AddWithValue("@VehicleType", TRT_EntryDAL.vehicleType);
cmd.Parameters.AddWithValue("@ChargeCode", TRT_EntryDAL.chargeCode);
cmd.Parameters.AddWithValue("@FromPlace", TRT_EntryDAL.fromPlace);
cmd.Parameters.AddWithValue("@ToPlace", TRT_EntryDAL.toPlace);
cmd.Parameters.AddWithValue("@Landmark", TRT_EntryDAL.landmark);
cmd.Parameters.AddWithValue("@ContactNo", TRT_EntryDAL.contactNum);
cmd.Parameters.AddWithValue("@FlightDetails", TRT_EntryDAL.flightDetails);
cmd.Parameters.AddWithValue("@Comments", TRT_EntryDAL.comments);
cmd.Parameters.AddWithValue("@RequiredDate", TRT_EntryDAL.reqDate);
cmd.Parameters.AddWithValue("@ReportTime", "20:00");
cmd.Parameters.AddWithValue("@Duration", TRT_EntryDAL.duration);
flag = cmd.ExecuteNonQuery();
TRT_OutputEntity Result = new TRT_OutputEntity();
if (flag == 1)
{
Result.statusFlag = 0;
Result.statusMsg = TRT_Constants.Success;
string mailBody = string.Format(TRT_Constants.mail_BodyFormat,TRT_EntryDAL.empNo,TRT_EntryDAL.location);
webServiceExHandling.Send_Email(TRT_Constants.Email_Dic, mailBody);
}
else
{
Result.statusFlag = 1;
Result.statusMsg = TRT_Constants.Error;
}
return Result;
}
catch (SqlException dbEx)
{
logger.Fatal("Exception Occured At TRT_DAL - updateTaxiRequestDetails_DAL");
logger.Debug("Exception Code : " + dbEx.ErrorCode.ToString());
logger.Debug("Exception Description : " + dbEx.Message.ToString());
logger.Error("Error : updateTaxiRequestDetails_DAL Stop");
//tsTrans.Rollback();
throw dbEx;
}
catch (Exception ex)
{
logger.Fatal("Exception Occured At TRT_DAL - updateTaxiRequestDetails_DAL : " + ex.Message.ToString());
logger.Error("Error : updateTaxiRequestDetails_DAL Stop");
// tsTrans.Rollback();
//throw new myCustomException(31, ex.Message);
throw ex;
}
finally
{
logger.Debug("Connection to the database Closed ");
Conn.Dispose();
}
}
public TRT_OutputEntity updateTaxiRequestDetails(TRT_InputEntity TRT_Entry)
{
logger.Debug("Service: updateTaxiRequestDetails() called");
logger.InfoFormat("Input parameter Employee ID : {0} ", TRT_Entry.empNo);
try
{
TRT_OutputEntity result = new TRT_OutputEntity();
TRTInterface updateTRD_SI = new TRTInterface();
result = updateTRD_SI.updateTaxiRequestDetails_SI(TRT_Entry);
return result;
}
catch (SqlException ex)
{
webServiceExHandling.ExceptionLog(ex);
//string mailBody = string.Format(PST_Constants.mail_BodyFormat,System.DateTime.Now.ToString("F"),transId,ex.TargetSite.ToString(),ex.ToString());
//webServiceExHandling.Send_Email(PST_Constants.Email_Dic, mailBody);
webServiceExHandling.Send_Email(TRT_Constants.Email_Dic, "Testing");
TRT_OutputEntity Error = new TRT_OutputEntity();
Error.statusFlag = ex.ErrorCode;
string expCode = ExpType(ex);
Error.statusMsg = TRT_Constants.cnfgErrMessages[expCode];
logger.Error("ErrorCode = " + Error.statusFlag.ToString());
logger.Error("ErrorMessage = " + Error.statusMsg);
logger.Error("Service: updateTaxiRequestDetails() returning error");
return Error;
}
catch (Exception ex)
{
webServiceExHandling.ExceptionLog(ex);
//string mailBody = string.Format(SCT_Constants.mail_BodyFormat, System.DateTime.Now.ToString("F"), PReqNo, ex.TargetSite.ToString(), ex.ToString());
//webServiceExHandling.Send_Email(PST_Constants.Email_Dic, mailBody);
TRT_OutputEntity Error = new TRT_OutputEntity();
Error.statusFlag = 1;
Error.statusMsg = TRT_Constants.Error;
logger.Error("ErrorCode = " + Error.statusFlag.ToString());
logger.Error("ErrorMessage = " + Error.statusMsg);
logger.Error("Service: updateTaxiRequestDetails() returning error");
return Error;
}
}
/// <summary>
/// This Method validates the input parameter for the searchCriteria function
/// </summary>
/// <param name="searchCriteria_BAL"></param>
/// <returns></returns>
/// <history>
/// Hari haran 07/05/2012 created
/// </history>
///
int validate_trtParam(TRT_InputEntity TRT_EntryBAL)
{
int flag = 0;
logger.Debug("TaxiRequest_BAL: validate_trtParam() called");
if (string.IsNullOrEmpty(TRT_EntryBAL.empNo))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.location))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.plot))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.purpose))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.vehicleType))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.location))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.chargeCode))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.fromPlace))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.toPlace))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.comments))
{
flag = 1;
return flag;
}
if (string.IsNullOrEmpty(TRT_EntryBAL.reqDate))
{
flag = 1;
return flag;
}
if (TRT_EntryBAL.hhTime > 24 || TRT_EntryBAL.hhTime < 0)
{
flag = 1;
return flag;
}
if (TRT_EntryBAL.mmTime > 60 || TRT_EntryBAL.mmTime < 0)
{
flag = 1;
return flag;
}
if (TRT_EntryBAL.duration == 0)
{
flag = 1;
return flag;
}
logger.Debug("TaxiRequest_BAL: validate_trtParam() Stop");
return flag;
}
//***************************************************************************************************
public TRT_OutputEntity updateTaxiRequestDetails_BAL(TRT_InputEntity TRT_EntryBAL)
{
try
{
logger.Debug("TaxiRequest_BAL: updateTaxiRequestDetails_BAL() called");
logger.DebugFormat("Input parameter Employee ID : {0} ", TRT_EntryBAL);
int validate_trtParamFlag = 0;
validate_trtParamFlag = validate_trtParam(TRT_EntryBAL);
if (validate_trtParamFlag == 1)
{
TRT_OutputEntity Error = new TRT_OutputEntity();
Error.statusFlag = 1;
Error.statusMsg = TRT_Constants.Invalid;
logger.Error("Error in input parameter values");
logger.Error("ErrorCode = " + Error.statusFlag.ToString());
logger.Error("ErrorMessage = " + Error.statusMsg);
logger.Error("TaxiRequest_BAL: authenticateUser_SI() Stop");
return Error;
}
else
{
TRT_DAL getLD_BAL = new TRT_DAL();
return (getLD_BAL.updateTaxiRequestDetails_DAL_New(TRT_EntryBAL));
}
}
catch (SqlException dbEx)
{
logger.Error("Exception At BAL - updateTaxiRequestDetails_BAL : " + dbEx.Message.ToString());
logger.Error("Method - updateTaxiRequestDetails_BAL Stop");
throw dbEx;
}
catch (Exception ex)
{
logger.Error("Exception At BAL - updateTaxiRequestDetails_BAL : " + ex.Message.ToString());
logger.Error("Method : updateTaxiRequestDetails_BAL Stop");
throw ex;
}
}
