public HttpResponseMessage unlockJournalVoucher(String id, Models.TrnJournalVoucher journalVoucher)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var journalVouchers = from d in db.TrnJournalVouchers where d.Id == Convert.ToInt32(id) select d;
if (journalVouchers.Any())
{
var updateJournalVoucher = journalVouchers.FirstOrDefault();
updateJournalVoucher.IsLocked = false;
updateJournalVoucher.UpdatedById = userId;
updateJournalVoucher.UpdatedDateTime = DateTime.Now;
postJournal.deleteJVJournal(Convert.ToInt32(id));
db.SubmitChanges();
updateBalances(Convert.ToInt32(id));
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 insertJournalVoucher(Models.TrnJournalVoucher journalVoucher)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var lastJVNumber = from d in db.TrnJournalVouchers.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d;
var JVNumberResult = "0000000001";
if (lastJVNumber.Any())
{
var JVNumber = Convert.ToInt32(lastJVNumber.FirstOrDefault().JVNumber) + 0000000001;
JVNumberResult = zeroFill(JVNumber, 10);
}
Data.TrnJournalVoucher newJournalVoucher = new Data.TrnJournalVoucher();
newJournalVoucher.BranchId = currentBranchId();
newJournalVoucher.JVNumber = JVNumberResult;
newJournalVoucher.ManualJVNumber = "NA";
newJournalVoucher.JVDate = DateTime.Today;
newJournalVoucher.Particulars = "NA";
newJournalVoucher.PreparedById = userId;
newJournalVoucher.CheckedById = userId;
newJournalVoucher.ApprovedById = userId;
newJournalVoucher.IsLocked = false;
newJournalVoucher.CreatedById = userId;
newJournalVoucher.CreatedDateTime = DateTime.Now;
newJournalVoucher.UpdatedById = userId;
newJournalVoucher.UpdatedDateTime = DateTime.Now;
db.TrnJournalVouchers.InsertOnSubmit(newJournalVoucher);
db.SubmitChanges();
return(newJournalVoucher.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage updateJournalVoucher(String id, Models.TrnJournalVoucher journalVoucher)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var journalVouchers = from d in db.TrnJournalVouchers where d.Id == Convert.ToInt32(id) select d;
if (journalVouchers.Any())
{
var updateJournalVoucher = journalVouchers.FirstOrDefault();
updateJournalVoucher.BranchId = journalVoucher.BranchId;
updateJournalVoucher.JVNumber = journalVoucher.JVNumber;
updateJournalVoucher.ManualJVNumber = journalVoucher.ManualJVNumber;
updateJournalVoucher.JVDate = Convert.ToDateTime(journalVoucher.JVDate);
updateJournalVoucher.Particulars = journalVoucher.Particulars;
updateJournalVoucher.PreparedById = journalVoucher.PreparedById;
updateJournalVoucher.CheckedById = journalVoucher.CheckedById;
updateJournalVoucher.ApprovedById = journalVoucher.ApprovedById;
updateJournalVoucher.IsLocked = true;
updateJournalVoucher.UpdatedById = userId;
updateJournalVoucher.UpdatedDateTime = DateTime.Now;
postJournal.insertJVJournal(Convert.ToInt32(id));
db.SubmitChanges();
updateBalances(Convert.ToInt32(id));
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}