/// <summary>
/// 获取1条信息资料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static DownloadsModel GetDownLoadsByID(int downid)
{
string sql = "select * from T_Downloads where ID=?";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = downid;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
DownloadsModel s = new DownloadsModel();
if (dr.Read())
{
s.F_Size = dr["F_Size"].ToString();
s.F_Desc = dr["F_Desc"].ToString();
s.F_Keywords = dr["F_Keywords"].ToString();
s.F_Content = dr["F_Content"].ToString();
s.F_FileType = Convert.ToInt32(dr["F_FileType"]);
s.F_Date = Convert.ToDateTime(dr["F_Date"]);
s.ID = Convert.ToInt32(dr["ID"]);
s.F_Title = dr["F_Title"].ToString();
s.F_FileImage = dr["F_FileImage"].ToString();
s.F_FileSmallImage = dr["F_FileSmallImage"].ToString();
}
dr.Close();
dr.Dispose();
return(s);
}
public ActionResult BuyerRequests()
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Authentication", new { ReturnUrl = @"/RegisteredUser/BuyerRequests" }));
}
int UID = Convert.ToInt32(User.Identity.Name);
BuyerRequestsModel br = new BuyerRequestsModel();
DownloadsModel dm = DownloadRepository.GetDownloads(UID, 0);
foreach (DownloadsModel.InnerClassDownload d in dm.DownloadProperty)
{
UserProfileModel usrp = UserRepository.GetUserData(d.Buyer.UserID);
br.BRequests.Add(new BuyerRequestsModel.BuyerRequest()
{
BuyerEmail = d.Buyer.Email,
BuyerPhone = usrp.PhoneNo != null ? usrp.CountryCode + " " + usrp.PhoneNo : "N/A",
NoteTitle = d.NoteTitle,
NoteID = d.NoteID,
NoteCategory = d.NoteCategory,
SellType = d.IsPaid ? "Paid" : "Free",
DownloadID = d.DownloadID,
ReqTime = (System.DateTime)d.RequestTime,
Price = (int)d.PurchasedPrice
});
}
ViewBag.Authorized = true;
ViewBag.Title = "BuyerRequests";
return(View(br));
}
/// <summary>
/// 获取所有销售网络数据
/// </summary>
/// <returns></returns>
public static List <DownloadsModel> GetDownloadsListByLang(int lang, int number, int pagesize)
{
if (number == 0)
{
number = 1;
}
string sql = "select top " + pagesize + " * from (select top " + number + " * from T_Downloads where F_Lang=" + lang + " order by ID asc) order by ID desc";
List <DownloadsModel> list = new List <DownloadsModel>();
DownloadsModel s = null;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql);
while (dr.Read())
{
s = new DownloadsModel();
s.F_Size = dr["F_Size"].ToString();
s.F_Desc = dr["F_Desc"].ToString();
s.F_Keywords = dr["F_Keywords"].ToString();
s.F_Content = dr["F_Content"].ToString();
s.F_FileType = Convert.ToInt32(dr["F_FileType"]);
s.F_Date = Convert.ToDateTime(dr["F_Date"]);
s.ID = Convert.ToInt32(dr["ID"]);
s.F_Title = dr["F_Title"].ToString();
s.F_FileImage = dr["F_FileImage"].ToString();
s.F_FileSmallImage = dr["F_FileSmallImage"].ToString();
list.Add(s);
}
dr.Close();
dr.Dispose();
return(list);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int ADD(DownloadsModel s)
{
string sql = "insert into T_Downloads(F_FileType,F_Content,F_Size,F_Desc,F_Keywords,F_Lang,F_Title,F_FileImage,F_FileSmallImage) values(?,?,?,?,?,?,?,?,?)";
OleDbParameter[] parameter = new OleDbParameter[9];
parameter[0] = new OleDbParameter("@F_FileType", OleDbType.Integer);
parameter[1] = new OleDbParameter("@F_Content", OleDbType.VarChar);
parameter[2] = new OleDbParameter("@F_Size", OleDbType.VarChar, 200);
parameter[3] = new OleDbParameter("@F_Desc", OleDbType.VarChar, 500);
parameter[4] = new OleDbParameter("@F_Keywords", OleDbType.VarChar);
parameter[5] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[6] = new OleDbParameter("@F_Title", OleDbType.VarChar);
parameter[7] = new OleDbParameter("@F_FileImage", OleDbType.VarChar);
parameter[8] = new OleDbParameter("@F_FileSmallImage", OleDbType.VarChar);
parameter[0].Value = s.F_FileType;
parameter[1].Value = s.F_Content;
parameter[2].Value = s.F_Size;
parameter[3].Value = s.F_Desc;
parameter[4].Value = s.F_Keywords;
parameter[5].Value = s.F_Lang;
parameter[6].Value = s.F_Title;
parameter[7].Value = s.F_FileImage;
parameter[8].Value = s.F_FileSmallImage;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int UpdateByid(DownloadsModel s)
{
string sql = "update T_Downloads set F_FileType=?,F_Content=?,F_Size=?,F_Desc=?,F_Keywords=?,F_Title=?,F_FileImage=?,F_FileSmallImage=? where ID=?";
OleDbParameter[] parameter = new OleDbParameter[9];
parameter[0] = new OleDbParameter("@F_FileType", OleDbType.Integer);
parameter[1] = new OleDbParameter("@F_Content", OleDbType.VarChar);
parameter[2] = new OleDbParameter("@F_Size", OleDbType.VarChar, 200);
parameter[3] = new OleDbParameter("@F_Desc", OleDbType.VarChar, 500);
parameter[4] = new OleDbParameter("@F_Keywords", OleDbType.VarChar);
parameter[5] = new OleDbParameter("@F_Title", OleDbType.VarChar);
parameter[6] = new OleDbParameter("@F_FileImage", OleDbType.VarChar);
parameter[7] = new OleDbParameter("@F_FileSmallImage", OleDbType.VarChar);
parameter[8] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = s.F_FileType;
parameter[1].Value = s.F_Content;
parameter[2].Value = s.F_Size;
parameter[3].Value = s.F_Desc;
parameter[4].Value = s.F_Keywords;
parameter[5].Value = s.F_Title;
parameter[6].Value = s.F_FileImage;
parameter[7].Value = s.F_FileSmallImage;
parameter[8].Value = s.ID;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtTitle.Text))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('标题不能为空！')", true);
return;
}
string smallfileurl = txtImgPath.Text;
smallfileurl = smallfileurl.ToLower();
smallfileurl = smallfileurl.Replace("userfiles", "userfiles/_thumbs");
long filesize = 0;
DownloadsModel s = new DownloadsModel();
string filePath = txtFilePath.Text;
s.F_Size = filesize.ToString();
s.F_FileType = Convert.ToInt16(drpFileClass.SelectedValue); //Convert.ToInt32(this.txtRegion.SelectedValue);
s.F_Content = filePath; //VerifyTool.DeleteScript(this.content.Value);
s.F_Desc = txtDesc.Text;
s.F_Lang = lang;
s.F_Title = txtTitle.Text;
s.F_Keywords = txtKeywords.Text;
s.F_FileImage = txtImgPath.Text;
s.F_FileSmallImage = smallfileurl;
int res = EispDownloadsBLL.ADD(s);
if (res > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('添加成功！');location.href='DownloadAdmin.aspx?lang=" + lang + "'", true);
}
}
public ActionResult SoldNotes()
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Authentication", new { ReturnUrl = @"/RegisteredUser/SoldNotes" }));
}
int UserID = Convert.ToInt32(User.Identity.Name);
DownloadsModel soldNotes = DownloadRepository.GetDownloads(UserID, 2); // DownnloadStatus : 2 for sold notes
ViewBag.Authorized = true;
ViewBag.Title = "SoldNotes";
return(View(soldNotes));
}
public ActionResult Downloads()
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Authentication", new { ReturnUrl = @"/RegisteredUser/Downloads" }));
}
int UserID = Convert.ToInt32(User.Identity.Name);
DownloadsModel DownloadedNotes = DownloadRepository.GetDownloads(UserID, 1); // DownnloadStatus : 1 for downloads
ViewBag.LoadAjaxJS = true;
ViewBag.LoadValidationScript = true;
ViewBag.Authorized = true;
ViewBag.Title = "Downloads";
return(View(DownloadedNotes));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int UpdateByid(DownloadsModel s)
{
return(EispDownloadsDAL.UpdateByid(s));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int ADD(DownloadsModel s)
{
return(EispDownloadsDAL.ADD(s));
}
/* DownloadStatus :
* 0 : Buyer Requests (where UserID = Seller ID && IsAllowed != true)
* 1 : My Downloads (where UserID = Buyer ID && IsAllowed = true)
* 2 : Sold Notes (where UserID = Seller ID && IsAllowed = true)
*/
public static DownloadsModel GetDownloads(int UserID, int downloadStatus)
{
using (NotesMarketPlaceEntities context = new NotesMarketPlaceEntities())
{
DownloadsModel dm = new DownloadsModel();
dm.DownloadProperty = new List <DownloadsModel.InnerClassDownload>();
if (!context.Downloads.Any(d => d.SellerID == UserID || d.BuyerID == UserID))
{
return(dm);
}
List <Download> dls = null;
if (downloadStatus == 0)
{
dls = context.Downloads.Where(d => d.SellerID == UserID && !d.IsAllowed).ToList();
}
else if (downloadStatus == 1)
{
dls = context.Downloads.Where(d => d.BuyerID == UserID && d.IsAllowed).ToList();
}
else if (downloadStatus == 2)
{
dls = context.Downloads.Where(d => d.SellerID == UserID && d.IsAllowed).ToList();
}
//Current User is user calling this function and other party is seller/buyer involved in transaction
User CurrentUser = context.Users.FirstOrDefault(u => u.UserID == UserID);
User OtherParty;
UserModel CurrentUserInfo = new UserModel()
{
UserID = UserID,
FirstName = CurrentUser.FirstName,
LastName = CurrentUser.LastName,
Email = CurrentUser.Email
};
UserModel OtherPartyInfo;
foreach (Download d in dls)
{
int OtherPartyID = downloadStatus != 1 ? d.BuyerID : d.SellerID;
OtherParty = context.Users.FirstOrDefault(u => u.UserID == OtherPartyID);
if (OtherParty == null)
{
continue;
}
else if (OtherParty.RoleID <= 2)
{
continue;
}
OtherPartyInfo = new UserModel()
{
UserID = OtherPartyID,
FirstName = OtherParty.FirstName,
LastName = OtherParty.LastName,
Email = OtherParty.Email
};
dm.DownloadProperty.Add(new DownloadsModel.InnerClassDownload()
{
DownloadID = d.DownloadID,
Seller = downloadStatus != 1 ? CurrentUserInfo : OtherPartyInfo,
Buyer = downloadStatus != 1 ? OtherPartyInfo : CurrentUserInfo,
DownloadDate = d.DownloadDate,
IsAllowed = d.IsAllowed,
AttachmentsID = d.AttachmentsID,
IsDownloaded = d.IsDownloaded,
IsPaid = d.IsPaid,
PurchasedPrice = d.PurchasedPrice,
NoteCategory = d.NoteCategory1.CategoryName,
NoteTitle = d.NoteTitle,
NoteID = d.NoteID,
RequestTime = d.ModifiedDate
});
}
return(dm);
}
}
