コード例 #1
0
ファイル: editOrderDal.cs プロジェクト: tesler77/vancars
        public int editOrder()
        {
            string       external   = GlobFuncs.convertExtensionToString(this.extetions);
            editExtOrder ext        = new editExtOrder(this.externalOrderId, this.person.IdNumber, this.person.FullName, this.person.PhoneNumber, this.person.PhoneNumber, this.person.LiccensNumber, this.PickupBranch, this.ReturnBranch, this.PickupDate, this.ReturnDate, this.CarId, 18, external, this.CreditCard.number, this.CreditCard.month, this.CreditCard.year, this.CreditCard.digitNo, this.CreditCard.ownerId, this.notes);
            string       ApiAddress = GlobFuncs.GetApiAddress(this.Company, "editOrderBll");
            string       Json       = JsonConvert.SerializeObject(ext);
            string       returnFlag = GetApi.PostApi(Json, ApiAddress);

            if (returnFlag != 0.ToString())
            {
                string     b          = GlobFuncs.GetDetails(this.Company, this.CarId);
                CarDetails carDetails = new CarDetails();
                string[]   arr        = b.Split('#');
                string     str        = arr[0].Substring(2, arr[0].Length - 3).Replace("\\", "");
                carDetails = JsonConvert.DeserializeObject <CarDetails>(str);
                string   pickBr = GlobFuncs.GetBranchName(this.PickupBranch, this.Company);
                string   RetBr  = GlobFuncs.GetBranchName(this.ReturnBranch, this.Company);
                DataBase db     = new DataBase();
                string   sql    = "update OrderTable set creditCardId = '" + this.CreditCard.id + "' where RentId = " + this.orderId + ";delete from ExtensInOrder where OrderId = " + this.orderId;
                db.ExecuteNonQuery(sql);
                if (this.extetions.Count > 0)
                {
                    sql = "insert into ExtensInOrder (OrderId,ExtentionId,description,price) values";
                    foreach (Extention extention in this.extetions)
                    {
                        sql += "(" + int.Parse(db.GetMaxId("OrderTable", "RentId").ToString()) + "," + extention.id + ",'" + extention.description + "'," + extention.Price + "),";
                    }
                    sql = sql.Substring(0, sql.Length - 1);
                    db.ExecuteNonQuery(sql);
                }
                return(1);
            }
            return(0);
        }
コード例 #2
0
        public List <string> CreateExtOrder()
        {
            string        external   = GlobFuncs.convertExtensionToString(this.extetions);
            ExtOrder      ext        = new ExtOrder(this.person.IdNumber, this.person.FullName, this.person.PhoneNumber, this.person.PhoneNumber, this.person.LiccensNumber, this.PickupBranch, this.ReturnBranch, this.PickupDate, this.ReturnDate, this.CarId, 18, external, this.CreditCard.number, this.CreditCard.month, this.CreditCard.year, this.CreditCard.digitNo, this.CreditCard.ownerId, this.notes);
            string        ApiAddress = GlobFuncs.GetApiAddress(this.Company, "OrderBll");
            string        Json       = JsonConvert.SerializeObject(ext);
            string        a          = GetApi.PostApi(Json, ApiAddress);
            List <string> ordNo      = new List <string>();

            if (a != null)
            {
                a = a.Substring(1, a.Length - 2);
                ordNo.Add(a);
                string     b          = GlobFuncs.GetDetails(this.Company, this.CarId);
                CarDetails carDetails = new CarDetails();
                string[]   arr        = b.Split('#');
                string     str        = arr[0].Substring(2, arr[0].Length - 3).Replace("\\", "");
                carDetails = JsonConvert.DeserializeObject <CarDetails>(str);
                string   pickBr = GlobFuncs.GetBranchName(this.PickupBranch, this.Company);
                string   RetBr  = GlobFuncs.GetBranchName(this.ReturnBranch, this.Company);
                DataBase db     = new DataBase();
                string   sql    = "insert into OrderTable (CustomId,ExternalRentId,totalPrice,CarName,CarId,CarLevel,CompanyId,Seats,GearBox,EngineCapacity,Doors,Beags,PickupBranch,PickupBranchText,PickupDate,ReturnBranch,ReturnBranchText,ReturnDate,creditCardId,Status,notes)values" +
                                  " ('" + this.person.CustomId + "','" + a + "'," + this.totalPrice + ",'" + carDetails.CarName + "'," + this.CarId + ",'" + carDetails.CarLevel + "','" + this.Company + "','" + carDetails.Seats + "','" + carDetails.GearBox + "','" + carDetails.EngineCapacity + "','" + carDetails.Doors + "','" + carDetails.Baegs + "','" + this.PickupBranch + "','" + pickBr + "','" + this.PickupDate + "','" + this.ReturnBranch + "','" + RetBr + "','" + this.ReturnDate + "','" + this.CreditCard.id + "','2','" + this.notes + "')";
                int SuccessFlag = db.ExecuteNonQuery(sql);
                if (SuccessFlag > 0)
                {
                    ordNo.Add(db.GetMaxId("OrderTable", "RentId").ToString());
                    if (this.extetions.Count > 0)
                    {
                        sql = "insert into ExtensInOrder (OrderId,ExtentionId,description,price) values";
                        foreach (Extention extention in this.extetions)
                        {
                            sql += "(" + int.Parse(db.GetMaxId("OrderTable", "RentId").ToString()) + "," + extention.id + ",'" + extention.description + "'," + extention.Price + "),";
                        }
                        sql = sql.Substring(0, sql.Length - 1);
                        db.ExecuteNonQuery(sql);
                    }
                    return(ordNo);
                }
                ordNo.Add("Error");
            }
            else
            {
                ordNo.Add("Error");
            }
            return(ordNo);
        }