/// <summary>
/// 创建求资源
/// </summary>
/// <param name="model"></param>
public static void Create(ManageAskViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Ask ask = new tbl_Ask()
{
ask_Movie = model.MovieId,
ask_Note = model.Note,
ask_State = false,
ask_With = 0
};
if (model.User != null)
{
ask.ask_User = model.User;
}
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Ask.Where(p => p.ask_Id == guid).Count() != 0);
ask.ask_Id = guid;
//_db.tbl_Ask.InsertOnSubmit(ask);
//_db.SubmitChanges();
//_db.SetAskTime(guid);
_db.tbl_Ask.Add(ask);
_db.SaveChanges();
}
}
/// <summary>
/// 取消求资源
/// </summary>
/// <param name="id">求资源id</param>
public static void Delete(string id)
{
using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
{
tbl_Ask ask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id);
_db.tbl_Ask.DeleteOnSubmit(ask);
_db.SubmitChanges();
}
}
/// <summary>
/// 求资源已求到
/// </summary>
/// <param name="id">求资源id</param>
public static void Over(string id)
{
using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
{
tbl_Ask tblask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id);
tblask.ask_State = true;
_db.SubmitChanges();
}
}
/// <summary>
/// 取消求资源
/// </summary>
/// <param name="id">求资源id</param>
public static void Delete(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Ask ask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id);
//_db.tbl_Ask.DeleteOnSubmit(ask);
_db.tbl_Ask.Remove(ask);
//_db.SubmitChanges();
_db.SaveChanges();
}
}
public AskViewModel(tbl_Ask ask)
{
Id = ask.ask_Id;
MovieId = ask.ask_Movie;
MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
tbl_Movie tblmovie = _db.tbl_Movie.SingleOrDefault(m => m.movie_Id == ask.ask_Movie);
Movie = new MovieViewModel(tblmovie);
Note = ask.ask_Note;
State = (bool)ask.ask_State;
User = ask.ask_User;
Account = AccountManager.GetAccount(ask.ask_User);
Time = ((DateTime)ask.ask_Time).Date.ToShortDateString();;
With = (int)ask.ask_With;
hadWith = false;
}
