Beispiel #1
0
        public float yesterdayImmigration()
        {
            string franchid = help.Permission();

            // DateTime today = System.DateTime.Now;
            if (franchid == "Admin")
            {
                ApplicationRecipt ee2 = db.ApplicationRecipts.FirstOrDefault(x => x.Date == yesterday);
                if (ee2 != null)
                {
                    return((db.ApplicationRecipts.Where(x => x.Date == yesterday)).Sum(x => x.Amount));
                }
                else
                {
                    return(0);
                }
            }

            ApplicationRecipt ee = db.ApplicationRecipts.FirstOrDefault(x => x.Date == yesterday);

            if (ee != null)
            {
                return((db.ApplicationRecipts.Where(x => x.Date == yesterday)).Sum(x => x.Amount));
            }
            else
            {
                return(0);
            }
        }
        public ActionResult UpdateLetter(Offerletter Emp, ApplicationRecipt Recipt, Helper Help) // Record Insert
        {
            db.Entry(Emp).State = EntityState.Modified;
            db.SaveChanges();
            var inquiry = db.Applications.FirstOrDefault(x => x.ApplicationNo == Emp.ApplicationNo).InquiryId;

            return(RedirectToAction("Create", "Application", new { id = inquiry }));
        }
        //public ActionResult InsertOffer(Offerletter off,int country,int college,int course)
        //{

        //    off.Cid = country;
        //    off.Oid = college;
        //    off.CCid = course;
        //    db.Offerletter.Add(off);
        //    db.SaveChanges();
        //    TempData["Success"] = "Offerletter Detail Successfully";
        //    return View();
        //}

        public JsonResult Payment(Helper Help, ApplicationRecipt Recipt, Leader ll, Helper help)
        {
            using (var transaction = db.Database.BeginTransaction())
            {
                try
                {
                    // Recipt.Date = System.DateTime.Now;
                    var    inquiryid = db.Applications.FirstOrDefault(x => x.ApplicationNo == Recipt.ApplicationNo).InquiryId;
                    online onlines   = db.onlines.FirstOrDefault(x => x.inquiryid == inquiryid);
                    string franchise = Help.Consoller();
                    // Recipt.ApplicationNo = Emp.ApplicationNo;
                    Recipt.Leadger = db.Ledgers.FirstOrDefault(x => x.ApplicationNo == Recipt.ApplicationNo && x.Franchid == franchise).LeaderNo;

                    Recipt.ReciptNo = Help.recipt();

                    Recipt.RecivedBy = Help.Teacher();
                    Recipt.Date      = System.DateTime.Now;
                    db.ApplicationRecipts.Add(Recipt);
                    db.SaveChanges();
                    ll = db.Ledgers.FirstOrDefault(x => x.ApplicationNo == Recipt.ApplicationNo);
                    if (ll != null)
                    {
                        int recived = ll.Received;
                        ll.Received        = recived + Recipt.Amount;
                        db.Entry(ll).State = EntityState.Modified;
                        db.SaveChanges();
                    }
                    Process pr = db.Process.FirstOrDefault(x => x.ApplicationNo == Recipt.ApplicationNo);
                    if (pr.Offerletter == false)
                    {
                        var Process = db.Process.SingleOrDefault(x => x.ApplicationNo == Recipt.ApplicationNo);
                        if (Process != null)
                        {
                            Process.Offerletter = true;

                            db.SaveChanges();
                        }
                    }
                    if (Recipt.sms == true)
                    {
                        help.sendsms(onlines.Mobile, "Hello," + onlines.Name + " Thank you For Deposit  ");
                    }
                    transaction.Commit();
                    return(Json(Recipt, JsonRequestBehavior.AllowGet));
                }
                catch (Exception)
                {
                    throw;
                }
            }
        }
        public JsonResult InsertOffer(Offerletter Emp, ApplicationRecipt Recipt, Helper Help) // Record Insert
        {
            using (var transaction = db.Database.BeginTransaction())
            {
                try
                {
                    Emp.Show = true;

                    db.Offerletter.Add(Emp);
                    db.SaveChanges();
                    Recipt.Date          = System.DateTime.Now;
                    Recipt.ApplicationNo = Emp.ApplicationNo;
                    Recipt.Leadger       = db.Ledgers.FirstOrDefault(x => x.ApplicationNo == Emp.ApplicationNo).LeaderNo;
                    Recipt.Type          = "Offer Letter";
                    Recipt.ReciptNo      = Help.recipt();
                    Recipt.Amount        = Emp.Amount;
                    Recipt.RecivedBy     = Help.Teacher();
                    db.ApplicationRecipts.Add(Recipt);
                    db.SaveChanges();
                    Process pr = db.Process.FirstOrDefault(x => x.ApplicationNo == Emp.ApplicationNo);
                    if (pr.Medical == false)
                    {
                        var Process = db.Process.SingleOrDefault(x => x.ApplicationNo == Emp.ApplicationNo);
                        if (Process != null)
                        {
                            Process.Offerletter = true;

                            db.SaveChanges();
                        }
                    }
                    transaction.Commit();
                    TempData["Success"] = "Data Save Sucessfully";
                    return(Json(Emp, JsonRequestBehavior.AllowGet));
                }
                catch (Exception e)
                {
                    string a = e.Message;
                    transaction.Rollback();
                    throw;
                }
            }
        }
Beispiel #5
0
        public float TodayImmigration()
        {
            string franchid = help.Permission();

            if (franchid == "Admin")
            {
                return((db.ApplicationRecipts.Where(x => x.Date == today)).Select(x => x.Amount).DefaultIfEmpty(0).Sum());
            }
            //  DateTime today = System.DateTime.Now;
            ApplicationRecipt ee = db.ApplicationRecipts.FirstOrDefault(x => x.Date == today);

            if (ee != null)
            {
                return((db.ApplicationRecipts.Where(x => x.Date == today)).Sum(x => x.Amount));
            }
            else
            {
                return(0);
            }
        }