public KeyValuePair <string, List <CargoRanking> > GetCargoRankingRecord(string recordID, int page, int pageSize, string whereCondition, string sort)
{
try
{
string FDt = whereCondition.Split('*')[0];
string TDt = whereCondition.Split('*')[1];
whereCondition = "";
CargoRanking CargoRanking = new CargoRanking();
SqlParameter[] Parameters =
{
new SqlParameter("@FromDt", Convert.ToDateTime(FDt)),
new SqlParameter("@ToDt", Convert.ToDateTime(TDt)),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
//,
//new SqlParameter("@PageNo", page),
//new SqlParameter("@PageSize", pageSize),
//new SqlParameter("@WhereCondition", whereCondition),
//new SqlParameter("@OrderBy", sort)
};
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetAgentCargoRanking", Parameters);
var CargoRankingList = ds.Tables[0].AsEnumerable().Select(e => new CargoRanking
{
AgentCode = Convert.ToString(e["AgentCode"].ToString()),
Agent = Convert.ToString(e["Agent"].ToString()),
Export = Convert.ToString(e["Export"].ToString()),
ERank = Convert.ToString(e["ERank"].ToString()),
Import = Convert.ToString(e["Import"].ToString()),
IRank = Convert.ToString(e["IRank"].ToString()),
Total = Convert.ToString(e["Total"].ToString()),
Rank = Convert.ToString(e["TRank"].ToString()),
Dt = Convert.ToString(e["Dt"].ToString())
});
return(new KeyValuePair <string, List <CargoRanking> >(ds.Tables[1].Rows[0][0].ToString(), CargoRankingList.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", "GetAgentCargoRanking"),
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 List <CargoRanking> SearchData(CargoRanking obj)
{
try
{
List <CargoRanking> lst = new List <CargoRanking>();
SqlParameter[] Parameters = { new SqlParameter("@FromDt", Convert.ToDateTime(obj.FromDate)),
new SqlParameter("@ToDt", Convert.ToDateTime(obj.ToDate)),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetAgentCargoRanking", Parameters);
if (ds != null && ds.Tables.Count > 0)
{
lst = ds.Tables[0].AsEnumerable().Select(e => new CargoRanking
{
AgentCode = Convert.ToString(e["AgentCode"].ToString()),
Agent = Convert.ToString(e["Agent"].ToString()),
Export = Convert.ToString(e["Export"].ToString()),
ERank = Convert.ToString(e["ERank"].ToString()),
Import = Convert.ToString(e["Import"].ToString()),
IRank = Convert.ToString(e["IRank"].ToString()),
Total = Convert.ToString(e["Total"].ToString()),
Rank = Convert.ToString(e["TRank"].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", "GetAgentCargoRanking"),
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;
}
}