public ActionResult AddEmp()
 {
     teethLabEntities db = new teethLabEntities();
     string name = Request.Form["name"];
     employee emp = new employee();
     emp.name = name;
     db.employees.Add(emp);
     db.SaveChanges();
     return Redirect(Url.Action("Index", "Employee"));
 }
Exemple #2
0
        public ActionResult register()
        {
            string name = Request.Form["name"];
            string password = Request.Form["password"];
            string passwordConfirm = Request.Form["confirmPassword"];
            teethLabEntities db = new teethLabEntities();
            if (db.users.Where(o => o.name == name).Count() > 0)
            {

                TempData["error"] = "الاسم موجود مسبقآ , رجاء اختيار اسم اخر";

                return Redirect(Url.Action("viewRegister", "user"));
            }
            if (password != passwordConfirm)
            {
                TempData["error"] = "الرقم السري غير مطابق";
                return Redirect(Url.Action("viewRegister", "user"));
            }

            user user = new user();
            user.name = name;
            user.password = password;
            db.users.Add(user);
            db.SaveChanges();
            TempData["error"] = "تمت الاضافه بنجاح";
            return Redirect(Url.Action("viewRegister", "user"));
        }
 public void DeleteEmp()
 {
     int empId = int.Parse(Request.Form["id"]);
     teethLabEntities db = new teethLabEntities();
     db.Entry(db.employees.Find(empId)).State = System.Data.EntityState.Deleted;
     db.SaveChanges();
     Response.Write("success");
 }
 public ActionResult AddSup()
 {
     teethLabEntities db = new teethLabEntities();
     string name = Request.Form["name"];
     supplier sup = new supplier();
     sup.name = name;
     db.suppliers.Add(sup);
     db.SaveChanges();
     return Redirect(Url.Action("Index", "Supplier"));
 }
 public ActionResult AddCom()
 {
     teethLabEntities db = new teethLabEntities();
     string name = Request.Form["name"];
     company comp = new company();
     comp.name = name;
     db.companies.Add(comp);
     db.SaveChanges();
     return Redirect(Url.Action("viewAllCompanies", "Company"));
 }
Exemple #6
0
        public ActionResult login()
        {
            string name = Request.Form["name"];
            string password = Request.Form["password"];
            teethLabEntities db = new teethLabEntities();
            if (db.users.Where(u => u.name == name && u.password == password).Count() > 0)
            {
                user user = db.users.Where(u => u.name == name && u.password == password).First();
                Session.Add("userId", user.id);
                return Redirect(Url.Action("Index" , "Home"));
            }

            TempData["error"] = "الاسم او الرقم السري غير صحيح";
            return Redirect(Url.Action("viewLogin", "user"));
        }
        public void activateDoc()
        {
            teethLabEntities db = new teethLabEntities();
            int docId = int.Parse(Request.Form["id"]);

            doctor doc = db.doctors.Find(docId);
            db.Entry(doc).State = System.Data.EntityState.Modified;
            if (doc.isActive)
            {
                doc.isActive = false;
            }
            else
            {
                doc.isActive = true;
            }
            db.SaveChanges();
            Response.Write("success");
        }
        public ActionResult addDoc()
        {
            string name = Request.Form["name"];
            string address = Request.Form["address"];
            int supplierId = int.Parse(Request.Form["supplier"]);

            teethLabEntities db = new teethLabEntities();
            doctor doc = new doctor();
            doc.name = name;
            doc.address = address;
            doc.depit = 0;
            doc.isActive = false;
            if (supplierId != 0)
                doc.supplierId = supplierId;
            db.doctors.Add(doc);
            db.SaveChanges();

            return Redirect(Url.Action("Index", "Doctor"));
        }
        public void addNewCase(string casename, int caseDefaultPrice)
        {
            teethLabEntities db = new teethLabEntities();
            @case cas = new @case();
            cas.name = casename;
            cas.defaultPrice = caseDefaultPrice;
            db.Entry(cas).State = System.Data.EntityState.Added;
            db.cases.Add(cas);
            db.SaveChanges();

            this.addDefaultCasePrices(cas);
        }
 public void addDefaultCasePrices(@case cas)
 {
     teethLabEntities db = new teethLabEntities();
     List<doctor> docs = db.doctors.Where(d=>d.isActive==true). ToList();
     foreach (doctor doc in docs)
     {
         this.addNewCasePrice(doc.id, cas.id, cas.defaultPrice);
     }
 }
 public ActionResult viewCurrentCases()
 {
     teethLabEntities db = new teethLabEntities();
     List<@case> cases = db.cases.ToList();
     ViewData["cases"] = cases;
     return View();
 }
Exemple #12
0
        private List<employee> getEmpsByName(string name)
        {
            teethLabEntities db = new teethLabEntities();

            if (db.employees.Where(e => e.name.Contains(name)).Count() > 0)
            {
                return db.employees.Where(e => e.name.Contains(name)).ToList();
            }
            return null;
        }
Exemple #13
0
        public void export()
        {
            int cost = 0;
            try
            {
                cost = int.Parse(Request.Form["cost"]);
            }
            catch (Exception e)
            {
                return;
            }
            int id = 0;
            try
            {
                id = int.Parse(Request.Form["id"]);
            }
            catch (Exception e)
            {

            }

            string name = Request.Form["name"];
            if (name == "" || name == null)
            {
                return;
            }
            string type = Request.Form["type"];

            teethLabEntities db = new teethLabEntities();

            int dayId = 0;
            DateTime day;
            CultureInfo enUS = new CultureInfo("en-US");
            DateTime.TryParseExact(Request.Form["day"], "yyyy-MM-dd", enUS,
                        DateTimeStyles.None, out day);

            moneyDay md = new moneyDay();

            if (db.moneyDays.Where(o => o.day.Year == day.Year
            && o.day.Month == day.Month
                && o.day.Day == day.Day).Count() > 0)
            {
                md = db.moneyDays.Where(o => o.day.Year == day.Year
                && o.day.Month == day.Month
                && o.day.Day == day.Day
                ).First();
                md.credit -= cost;
                db.Entry(md).State = System.Data.EntityState.Modified;

            }
            else
            {
                return;
            }

            db.SaveChanges();
            dayId = md.id;

            db = new teethLabEntities();
            money m = new money();
            m.dayId = dayId;

            m.fromTo = name;

            m.type = "export";
            m.value = cost;
            m.recieveDate = DateTime.Now;

            if (type == "new")
            {

            }
            else if (type == "Doctor")
            {
                m.doctorId = id;
            }
            else if (type == "Company")
            {
                m.companyId = id;
            }
            else if (type == "Employee")
            {
                m.employeeId = id;
            }

            db.Entry(m).State = System.Data.EntityState.Added;
            db.moneys.Add(m);
            db.SaveChanges();

            db = new teethLabEntities();
            if (type == "Company")
            {

                product p = new product();
                p.companyId = id;
                p.enterDate = day;
                p.name = name;//
                p.isFinished = false;
                p.price = cost;
                db.Entry(p).State = System.Data.EntityState.Added;

            }
            else if (type == "Doctor")
            {
                doctor doc = db.doctors.Find(id);
                db.Entry(doc).State = System.Data.EntityState.Modified;
                doc.depit += cost;

            }
            db.SaveChanges();
            Response.Write("success");
        }
Exemple #14
0
        //
        // GET: /Money/
        // sadrat w wardat
        public ActionResult Index()
        {
            teethLabEntities db = new teethLabEntities();
            List<doctor> doctors = db.doctors.Where(d => d.isActive == true).ToList();
            ViewData["doctors"] = doctors;
            ViewData["emps"] = db.employees.ToList();
            ViewData["companies"] = db.companies.ToList();
            DateTime now = DateTime.Now;
            int credit = 0;

            if (db.moneyDays.Where(o => o.day.Year == now.Year
                && o.day.Month == now.Month
                && o.day.Day == now.Day
                ).Count() <= 0)
            {
                //get last day credit
                int lastId = db.moneyDays.Max(o => o.id);
                credit = 0;
                if (lastId != 0)
                {
                    credit = db.moneyDays.Find(lastId).credit;
                }
                moneyDay md = new moneyDay();
                md.credit = credit;
                md.day = now;
                db.moneyDays.Add(md);
                db.SaveChanges();
            }
            else
            {

                credit = db.moneyDays.Where(o => o.day.Year == now.Year
                && o.day.Month == now.Month
                && o.day.Day == now.Day
                ).First().credit;
            }
            ViewData["credit"] = credit;
            return View();
        }
 public void editCase(int id, string casename, int defaultPrice)
 {
     teethLabEntities db = new teethLabEntities();
     @case cas = db.cases.Find(id);
     cas.name = casename;
     cas.defaultPrice = defaultPrice;
     db.Entry(cas).State = System.Data.EntityState.Modified;
     db.SaveChanges();
 }
        //reference from #inputBtn , #outPrint in follow up cases,
        public void addCase()
        {
            try
            {

            int doctorId = int.Parse(Request.Form["doctorId"]);
            int caseId = int.Parse(Request.Form["caseId"]);
            string caseColor = Request.Form["caseColor"];
            string patientName = Request.Form["patientName"];
            string notes = Request.Form["notes"];
            DateTime recieveDate;
            CultureInfo enUS = new CultureInfo("en-US");
            DateTime.TryParseExact(Request.Form["recieveDate"], "yyyy-MM-dd", enUS,
                        DateTimeStyles.None, out recieveDate);
            string caseTeeth = Request.Form["caseTeeth"];
            DateTime enterdate;
             enUS = new CultureInfo("en-US");
            DateTime.TryParseExact(Request.Form["day"], "yyyy-MM-dd", enUS,
                        DateTimeStyles.None, out enterdate);

            teethLabEntities db = new teethLabEntities();

            //get price
            int price = db.caseDoctorPrices.Where(o => o.doctorId == doctorId && o.caseId == caseId).First().price ;

            //get last case number

             string newMonth = Request.Form["newMonth"];

                int caseNumber = this.NewCaseNumber();

            int numCases = int .Parse( Request.Form["numCases"]);

            string year = DateTime.Now.Year.ToString();
            string month = DateTime.Now.Month.ToString();
            if (int.Parse(month) < 10)
            {
                month = "0" + month;
            }
            string day = DateTime.Now.Day.ToString();
            if (int.Parse(day) < 10)
            {
                day = "0" + day;
            }
            price *= numCases;
                string action = Request.Form["action"];
                transaction tran = new transaction();
                if (action == "inputProva")
                {
                    int id = int.Parse(Request.Form["transId"]);
                     tran = db.transactions.Find(id);
                     tran.notes = notes + "*Case Input Prova at " + DateTime.Now.ToString("yyyy-MM-dd") + "*";
                     tran.isOut = false;
                     tran.prova = true;

                }
                else if (action == "inputCase")
                {
                    tran = new transaction();
                    tran.caseNumber = caseNumber;
                    tran.notes = notes;
                    tran.isOut = false;
                    tran.prova = false;
                    tran.recieveDate = enterdate;
                }
                else if (action == "outCase")
                {
                    int id = int.Parse(Request.Form["transId"]);
                    tran = db.transactions.Find(id);
                    tran.notes = notes + "*Case Out at " + DateTime.Now.ToString("yyyy-MM-dd") + "*";
                    tran.isOut = true;
                    tran.prova = false;

                    Session["transId"] = id;
                }
                else if (action == "outProva")
                {
                    int id = int.Parse(Request.Form["transId"]);
                    tran = db.transactions.Find(id);
                    tran.prova = true;
                    tran.notes = notes + "*Case Out Prova at " + DateTime.Now.ToString("yyyy-MM-dd") + "*";
                    tran.isOut = true;

                }
                else
                {
                    return;
                }
            tran.caseTeeth = caseTeeth;
            tran.caseColor = caseColor;
            tran.price = price;
            tran.patientName = patientName;
            tran.toRecieveDate = recieveDate;

            tran.caseId = caseId;
            tran.doctorId = doctorId;
            db.transactions.Add(tran);
            if (action == "inputProva" || action == "outCase" || action == "outProva")
            {
                db.Entry(tran).State = System.Data.EntityState.Modified;
            }
            else if (action == "inputCase" )
            {
                db.Entry(tran).State = System.Data.EntityState.Added;
            }
            db.SaveChanges();
            Response.Write("success," + price + "," + recieveDate.Month+"/"+recieveDate.Day+"/"+caseNumber);
            }
            catch (Exception e)
            {
                Response.Write("error");
            }
        }
 //
 // GET: /Supplier/
 // all suppliers , add and delete
 public ActionResult Index()
 {
     teethLabEntities db = new teethLabEntities();
     ViewData["suppliers"] = db.suppliers.ToList();
     return View();
 }
Exemple #18
0
        //view sadrat and wardat in specific day
        public ActionResult viewMoneyDays()
        {
            teethLabEntities db = new teethLabEntities();
            List<doctor> doctors = db.doctors.Where(d => d.isActive == true).ToList();
            ViewData["doctors"] = doctors;
            ViewData["emps"] = db.employees.ToList();
            ViewData["companies"] = db.companies.ToList();

            this.newDay();

            ViewData["credit"] = this.currentCredit;

            ViewData["moneyDay"] = this.currentMoneyDay;
            return View();
        }
Exemple #19
0
        private List<company> getCompaniesByName(string name)
        {
            teethLabEntities db = new teethLabEntities();

            if (db.companies.Where(c => c.name.Contains(name)).Count() > 0)
            {
                return db.companies.Where(c => c.name.Contains(name)).ToList();
            }
            return null;
        }
 /// <summary>
 /// addd , delete company
 /// </summary>
 /// <returns></returns>
 public ActionResult viewAllCompanies()
 {
     teethLabEntities db = new teethLabEntities();
     ViewData["companies"] = db.companies.ToList();
     return View();
 }
Exemple #21
0
        private void newDay()
        {
            moneyDay md = null;

            DateTime day;
            FileStream fs = new FileStream(Server.MapPath("~") + "/Content/files/startdate.txt", FileMode.Open);

            StreamReader sr = new StreamReader(fs);

            string date = sr.ReadToEnd();
            sr.Close();
            fs.Close();
            System.Globalization.CultureInfo enUS = new System.Globalization.CultureInfo("en-US");
            DateTime.TryParseExact(date, "yyyy-MM-dd", enUS,
                                      System.Globalization.DateTimeStyles.None, out day);

            teethLabEntities db = new teethLabEntities();

            int credit = 0;

            if (db.moneyDays.Where(o => o.day.Year == day.Year &&
              o.day.Month == day.Month &&
               o.day.Day == day.Day
              ).Count() > 0)
            {

                md = db.moneyDays.Where(o => o.day.Year == day.Year &&
              o.day.Month == day.Month &&
               o.day.Day == day.Day).First();

                credit = md.credit;
            }
            else
            {

                //get last day credit
                int lastId = db.moneyDays.Max(o => o.id);
                credit = 0;
                if (lastId != 0)
                {
                    credit = db.moneyDays.Find(lastId).credit;
                }
                md = new moneyDay();
                md.credit = credit;
                md.day = day;
                db.moneyDays.Add(md);
                db.SaveChanges();

            }
            this.currentMoneyDay = md;
            this.currentCredit = credit;
        }
        public void addNewCasePrice(int docId , int caseId , int price )
        {
            caseDoctorPrice cp = new caseDoctorPrice();
            cp.caseId = caseId;
            cp.doctorId = docId;
            cp.price = price;

            teethLabEntities db = new teethLabEntities();
            db.caseDoctorPrices.Add(cp);
            db.SaveChanges();
        }
 public void DeleteCaseById(int caseid)
 {
     teethLabEntities db = new teethLabEntities();
     @case cas =  db.cases.Find(caseid);
     if (cas != null)
     {
         db.Entry(cas).State = System.Data.EntityState.Deleted;
         db.SaveChanges();
     }
 }
        public void getCaseByNumber()
        {
            try
            {

                int caseNumber = int.Parse(Request.Form["number"]);
                int caseDay = int.Parse(Request.Form["day"]);
                int caseMonth = int.Parse(Request.Form["month"]);
                teethLabEntities db = new teethLabEntities();
                db.Configuration.ProxyCreationEnabled = false;
                transaction trans = db.transactions.Where(c => c.caseNumber == caseNumber && c.recieveDate.Day == caseDay
                    && c.recieveDate.Month == caseMonth && c.recieveDate.Year == DateTime.Now.Year).First();
                Response.Write("success^" + JsonConvert.SerializeObject(trans ));

                Json(trans, JsonRequestBehavior.AllowGet);
                //Json.Write(trans, Response.Output);
            }
            catch (Exception e)
            {

            }
        }
Exemple #25
0
        public ActionResult MoneyDays()
        {
            DateTime day;
            CultureInfo enUS = new CultureInfo("en-US");
            DateTime.TryParseExact(Request.Form["day"], "yyyy-MM-dd", enUS,
                        DateTimeStyles.None, out day);
            teethLabEntities db = new teethLabEntities();
            moneyDay md = null;
            if (db.moneyDays.Where(o => o.day.Year == day.Year &&
              o.day.Month == day.Month &&
               o.day.Day == day.Day
              ).Count() > 0)
            {

                md = db.moneyDays.Where(o => o.day.Year == day.Year &&
              o.day.Month == day.Month &&
               o.day.Day == day.Day).First();
            }

            TempData["moneyDay"] = md;
            return Redirect(Url.Action("viewMoneyDays", "Money"));
        }
        //
        // GET: /Transaction/
        /// <summary>
        /// add case
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            if (Request.Form["day"] != "" && Request.Form["day"] != null)
            {

                DateTime day ;
                CultureInfo enUS = new CultureInfo("en-US");
                DateTime.TryParseExact(Request.Form["day"], "yyyy-MM-dd", enUS,
                            DateTimeStyles.None, out day);
                ViewData["date"] = day;
            }
            else
            {
                ViewData["date"] = DateTime.Now;
            }
            teethLabEntities db = new teethLabEntities();
            List<doctor> doctors = db.doctors.Where(d => d.isActive == true).ToList();
            List<teethLab.@case> cases = db.cases.ToList();
            ViewData["doctors"] = doctors;
            ViewData["cases"] = cases;
            return View();
        }
 //
 // GET: /Employee/
 /// <summary>
 /// add , delete employees
 /// </summary>
 /// <returns></returns>
 public ActionResult Index()
 {
     teethLabEntities db = new teethLabEntities();
     ViewData["emps"] = db.employees.ToList();
     return View();
 }
        public int NewCaseNumber()
        {
            teethLabEntities db = new teethLabEntities();
            int lastCaseNumber;

            if (this.monthChanged())
            {
                lastCaseNumber = 0;
            }
            else
            {
                lastCaseNumber = db.transactions.Max(o => o.caseNumber);
            }
            lastCaseNumber++;
            return lastCaseNumber;
        }
        public void getCaseById()
        {
            try
            {
                int caseId = int.Parse(Request.Form["caseId"]);
                teethLabEntities db = new teethLabEntities();
                if (db.transactions.Where(c => c.caseNumber == caseId).Count() > 0)
                {
                    db.Configuration.ProxyCreationEnabled = false;
                    transaction trans = db.transactions.Where(c => c.caseNumber == caseId).First();
                    Response.Write("success^" + JsonConvert.SerializeObject(trans));
                }
            }catch(Exception e){

            }
        }
Exemple #30
0
        private List<doctor> getDocsByName(string name)
        {
            teethLabEntities db = new teethLabEntities();

            if (db.doctors.Where(d => d.name.Contains(name)).Count() > 0)
            {
                return db.doctors.Where(d => d.name.Contains(name)).ToList();
            }
            return null;
        }