private static GLHeader getEntityByModel(GLHeaderModel model)
{
if (model == null)
{
return(null);
}
GLHeader entity = new GLHeader();
entity.Id = model.Id;
entity.JournalName = model.JournalName;
entity.ConversionRate = model.ConversionRate;
entity.CurrencyId = model.CurrencyId;
entity.Description = model.Description;
entity.DocumentNo = model.DocumentNo;
entity.GLDate = model.GLDate;
entity.PeriodId = model.PeriodId;
entity.SOBId = model.SOBId;
if (model.Id == 0)
{
entity.CreateBy = AuthenticationHelper.UserId;
entity.CreateDate = DateTime.Now;
entity.CompanyId = AuthenticationHelper.CompanyId.Value;
}
else
{
entity.CreateBy = model.CreateBy;
entity.CreateDate = model.CreateDate;
entity.CompanyId = model.CompanyId;
}
entity.UpdateBy = AuthenticationHelper.UserId;
entity.UpdateDate = DateTime.Now;
return(entity);
}
public GLHeader GetSingle(string id, long companyId)
{
GLHeader entity = this.GetAll(companyId)
.FirstOrDefault(x => x.Id == Convert.ToInt64(id));
return(entity);
}
public string Update(GLHeader entity)
{
var originalEntity = this.Context.GLHeaders.Find(entity.Id);
this.Context.Entry(originalEntity).CurrentValues.SetValues(entity);
this.Context.Entry(originalEntity).State = EntityState.Modified;
this.Commit();
return(entity.Id.ToString());
}
public GLHeader GetSingle(long CompanyId, long PeriodId, long SOBId, long CurrencyId)
{
GLHeader entity = this.GetAll(CompanyId)
.Where(x => x.PeriodId == PeriodId && x.SOBId == SOBId &&
x.CurrencyId == CurrencyId).
OrderByDescending(rec => rec.Id).FirstOrDefault();
return(entity);
}
public static void Update(GLHeaderModel jv)
{
GLHeader entity = getEntityByModel(jv);
string result = string.Empty;
if (entity.IsValid())
{
if (jv.Id > 0)
{
result = service.Update(entity);
}
else
{
result = service.Insert(entity);
}
if (!string.IsNullOrEmpty(result))
{
var savedLines = getGLLinesByHeaderId(result);
if (savedLines.Count() > jv.GlLines.Count())
{
var tobeDeleted = savedLines.Take(savedLines.Count() - jv.GlLines.Count());
foreach (var item in tobeDeleted)
{
lineService.Delete(item.Id.ToString(), AuthenticationHelper.CompanyId.Value);
}
savedLines = getGLLinesByHeaderId(result);
}
foreach (var line in jv.GlLines)
{
GLLines lineEntity = getEntityByModel(line, jv.ConversionRate);
if (lineEntity.IsValid())
{
lineEntity.HeaderId = Convert.ToInt64(result);
if (savedLines.Count() > 0)
{
lineEntity.Id = savedLines.FirstOrDefault().Id;
savedLines.Remove(savedLines.FirstOrDefault(rec => rec.Id == lineEntity.Id));
lineService.Update(lineEntity);
}
else
{
lineService.Insert(lineEntity);
}
}
}
}
}
}
public GLHeaderModel(GLHeader entity)
{
this.Id = entity.Id;
this.SOBId = entity.SOBId;
this.CompanyId = entity.CompanyId;
this.PeriodId = entity.PeriodId;
this.CurrencyId = entity.CurrencyId;
this.JournalName = entity.JournalName;
this.Description = entity.Description;
this.GLDate = entity.GLDate;
this.DocumentNo = entity.DocumentNo;
this.ConversionRate = entity.ConversionRate;
this.CreateBy = entity.CreateBy;
this.CreateDate = entity.CreateDate;
this.UpdateBy = entity.UpdateBy;
this.UpdateDate = entity.UpdateDate;
this.PeriodName = "";
this.CurrencyName = "";
}
public string Update(GLHeader entity)
{
return(this.repository.Update(entity));
}
public string Insert(GLHeader entity)
{
return(this.repository.Insert(entity));
}
public string Insert(GLHeader entity)
{
this.Context.GLHeaders.Add(entity);
this.Commit();
return(entity.Id.ToString());
}
