public string UCRUHF(string ULDSNo)
{
try
{
DataSet ds = new DataSet();
SqlParameter[] Parameters = { new SqlParameter("@UTUTSNo", ULDSNo) };
ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_DocumentFILENAME", Parameters);
FlightOpenService fos = new FlightOpenService();
return(fos.DStoJSON(ds));
}
catch (Exception ex)//
{
throw ex;
}
}
public string GetReceipt()
{
try
{
List <string> str = new List <string>();
SqlParameter[] Parameters = { new SqlParameter("@SNo", 0), new SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) };
DataSet ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_LUCReceipt", Parameters);
DataColumn newColumn = new DataColumn("AirportCode", typeof(System.String));
newColumn.DefaultValue = ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportCode.ToString().ToUpper();
ds.Tables[0].Columns.Add(newColumn);
DataColumn NC = new DataColumn("UserName", typeof(System.String));
NC.DefaultValue = ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserName.ToString().ToUpper();
ds.Tables[0].Columns.Add(NC);
FlightOpenService fos = new FlightOpenService();
return(fos.DStoJSON(ds));
}
catch (Exception ex)//
{
throw ex;
}
}
