public Operation Delete(AnFVoucher obj)
{
Operation objOperation = new Operation { Success = true, OperationId = obj.Id };
_voucherRepository.Delete(obj);
try
{
_unitOfWork.Commit();
}
catch (Exception)
{
objOperation.Success = false;
}
return objOperation;
}
public int UpdateVoucher(AnFVoucher v)
{
int ret;
ret= _AnFVoucherRepository.UpdateEntity(v);
return ret;
}
public int SaveVoucher(AnFVoucher v)
{
int Id = _AnFVoucherRepository.AddEntity(v);
try
{
// _UnitOfWork.Commit();
}
catch (Exception ex)
{
}
return Id;
}
public AnFVoucher GetAnfVoucherById(int Id)
{
try
{
AnFVoucher record = null;
DataTable dt = GetAnfVoucher(Id);
if (dt != null && dt.Rows.Count > 0)
{
record = new AnFVoucher();
record = (AnFVoucher)Helper.FillTo(dt.Rows[0], typeof(AnFVoucher));
}
return record;
}
catch (Exception ex)
{
throw ex;
}
}
public Operation SaveVoucher(AnFVoucher obj, Operation objOperation, System.Data.Entity.DbContextTransaction dbContextTransaction)
{
try
{
bool update = false;
long Id = 0;
if (obj.Id <= 0)
{
Id = _voucherRepository.AddEntity(obj);
}
else
{
Id = obj.Id;
update = true;
}
if (Id > 0)
{
objOperation.OperationId = Id;
var existingDetailList = _voucherDetailRepository.GetAll();
if (existingDetailList != null && existingDetailList.Count() > 0)
{
existingDetailList = existingDetailList.Where(i => i.AnFVoucherId == Id).ToList();
}
IList<AnFVoucherDetail> newdetailList = new List<AnFVoucherDetail>();
//obj.AnFVoucherDetails.First().Id = 1561;
//Delete detail
foreach (AnFVoucherDetail delete in existingDetailList)
{
AnFVoucherDetail exists = null;
try
{
exists = obj.AnFVoucherDetails.Where(i => i.Id == delete.Id).FirstOrDefault();
}
catch(Exception ex)
{
}
if(exists == null)
{
_voucherDetailRepository.Delete(delete);
}
}
//add/update detail
foreach (AnFVoucherDetail detail in obj.AnFVoucherDetails)
{
detail.AnFVoucherId = int.Parse(objOperation.OperationId.ToString());
if (detail.Id <= 0)
{
//detail.SubVoucherNumber = "MLP-JV-001-2/06-14-2";
newdetailList.Add(detail);
}
else
{
//detail.SubVoucherNumber = "MLP-JV-001-1/06-14-2";
_voucherDetailRepository.Modified(detail);
}
}
//Add offer detail list - new offer details
if (newdetailList != null && newdetailList.Count > 0)
{
_voucherDetailRepository.AddEntityList(newdetailList);
}
if(update)
{
_voucherRepository.Modified(obj);
}
_voucherRepository.SaveChanges();
_voucherDetailRepository.SaveChanges();
try
{
_voucherRepository.Commit(dbContextTransaction);
objOperation.Success = true;
}
catch (Exception ex)
{
objOperation.Message = ex.Message;
throw ex;
}
}
else
{
objOperation.Success = false;
}
}
catch (Exception ex)
{
objOperation.Success = false;
_voucherRepository.Rollback(dbContextTransaction);
}
return objOperation;
}
public Operation Save(AnFVoucher obj)
{
Operation objOperation = new Operation { Success = false };
using (var dbContextTransaction = _voucherRepository.BeginTransaction())
{
objOperation = SaveVoucher(obj, objOperation, dbContextTransaction);
}
return objOperation;
}
public ActionResult SaveVoucher(AnFVoucher obj)
{
Operation objOperation = new Operation { Success = false };
if (ModelState.IsValid)
{
//obj.Id = 332;
//obj.VoucherNumber = "MLP-JV-001-2/06-14";
if (obj.Id == 0)
{
//if ((bool)Session["Add"])
//{
int officeId = obj.SlsOfficeId != null ? (int)obj.SlsOfficeId : 0;
string typeStr = Enum.GetName(typeof(VoucherType), obj.Type);
obj.VoucherNumber = GetVoucherNo(obj.CmnCompanyId, obj.Type, typeStr, officeId, obj.CmnFinancialYearId, obj.Date);
foreach (var detail in obj.AnFVoucherDetails)
{
detail.SubVoucherNumber = obj.VoucherNumber + "-" + detail.VoucherSerial;
}
obj.IsPosted = false;
obj.PostedBy = userId;
obj.PostedDate = DateTime.Now.Date;
obj.CreatedBy = userId;
obj.CreatedDate = DateTime.Now.Date;
objOperation = _VoucherService.Save(obj);
//}
//else { objOperation.OperationId = -1; }
}
else
{
//if ((bool)Session["Edit"])
//{
obj.ModifiedBy = userId;
obj.ModifiedDate = DateTime.Now.Date;
foreach (var detail in obj.AnFVoucherDetails)
{
detail.SubVoucherNumber = obj.VoucherNumber + "-" + detail.VoucherSerial;
}
objOperation = _VoucherService.Save(obj);
//}
//else { objOperation.OperationId = -2; }
}
}
return Json(objOperation, JsonRequestBehavior.DenyGet);
//return Json(new { Success= true }, JsonRequestBehavior.DenyGet);
}
