public ResponseCollectionModel <Rating> PendingPostRatingByUserId(long userId)
{
var result = new ResponseCollectionModel <Rating>();
var dt = this.instance.PendingPostRatingByUserId(userId);
result.Response = DataAccessUtility.ConvertToList <Rating>(dt);
result.Status = Constants.WebApiStatusOk;
return(result);
}
public ResponseCollectionModel <PostStats> GetBiddingStatsByUserId(long userId)
{
var dt = this.instanceBidding.GetBiddingStatsByUserId(userId);
var result = new ResponseCollectionModel <PostStats>();
result.Response = DataAccessUtility.ConvertToList <PostStats>(dt);;
result.Status = Constants.WebApiStatusOk;
return(result);
}
public ResponseCollectionModel <PostStatusList> GetPostingStatusByUserId(long userId, Int16 PostStatus)
{
var result = new ResponseCollectionModel <PostStatusList>();
var dt = this.instance.GetPostingStatusByUserId(userId, PostStatus);
result.Response = DataAccessUtility.ConvertToList <PostStatusList>(dt);
result.Status = Constants.WebApiStatusOk;
return(result);
}
public ResponseCollectionModel <OrderList> GetPostingOrderByUserId(long userId, int Status)
{
var response = new ResponseCollectionModel <OrderList>();
var dt = this.instance.GetPostingOrderByUserId(userId, Status);
var lstbidding = DataAccessUtility.ConvertToList <OrderList>(dt);
response.Response = lstbidding;
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseSingleModel <Product> GetById(long productId)
{
var response = new ResponseSingleModel <Product>();
var dt = this.instance.GetById(productId);
response.Response = DataAccessUtility.ConvertToList <Product>(dt)[0];
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseSingleModel <ProductInstallDetails> GetInstallProductById(long DtlProductId, long productId, long vehicleId)
{
var response = new ResponseSingleModel <ProductInstallDetails>();
var dt = this.instance.GetInstallProductById(DtlProductId, productId, vehicleId);
response.Response = DataAccessUtility.ConvertToList <ProductInstallDetails>(dt)[0];
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseCollectionModel <ProductInstallDetails> GetInstallProductListByUserId(long userId, long installer)
{
var response = new ResponseCollectionModel <ProductInstallDetails>();
var dt = this.instance.GetInstallProductListByUserId(userId, installer);
response.Response = DataAccessUtility.ConvertToList <ProductInstallDetails>(dt);
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseCollectionModel <Vehicle> GetVehicleListByUserId(long userId)
{
var response = new ResponseCollectionModel <Vehicle>();
var dt = this.instance.GetVehicleListByUserId(userId);
response.Response = DataAccessUtility.ConvertToList <Vehicle>(dt);
response.Status = Constants.WebApiStatusOk;
return(response);
}
/// <summary>
/// Get list of bidding done by userid (false means Current posting otherwise close posting).
/// </summary>
/// <param name="userId"></param>
/// <param name="isPast"></param>
/// <returns></returns>
public ResponseCollectionModel <PostingListBid> GetBidStatusByUserId(long userId, Int16 status)
{
var response = new ResponseCollectionModel <PostingListBid>();
var dt = this.instanceBidding.GetBidStatusByUserId(userId, status);
var lst = DataAccessUtility.ConvertToList <PostingListBid>(dt);
response.Response = lst;
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseCollectionModel <TransportType> GetTransportTypeByUserId(long userid, out string message)
{
var result = new ResponseCollectionModel <TransportType>();
message = string.Empty;
var data = instance.GetTransportTypeByUserId(userid, out message);
result.Response = DataAccessUtility.ConvertToList <TransportType>(data);
result.Status = Constants.WebApiStatusOk;
return(result);
}
public static void SetFromDbXmlField<T>(this IDataReader reader,object obj, string dbFieldName, PropertyInfo pinfo)
{
if (pinfo != null)
{
var xmlData = DataAccessUtility.LoadNullable<string>(reader, dbFieldName);
if (xmlData.NotEmpty())
pinfo.SetValue(obj, XmlHelper.CreateFromXml<T>(xmlData));
else
pinfo.SetValue(obj, Activator.CreateInstance<T>());
}
}
public ResponseSingleModel <InsuranceDetails> GetInsuranceById(long vehicleId, long insuranceId)
{
var response = new ResponseSingleModel <InsuranceDetails>();
var dt = this.instance.GetInsuranceById(vehicleId, insuranceId);
InsuranceDetails insuranceDetails = DataAccessUtility.ConvertToList <InsuranceDetails>(dt)[0];
response.Response = insuranceDetails;
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseSingleModel <Vehicle> GetVehicleById(long vehicleId)
{
var response = new ResponseSingleModel <Vehicle>();
var dt = this.instance.GetById(vehicleId);
Vehicle vehicle = DataAccessUtility.ConvertToList <Vehicle>(dt)[0];
response.Response = vehicle;
response.Status = Constants.WebApiStatusOk;
return(response);
}
/// <summary>
/// Author:shwang
/// Date:20140614
/// Desc:得到担保批次信息
/// </summary>
/// <param name="filter">过滤条件</param>
/// <param name="pageOption">页面信息</param>
/// <returns>担保批次信息</returns>
public List <GuaranteeBatchViewData> GetGuaranteeBatch(GuaranteeBatchFilter filter)
{
string payDateCondition;
if (filter.HasPayDate)
{
payDateCondition = "g.PayDate IS NOT NULL";
}
else
{
payDateCondition = "g.PayDate IS NULL";
}
StringBuilder sbl = new StringBuilder();
if (!string.IsNullOrEmpty(filter.GuaranteeNo))
{
sbl.AppendFormat(" AND g.GuaranteeNum='{0}'", filter.GuaranteeNo);
}
if (!string.IsNullOrEmpty(filter.Region))
{
sbl.AppendFormat(" AND c.fullKey IN({0})", filter.Region);
}
if (!string.IsNullOrEmpty(filter.GuaranteeMonth))
{
sbl.AppendFormat(" AND g.GuaranteeMonth={0}", filter.GuaranteeMonth.ConvertToInt());
}
if (!string.IsNullOrEmpty(filter.ChildCompany))
{
sbl.AppendFormat(" AND s.MappingValue='{0}'", filter.ChildCompany);
}
if (filter.GuaranteeIndex > 0)
{
sbl.AppendFormat(" AND g.GuaranteeIndex={0}", filter.GuaranteeIndex);
}
string pageStr = string.Empty;
if (filter.PageSize > 0)
{
int startNo = (filter.PageNo - 1) * filter.PageSize + 1;
int endNo = startNo + filter.PageSize - 1;
pageStr = string.Format("WHERE t.num BETWEEN {0} AND {1} ", startNo, endNo);
}
string sqlStr = "SQL\\DwjmPayConfirm\\Select_GuaranteeBatch.sql".ToFileContent(false, payDateCondition, sbl.ToString(), pageStr);
return(DataAccessUtility.GetSearchDataByPageNo <GuaranteeBatchViewData>(filter, sqlStr));
}
public ResponseSingleModel <PostingSummary> GetPostingSummary(long userId)
{
var result = new ResponseSingleModel <PostingSummary>();
var dt = this.instance.GetPostingSummary(UserId);
var lst = DataAccessUtility.ConvertToList <PostingSummary>(dt);
PostingSummary summary = lst.Count > 0 ? lst[0] : null;
result.Response = summary;
result.Status = summary != null ? Constants.WebApiStatusOk : Constants.WebApiStatusFail;
result.Message = "";
return(result);
}
public void Load(IDataReader reader)
{
Id = DataAccessUtility.LoadInt32(reader, "Id");
Artist = DataAccessUtility.LoadNullable <string>(reader, "Artist");
FullFileName = DataAccessUtility.LoadNullable <string>(reader, "FullFileName");
FileName = DataAccessUtility.LoadNullable <string>(reader, "FileName");
Title = DataAccessUtility.LoadNullable <string>(reader, "Title");
MachineName = DataAccessUtility.LoadNullable <string>(reader, "MachineName");
//ToUsb = DataAccessUtility.LoadNullable<bool?>(reader, "ToUsb");
//ToPlaylist = DataAccessUtility.LoadNullable<bool?>(reader, "ToPlaylist");
}
public void Load(IDataReader reader)
{
TransactionType = (MonthlyTransactionType)DataAccessUtility.LoadInt32(reader, "TransactionType");
Amount = DataAccessUtility.LoadNullable <int>(reader, "Amount");
Name = DataAccessUtility.LoadNullable <string>(reader, "Name");
Id = DataAccessUtility.LoadInt32(reader, "Id");
Active = DataAccessUtility.LoadNullable <bool>(reader, "Active");
Auto = DataAccessUtility.LoadNullable <bool>(reader, "Auto");
UserGroupId = DataAccessUtility.LoadInt32(reader, "UserGroupId");
FromDate = DataAccessUtility.LoadNullable <DateTime>(reader, "FromDate");
ToDate = DataAccessUtility.LoadNullable <DateTime?>(reader, "ToDate");
}
public ResponseSingleModel <BiddingProfile> GetBiddingDetailById(long biddingId)
{
var response = new ResponseSingleModel <BiddingProfile>();
var ds = this.instanceBidding.GetById(biddingId);
BiddingProfile biddingProfile = DataAccessUtility.ConvertToList <BiddingProfile>(ds.Tables[0])[0];
biddingProfile.biddingDetails = DataAccessUtility.ConvertToList <BiddingDetails>(ds.Tables[1]);
response.Response = biddingProfile;
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseCollectionModel <PostingList> GetPostingListByUserId(long userId, bool isPast, out string message)
{
var result = new ResponseCollectionModel <PostingList>();
message = string.Empty;
var dt = this.instance.GetListPostingByUserId(userId, isPast, out message);
result.Response = DataAccessUtility.ConvertToList <PostingList>(dt);
result.Status = Constants.WebApiStatusOk;
result.Message = message;
return(result);
}
public ResponseSingleModel <Company> GetCompanyDetailByUserId(long userId, out string message)
{
var result = new ResponseSingleModel <Company>();
message = string.Empty;
var dt = this.instance.GetByUserId(userId, out message);
var lst = DataAccessUtility.ConvertToList <Company>(dt);
result.Response = lst != null && lst.Count > 0 ? lst[0] : null;
result.Status = lst != null && lst.Count > 0 ? Constants.WebApiStatusOk : Constants.WebApiStatusFail;
result.Message = message;
return(result);
}
public ResponseSingleModel <PostingProfileView> GetPostingProfileById(long postingId, out string message)
{
var result = new ResponseSingleModel <PostingProfileView>();
message = string.Empty;
var dt = this.instance.GetById(postingId, out message);
var lstProfile = DataAccessUtility.ConvertToList <QTrans.Models.ViewModel.Posting.PostingProfileView>(dt);
result.Response = lstProfile != null && lstProfile.Count > 0 ? lstProfile[0] : null;;
result.Status = Constants.WebApiStatusOk;
result.Message = message;
return(result);
}
/// <summary>
/// Get Min Max Amount of bidding by DtlPostId.
/// </summary>
/// <param name="dtlpostId"></param>
/// <returns>return bid min max amount and total bid</returns>
public ResponseSingleModel <BidMinMaxAmount> GetBidMinMaxByDtlPostId(long dtlpostId)
{
var response = new ResponseSingleModel <BidMinMaxAmount>();
var dt = this.instanceBidding.GetMinMaxBidAmount(dtlpostId);
var result = DataAccessUtility.ConvertToList <BidMinMaxAmount>(dt);
response.Response = result != null && result.Count > 0 ? result[0] : new BidMinMaxAmount()
{
dtlpostingid = dtlpostId
};
response.Status = Constants.WebApiStatusOk;
return(response);
}
public ResponseSingleModel <UserProfile> Login(string username, string password, out string message)
{
var result = new ResponseSingleModel <UserProfile>();
message = string.Empty;
var dt = instance.UserLogIn(username, password, out message);
var lst = DataAccessUtility.ConvertToList <UserProfile>(dt);
UserProfile user = lst != null && lst.Count > 0 ? lst[0] : null;
result.Response = user;
result.Status = user != null ? Constants.WebApiStatusOk : Constants.WebApiStatusFail;
result.Message = message;
return(result);
}
public ResponseSingleModel <UserProfile> GetUserDetailByToken(string token, out string message)
{
var result = new ResponseSingleModel <UserProfile>();
message = string.Empty;
var dt = instance.GetBytoken(token, out message);
var lst = DataAccessUtility.ConvertToList <UserProfile>(dt);
UserProfile user = lst != null && lst.Count > 0 ? lst[0] : null;
result.Response = user;
result.Status = user != null ? Constants.WebApiStatusOk : Constants.WebApiStatusFail;
result.Message = message;
return(result);
}
public void Load(IDataReader reader)
{
Id = DataAccessUtility.LoadInt32(reader, "Id");
UserId = DataAccessUtility.LoadInt32(reader, "UserId");
Shared = DataAccessUtility.LoadNullable <bool>(reader, "Shared");
CreationDate = DataAccessUtility.LoadNullable <DateTime>(reader, "CreationDate");
Date = DataAccessUtility.LoadNullable <DateTime>(reader, "Date");
Description = DataAccessUtility.LoadNullable <string>(reader, "Description");
title = DataAccessUtility.LoadNullable <string>(reader, "title");
var rEvery = DataAccessUtility.LoadNullable <int?>(reader, "RepeatEvery");
if (rEvery.HasValue)
{
RepeatEvery = (RepeatEvery)rEvery.Value;
}
}
/// <summary>
/// 得到business信息
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="filter">过滤条件，字段名需要和数据库列名一致</param>
/// <returns>订单信息包括 客户姓名、身份证号</returns>
public List <T> GetBusinessInfo <T>(BaseFilter filter) where T : new()
{
Type filterType = filter.GetType();
PropertyInfo[] propertyInfoArray = filterType.GetProperties();
StringBuilder conditionSbl = new StringBuilder();
foreach (PropertyInfo propertyInfo in propertyInfoArray)
{
object propertyInfoV = propertyInfo.GetValue(filter, null);
if (propertyInfoV.IsDefaultValue())
{
continue;
}
if (DataAccessConsts.BaseFilterProperty.Contains(propertyInfo.Name))
{
continue;
}
if (propertyInfoV is string)
{
conditionSbl.AppendFormat("AND {0}='{1}' ", propertyInfo.Name, propertyInfoV);
}
else if (propertyInfoV is DateTime)
{
conditionSbl.AppendFormat("AND {0}='{1}' ", propertyInfo.Name, Convert.ToDateTime(propertyInfoV).DateTimeToString2());
}
else
{
conditionSbl.AppendFormat("AND {0}={1} ", propertyInfo.Name, propertyInfoV);
}
}
string pageConditionStr = string.Empty;
if (filter.PageNo > 0)
{
int startNo = (filter.PageNo - 1) * filter.PageSize + 1;
int endNo = startNo + filter.PageSize - 1;
pageConditionStr = string.Format("WHERE t.num BETWEEN {0} AND {1}", startNo, endNo);
}
string sql = "SQL\\BusinessService\\BusinessSearch.sql".ToFileContent(false, conditionSbl.ToString(), pageConditionStr);
return(DataAccessUtility.GetSearchDataByPageNo <T>(filter, sql));
}
public ResponseCollectionModel <CityPincode> GetPincode()
{
var result = new ResponseCollectionModel <CityPincode>();
if (InMemoryStorage.Instance.PincodeStorage.Count > 0)
{
result.Response = InMemoryStorage.Instance.PincodeStorage.Values.ToList();
}
else
{
var data = instance.GetPincode();
result.Response = DataAccessUtility.ConvertToList <CityPincode>(data);
}
result.Status = Constants.WebApiStatusOk;
return(result);
}
/// <summary>
/// Get list of bidding done by userid.
/// </summary>
/// <param name="userId"></param>
/// <param name="message"></param>
/// <returns></returns>
public ResponseCollectionModel <BiddingListDetails> GetBiddingListByDtPostingId(long DtlPostingId)
{
var message = "";
var response = new ResponseCollectionModel <BiddingListDetails>();
var ds = this.instanceBidding.GetBiddingListByDtlPostId(DtlPostingId);
var lstbidding = DataAccessUtility.ConvertToList <BiddingListDetails>(ds.Tables[0]);
var lstBidDetails = DataAccessUtility.ConvertToList <BiddingDetails>(ds.Tables[1]);
foreach (var bid in lstbidding)
{
bid.biddingDetails = lstBidDetails.Where(item => item.biddingid == bid.biddingid).ToList();
}
response.Response = lstbidding;
response.Status = Constants.WebApiStatusOk;
return(response);
}
public void Load(IDataReader reader)
{
Id = DataAccessUtility.LoadInt32(reader, "Id");
UserName = DataAccessUtility.LoadNullable <string>(reader, "UserName");
Password = DataAccessUtility.LoadNullable <string>(reader, "Password");
DisplayName = DataAccessUtility.LoadNullable <string>(reader, "DisplayName");
EmailAdress = DataAccessUtility.LoadNullable <string>(reader, "EmailAdress");
string cper = DataAccessUtility.LoadNullable <string>(reader, "AllowedClientPagePermissions");
if (string.IsNullOrEmpty(cper))
{
AllowedClientPagePermissions = new List <ClientPagePermissions>();
}
else
{
AllowedClientPagePermissions = XmlHelper.CreateFromXml <List <ClientPagePermissions> >(cper);
}
}
public ResponseCollectionModel <CountryState> GetState()
{
var response = new ResponseCollectionModel <CountryState>();
if (InMemoryStorage.Instance.StateStorage.Count > 0)
{
var lst = InMemoryStorage.Instance.StateStorage.Values.ToList();
response.Response = lst;
}
else
{
var data = instance.GetState();
var lst = DataAccessUtility.ConvertToList <CountryState>(data);
response.Response = lst;
}
response.Status = Constants.WebApiStatusOk;
return(response);
}
