public void Update(CharityRecordUiModel model)
{
try
{
using (CharityEntities entities = new CharityEntities())
{
CharityRecord charityRecord = new CharityRecord();
var record = entities.CharityRecords.Include(x => x.FileDetails).Where(x => x.Id == model.id).FirstOrDefault();
record.Title = model.Title;
record.Description = model.Description;
record.Charity = model.Charity;
record.PlayItForward = model.PlayItFwd;
record.UserId = model.UserId;
record.Currency = model.Currency;
foreach (var item in model.FileDetails)
{
FileDetail detailsobj = new FileDetail();
detailsobj.FileInfo = item.FileInfo;
detailsobj.FileName = item.FileName;
detailsobj.CharityId = item.CharityId;
entities.FileDetails.Add(detailsobj);
}
entities.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public void Write(CharityRecordUiModel record)
{
try
{
using (CharityEntities entities = new CharityEntities())
{
CharityRecord charityRecord = new CharityRecord();
charityRecord.Title = record.Title;
charityRecord.Description = record.Description;
charityRecord.Charity = record.Charity;
charityRecord.PlayItForward = record.PlayItFwd;
charityRecord.UserId = record.UserId;
charityRecord.Currency = record.Currency;
charityRecord.Status = 0;
entities.CharityRecords.Add(charityRecord);
foreach (var item in record.FileDetails)
{
FileDetail detailsobj = new FileDetail();
detailsobj.FileInfo = item.FileInfo;
detailsobj.FileName = item.FileName;
detailsobj.CharityId = charityRecord.Id;
entities.FileDetails.Add(detailsobj);
}
entities.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public CharityRecordUiModel LoadRecordtoEdit(int trid)
{
using (CharityEntities entities = new CharityEntities())
{
var result = entities.CharityRecords.Where(x => x.Id == trid).Include(x => x.FileDetails).
FirstOrDefault();
List <FileDetailsUiModel> files = new List <FileDetailsUiModel>();
foreach (var item in result.FileDetails)
{
FileDetailsUiModel model = new FileDetailsUiModel();
model.FileInfo = item.FileInfo;
model.FileName = item.FileName;
model.CharityId = item.CharityId;
model.id = item.Id;
files.Add(model);
}
var record = new CharityRecordUiModel()
{
Charity = result.Charity,
Currency = (float)result.Currency,
Description = result.Description,
id = result.Id,
PlayItFwd = result.PlayItForward,
Title = result.Title,
UserId = result.UserId,
FileDetails = files
};
return(record);
}
}
public List <CharityRecordUiModel> GetRecords()
{
using (CharityEntities entities = new CharityEntities())
{
List <CharityRecord> record = entities.CharityRecords.ToList();
var model = new List <CharityRecordUiModel>();
foreach (var item in record)
{
var result = new CharityRecordUiModel()
{
Charity = item.Charity,
Currency = (float)item.Currency,
Description = item.Description,
id = item.Id,
PlayItFwd = item.PlayItForward,
Title = item.Title,
UserId = item.UserId,
IsAdmin = true,
status = GetStatus(item.Status)
};
model.Add(result);
}
return(model);
}
}
public void ApproveCharity(int trid)
{
using (CharityEntities entities = new CharityEntities())
{
var result = entities.CharityRecords.Where(x => x.Id == trid).FirstOrDefault();
result.Status = 1;
entities.SaveChanges();
}
}
public void DeleteRecord(int trid)
{
try
{
using (CharityEntities entities = new CharityEntities())
{
var result = entities.CharityRecords.Where(x => x.Id == trid).Include(x => x.FileDetails).
FirstOrDefault();
entities.FileDetails.RemoveRange(result.FileDetails);
entities.CharityRecords.Remove(result);
entities.SaveChanges();
}
}
catch
{
throw;
}
}