public List <MovementRegister> SearchExportData(MovementRegister obj)
{
try
{
List <MovementRegister> lst = new List <MovementRegister>();
DateTime frdt, todt;
String tdt = "01/01/1900";
if (obj.FromDt == "")
{
frdt = Convert.ToDateTime(tdt);
}
else
{
frdt = Convert.ToDateTime(obj.FromDt);
}
if (obj.ToDt == "")
{
todt = Convert.ToDateTime(tdt);
}
else
{
todt = Convert.ToDateTime(obj.ToDt);
}
SqlParameter[] Parameters =
{
new SqlParameter("@FromDate", frdt),
new SqlParameter("@ToDate", todt),
new SqlParameter("@IsRFS", obj.ISRFS),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetExportMovementRegister", Parameters);
if (ds != null && ds.Tables.Count > 0)
{
lst = ds.Tables[0].AsEnumerable().Select(e => new MovementRegister
{
FlightNo = Convert.ToString(e["FlightNo"].ToString()),
FlightDate = Convert.ToString(e["FlightDate"].ToString()),
FlightStatus = Convert.ToString(e["FlightStatus"].ToString()),
MnfPc = Convert.ToString(e["MnfPieces"].ToString()),
MnfWt = Convert.ToString(e["MnfWt"].ToString()),
RFS = Convert.ToString(e["ISRFS"].ToString()),
OffPc = Convert.ToString(e["OffPieces"].ToString()),
OffWt = Convert.ToString(e["OffWt"].ToString()),
LBdPc = Convert.ToString(e["LBDPc"].ToString()),
CGOWt = Convert.ToString(e["CGOWt"].ToString()),
UpliftPc = Convert.ToString(e["UpliftPieces"].ToString()),
UpliftWt = Convert.ToString(e["UpliftWt"].ToString()),
AWB = Convert.ToString(e["AWB"].ToString()),
Dt = Convert.ToString(e["Dt"].ToString())
}).ToList();
}
return(lst);
}
catch (Exception ex)// (Exception ex)
{
// do something for error
DataSet dsError;
System.Data.SqlClient.SqlParameter[] ParametersError =
{
new System.Data.SqlClient.SqlParameter("@ErrorMessage", ex.Message),
new System.Data.SqlClient.SqlParameter("@ProcName", "GetExportMovementRegister"),
new System.Data.SqlClient.SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
dsError = CargoFlash.SoftwareFactory.Data.SqlHelper.ExecuteDataset(CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString, System.Data.CommandType.StoredProcedure, "ProcOfHandleErrors", ParametersError);
throw ex;
}
}
public KeyValuePair <string, List <MovementRegister> > GetMovementImportRegisterRecord(string recordID, int page, int pageSize, string whereCondition, string sort)
{
try
{
string FromDt = whereCondition.Split('*')[0];
string ToDt = whereCondition.Split('*')[1];
string reporttype = whereCondition.Split('*')[2];
string ISRFS = whereCondition.Split('*')[3];
DateTime frdt, todt;
whereCondition = "";
String tdt = "01/01/1900";
if (FromDt == "")
{
frdt = Convert.ToDateTime(tdt);
}
else
{
frdt = Convert.ToDateTime(FromDt);
}
if (ToDt == "")
{
todt = Convert.ToDateTime(tdt);
}
else
{
todt = Convert.ToDateTime(ToDt);
}
MovementRegister MovementRegister = new MovementRegister();
SqlParameter[] Parameters =
{
new SqlParameter("@FromDate", frdt),
new SqlParameter("@ToDate", todt),
new SqlParameter("@IsRFS", ISRFS),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetImportMovementRegister", Parameters);
var MovementRegisterList = ds.Tables[0].AsEnumerable().Select(e => new MovementRegister
{
FlightNo = Convert.ToString(e["FlightNo"].ToString()),
FlightDate = Convert.ToString(e["FlightDate"].ToString()),
ATA = Convert.ToString(e["ATA"].ToString()),
MovementNo = Convert.ToString(e["MovementNo"].ToString()),
MovementDate = Convert.ToString(e["MvtReceiveDate"].ToString()),
RFS = Convert.ToString(e["IsRFS"].ToString()),
Origin = Convert.ToString(e["Origin"].ToString()),
AWB = Convert.ToString(e["AWB"].ToString()),
CRP = Convert.ToString(e["CRP"].ToString()),
ULD = Convert.ToString(e["ULD"].ToString()),
DPY = Convert.ToString(e["DPY"].ToString()),
Pieces = Convert.ToString(e["Pieces"].ToString()),
ArivedWt = Convert.ToString(e["ArivedWt"].ToString()),
CargoWt = Convert.ToString(e["CargoWt"].ToString()),
Agent = Convert.ToString(e["Agent"].ToString()),
Dt = Convert.ToString(e["Dt"].ToString())
});
return(new KeyValuePair <string, List <MovementRegister> >(ds.Tables[1].Rows[0][0].ToString(), MovementRegisterList.AsQueryable().ToList()));
}
catch (Exception ex)// (Exception ex)
{
// do something for error
DataSet dsError;
System.Data.SqlClient.SqlParameter[] ParametersError =
{
new System.Data.SqlClient.SqlParameter("@ErrorMessage", ex.Message),
new System.Data.SqlClient.SqlParameter("@ProcName", "GetImportMovementRegister"),
new System.Data.SqlClient.SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
dsError = CargoFlash.SoftwareFactory.Data.SqlHelper.ExecuteDataset(CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString, System.Data.CommandType.StoredProcedure, "ProcOfHandleErrors", ParametersError);
throw ex;
}
}
