Beispiel #1
0
        public Int32 postStockCount()
        {
            try
            {
                Data.TrnStockCount newStockCount = new Data.TrnStockCount();
                newStockCount.PeriodId         = SalesId();
                newStockCount.StockCountDate   = DateTime.Today;
                newStockCount.StockCountNumber = "n/a";
                newStockCount.Remarks          = "n/a";
                newStockCount.PreparedBy       = UserId();
                newStockCount.CheckedBy        = UserId();
                newStockCount.ApprovedBy       = UserId();
                newStockCount.IsLocked         = 0;
                newStockCount.EntryUserId      = UserId();
                newStockCount.EntryDateTime    = DateTime.Today;
                newStockCount.UpdateUserId     = UserId();
                newStockCount.UpdateDateTime   = DateTime.Today;
                db.TrnStockCounts.InsertOnSubmit(newStockCount);
                db.SubmitChanges();

                return(newStockCount.Id);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
Beispiel #2
0
        public Int32 insertStockCount(Models.TrnStockCount stockCount)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();

                var lastSCNumber   = from d in db.TrnStockCounts.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d;
                var SCNumberResult = "0000000001";

                if (lastSCNumber.Any())
                {
                    var SCNumber = Convert.ToInt32(lastSCNumber.FirstOrDefault().SCNumber) + 0000000001;
                    SCNumberResult = zeroFill(SCNumber, 10);
                }

                Data.TrnStockCount newStockCount = new Data.TrnStockCount();
                newStockCount.BranchId        = currentBranchId();
                newStockCount.SCNumber        = SCNumberResult;
                newStockCount.SCDate          = DateTime.Today;
                newStockCount.Particulars     = "NA";
                newStockCount.PreparedById    = userId;
                newStockCount.CheckedById     = userId;
                newStockCount.ApprovedById    = userId;
                newStockCount.IsLocked        = false;
                newStockCount.CreatedById     = userId;
                newStockCount.CreatedDateTime = DateTime.Now;
                newStockCount.UpdatedById     = userId;
                newStockCount.UpdatedDateTime = DateTime.Now;

                db.TrnStockCounts.InsertOnSubmit(newStockCount);
                db.SubmitChanges();

                return(newStockCount.Id);
            }
            catch
            {
                return(0);
            }
        }
        public HttpResponseMessage AddStockCount()
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.UserId == User.Identity.GetUserId()
                                  select d;

                if (currentUser.Any())
                {
                    var currentUserId   = currentUser.FirstOrDefault().Id;
                    var currentBranchId = currentUser.FirstOrDefault().BranchId;

                    var userForms = from d in db.MstUserForms
                                    where d.UserId == currentUserId &&
                                    d.SysForm.FormName.Equals("StockCountList")
                                    select d;

                    if (userForms.Any())
                    {
                        if (userForms.FirstOrDefault().CanAdd)
                        {
                            var defaultSCNumber = "0000000001";
                            var lastStockCount  = from d in db.TrnStockCounts.OrderByDescending(d => d.Id)
                                                  where d.BranchId == currentBranchId
                                                  select d;

                            if (lastStockCount.Any())
                            {
                                var SCNumber = Convert.ToInt32(lastStockCount.FirstOrDefault().SCNumber) + 0000000001;
                                defaultSCNumber = FillLeadingZeroes(SCNumber, 10);
                            }

                            var users = from d in db.MstUsers.OrderBy(d => d.FullName)
                                        where d.IsLocked == true
                                        select d;

                            if (users.Any())
                            {
                                Data.TrnStockCount newStockCount = new Data.TrnStockCount
                                {
                                    BranchId        = currentBranchId,
                                    SCNumber        = defaultSCNumber,
                                    SCDate          = DateTime.Today,
                                    Particulars     = "NA",
                                    PreparedById    = currentUserId,
                                    CheckedById     = currentUserId,
                                    ApprovedById    = currentUserId,
                                    IsPrinted       = false,
                                    IsLocked        = false,
                                    CreatedById     = currentUserId,
                                    CreatedDateTime = DateTime.Now,
                                    UpdatedById     = currentUserId,
                                    UpdatedDateTime = DateTime.Now
                                };

                                db.TrnStockCounts.InsertOnSubmit(newStockCount);
                                db.SubmitChanges();

                                String newObject = at.GetObjectString(newStockCount);
                                at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);

                                return(Request.CreateResponse(HttpStatusCode.OK, newStockCount.Id));
                            }
                            else
                            {
                                return(Request.CreateResponse(HttpStatusCode.NotFound, "No user found. Please setup more users for all transactions."));
                            }
                        }
                        else
                        {
                            return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add stock count."));
                        }
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this stock count page."));
                    }
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
            }
        }
        public int Post(Models.TrnStockCount stockCount)
        {
            try
            {
                var isLocked = 1;
                var identityUserId = User.Identity.GetUserId();
                var mstUserId = (from d in db.MstUsers where "" + d.Id == identityUserId select d.Id).SingleOrDefault();
                var date = DateTime.Now;

                Data.TrnStockCount newStockCount = new Data.TrnStockCount();

                newStockCount.PeriodId = stockCount.PeriodId;
                newStockCount.StockCountDate = Convert.ToDateTime(stockCount.StockCountDate);
                newStockCount.StockCountNumber = stockCount.StockCountNumber;
                newStockCount.Remarks = stockCount.Remarks;
                newStockCount.PreparedBy = stockCount.PreparedBy;
                newStockCount.CheckedBy = stockCount.CheckedBy;
                newStockCount.ApprovedBy = stockCount.ApprovedBy;
                newStockCount.IsLocked = isLocked;
                newStockCount.EntryUserId = mstUserId;
                newStockCount.EntryDateTime = date;
                newStockCount.UpdateUserId = mstUserId;
                newStockCount.UpdateDateTime = date;

                db.TrnStockCounts.InsertOnSubmit(newStockCount);
                db.SubmitChanges();

                return newStockCount.Id;
            }
            catch
            {
                return 0;
            }
        }
        public Int32 insertStockCount(Models.TrnStockCount stockCount)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();

                var lastSCNumber = from d in db.TrnStockCounts.OrderByDescending(d => d.Id) select d;
                var SCNumberResult = "0000000001";

                if (lastSCNumber.Any())
                {
                    var SCNumber = Convert.ToInt32(lastSCNumber.FirstOrDefault().SCNumber) + 0000000001;
                    SCNumberResult = zeroFill(SCNumber, 10);
                }

                Data.TrnStockCount newStockCount = new Data.TrnStockCount();
                newStockCount.BranchId = currentBranchId();
                newStockCount.SCNumber = SCNumberResult;
                newStockCount.SCDate = DateTime.Today;
                newStockCount.Particulars = "NA";
                newStockCount.PreparedById = userId;
                newStockCount.CheckedById = userId;
                newStockCount.ApprovedById = userId;
                newStockCount.IsLocked = false;
                newStockCount.CreatedById = userId;
                newStockCount.CreatedDateTime = DateTime.Now;
                newStockCount.UpdatedById = userId;
                newStockCount.UpdatedDateTime = DateTime.Now;

                db.TrnStockCounts.InsertOnSubmit(newStockCount);
                db.SubmitChanges();

                return newStockCount.Id;
            }
            catch
            {
                return 0;
            }
        }