예제 #1
0
        public JsonResult Addstore(string snumber, string sname, string connstring)
        {
            try
            {
                StoreModel sm = new StoreModel();

                if (!ValidationUtility.IsNull(snumber) && !ValidationUtility.IsNull(sname))
                {
                    int storeNumber = ValidationUtility.ToInteger(snumber);
                    bool flag = sm.IsStoreExist(storeNumber, sname);

                    if (!flag)
                    {

                        StoreDTO storeDTO = new StoreDTO();
                        storeDTO.StoreNumber = storeNumber;
                        storeDTO.StoreName = sname;
                        storeDTO.ConnectionString = connstring;

                        sm.AddInactiveStore(storeDTO);

                        string msg = "Recored Added Successfully";
                        return Json(msg, JsonRequestBehavior.AllowGet);

                        //if (!ValidationUtility.IsNull(connstring))
                        //{
                        //    sm.AddStore(storeNumber, sname, connstring);
                        //    string msg = "Recored Added Successfully";
                        //    return Json(msg, JsonRequestBehavior.AllowGet);
                        //}
                        //else
                        //{
                        //    StoreDTO storeDTO = new StoreDTO();
                        //    storeDTO.StoreNumber = storeNumber;
                        //    storeDTO.StoreName = sname;

                        //    sm.AddInactiveStore(storeDTO);

                        //}

                    }
                    else
                    {
                        string msg = "Store Already Exist";
                        return Json(msg, JsonRequestBehavior.AllowGet);

                    }
                }
            }
            catch (Exception ex)
            {

            }
            string msg1 = " Recored Not Added Successfully ";
            return Json(msg1, JsonRequestBehavior.AllowGet);
        }
        public void UpdateRecordSale()
        {
            try
            {
                log.Info(" UpdateRecordSale Start Time  is " + DateTime.Now);

                ArrayList weekDayList = new ArrayList();

                string weekOfDay = DateTime.Now.AddDays(-1).DayOfWeek.ToString();

                weekDayList.Add(weekOfDay);

                log.Info(" Day Of week " + DateTime.Now.AddDays(-1).DayOfWeek.ToString());

                //weekDayList.Add("Thursday");
                //weekDayList.Add("Friday");
                //weekDayList.Add("Saturday");
                //weekDayList.Add("Sunday");
                //weekDayList.Add("Monday");
                //weekDayList.Add("Tuesday");

                StoreModel sm = new StoreModel();

                // Get All Store List from local database
              //  ArrayList list = sm.GetStoreList();

                ArrayList list = ValidationUtility.GetActiveStoreList(true);

                foreach (StoreDTO dto in list)
                {
                    ArrayList recordSale = new ArrayList();

                    foreach (string s in weekDayList)
                    {
                        //Get Business day record (which is high in year)
                        DataTable dt = GetWeekDayRecord(dto.ConnectionString, s);
                        RecordSalesDTO recordSaleDto = new RecordSalesDTO();

                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            recordSaleDto.BusinessDate = (DateTime)dt.Rows[i]["BusinessDate"];
                            recordSaleDto.DayOfWeek = dt.Rows[i]["WeekOfDay"].ToString();
                            recordSaleDto.SalesAmount = ValidationUtility.ToDouble(dt.Rows[i]["PerDaySale"].ToString());
                            recordSaleDto.StoreId = dto.Id;
                        }

                        recordSale.Add(recordSaleDto);

                    }

                    // Now Update Records
                    foreach (RecordSalesDTO rsDto in recordSale)
                    {
                        UpdateStore(rsDto, dto.ConnectionString);
                    }
                }

                // UpdateLast sale
                foreach (StoreDTO dto in list)
                {

                    RecordSaleModel rsm = new RecordSaleModel();

                    log.Info("Record update for StorId " + dto.Id);

                    log.Info("Last Perday sale date " + DateTime.Now.AddDays(-1));

                    double perDaySalesAmount = GetPerDayUpdatedSalesAmount(dto.ConnectionString, DateTime.Now.AddDays(-1));

                    log.Info("Last date perday sales amount " + perDaySalesAmount);

                    int opId = rsm.GetCurrentDateOpeningInfoId(DateTime.Now.AddDays(-1), dto.ConnectionString);

                    log.Info("Opening Information Id of last per day sales " + opId);

                    rsm.UpdatePerdaySales(perDaySalesAmount, dto.Id, DateTime.Now.AddDays(-1), opId);

                    //ArrayList lastPerDaySales = GetLastDaySalesData(DateTime.Now.AddDays(-1), DateTime.Now.AddDays(-1).DayOfWeek.ToString(), dto.Id);
                    //foreach (PerdaySalesDTO perdaySalesDTO in lastPerDaySales)
                    //{
                    //    double perDaySalesAmount = GetPerDayUpdatedSalesAmount(dto.ConnectionString, perdaySalesDTO.BusinessDate);
                    //    int opId = rsm.GetCurrentDateOpeningInfoId(perdaySalesDTO.BusinessDate, dto.ConnectionString);
                    //    rsm.UpdatePerdaySales(perDaySalesAmount, perdaySalesDTO.StoreId, perdaySalesDTO.BusinessDate, opId);

                    //}

                }

                log.Info(" End  Time " + DateTime.Now);
            }
            catch (Exception ex)
            {
                log.Error("Exception in UpdateRecordSale  ", ex);
            }
        }
예제 #3
0
        public JsonResult UpdateInActiveStore(string id, string storeName, string connectionString)
        {
            string error = "";
            string msg = "";
            try
            {
                StoreModel sm = new StoreModel();

                if (!ValidationUtility.IsNull(id))
                {
                    int sId = ValidationUtility.ToInteger(id);

                    StoreDTO dto = new StoreDTO();

                    dto.Id = sId;
                    dto.StoreName = storeName;
                    dto.ConnectionString = connectionString;
                    dto.IsActive = true;

                    sm.AddStore(dto);

                    error = "Success";
                    msg = "Store Connected Successfully";

                }
            }

            catch (Exception ex)
            {
                log.Error("Exception in UpdateInActiveStore method",ex);
                error = "Error";
                msg = " Store is not connected.";
            }

            ResponseDTO resDTO = new ResponseDTO { Error = error, Message = msg };
            return Json(resDTO, JsonRequestBehavior.AllowGet);
        }