Esempio n. 1
0
File: Main.cs Progetto: plats98/TI
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            //Make sure the clicked cell isn't the header.
            if (e.RowIndex == -1 || e.ColumnIndex == -1)
            {
                return;
            }

            var datagridview = sender as DataGridView;

            AnalogSignal analogSignal = (AnalogSignal)datagridview.CurrentRow.DataBoundItem;

            // Check to make sure the cell clicked is the cell containing the combobox
            if (datagridview.Columns[e.ColumnIndex] is DataGridViewComboBoxColumn)
            {
                datagridview.BeginEdit(true);
                ((ComboBox)datagridview.EditingControl).DroppedDown = true;
            }


            if (datagridview.Columns[e.ColumnIndex].Name == MemberInfoGetting.GetMemberName(() => new AnalogSignal().Address))
            {
                AddressConfig ac = new AddressConfig(analogSignal);
                ac.StartPosition = FormStartPosition.Manual;
                ac.Location      = new Point(this.Location.X + (this.Width - ac.Width) / 2, this.Location.Y + (this.Height - ac.Height) / 2);
                ac.Show(this);
            }
        }
Esempio n. 2
0
File: Main.cs Progetto: plats98/TI
        /// <summary>
        /// Update list with combobox data
        /// </summary>
        private void updateGridData()
        {
            DataGridViewCell cell;
            AnalogSignal     analogSignal;

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                if (row.DataBoundItem == null)
                {
                    break;
                }

                analogSignal = (AnalogSignal)row.DataBoundItem;

                //Fix area 1
                cell = row.Cells[MemberInfoGetting.GetMemberName(() => new AnalogSignal().Area1)];
                // http://stackoverflow.com/questions/1175645/find-an-item-in-list-by-linq
                analogSignal.Area1 = factory.GetAreas(null).SingleOrDefault(area => String.Equals(area.GUID, cell.Value.ToString(), StringComparison.OrdinalIgnoreCase));

                //Fix area 2
                cell = row.Cells[MemberInfoGetting.GetMemberName(() => new AnalogSignal().Area2)];
                analogSignal.Area2 = factory.GetAreas(analogSignal.Area1).SingleOrDefault(area => String.Equals(area.GUID, cell.Value.ToString(), StringComparison.OrdinalIgnoreCase));

                //Fix EGU
                cell             = row.Cells[MemberInfoGetting.GetMemberName(() => new AnalogSignal().EGU)];
                analogSignal.EGU = "" + cell.Value;
            }

            project.Plant.Name = txt_Plant.Text;
            project.Plant.Case = txt_Case.Text;
        }
Esempio n. 3
0
File: Main.cs Progetto: plats98/TI
        private void setupCustomGridData()
        {
            AnalogSignal current;

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                if (row.DataBoundItem == null)
                {
                    break;
                }

                current = (AnalogSignal)row.DataBoundItem;
                if (current.Area1 != null)
                {
                    row.Cells[MemberInfoGetting.GetMemberName(() => new AnalogSignal().Area1)].Value = current.Area1.GUID;
                }
                if (current.Area2 != null)
                {
                    row.Cells[MemberInfoGetting.GetMemberName(() => new AnalogSignal().Area2)].Value = current.Area2.GUID;
                }
                if (current.EGU != null)
                {
                    row.Cells[MemberInfoGetting.GetMemberName(() => new AnalogSignal().EGU)].Value = current.EGU;
                }
            }
        }
Esempio n. 4
0
 public GatewayServer(string ID, string name)
     : base(ID, name)
 {
     JsConfig.AssumeUtc    = true;
     activeTrips           = new ActiveTrips(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => activeTrips));
     partnerAccounts       = new RedisDictionary <string, PartnerAccount>(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => partnerAccounts));
     clientIdByAccessToken = new RedisDictionary <string, string>(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => clientIdByAccessToken));
 }
 public override string ToString()
 {
     return(string.Format(MemberInfoGetting.GetMemberName(() => Address) + ": {0}, " +
                          MemberInfoGetting.GetMemberName(() => PostCode) + ": {1}, " +
                          MemberInfoGetting.GetMemberName(() => City) + ": {2}, " +
                          MemberInfoGetting.GetMemberName(() => CompanyName) + ": {3}, " +
                          MemberInfoGetting.GetMemberName(() => Position) + ": {4}, " +
                          MemberInfoGetting.GetMemberName(() => Income) + ": {5}.",
                          Address, PostCode, City, CompanyName, Position, Income));
 }
Esempio n. 6
0
        public Product(string name, Color color, Size size)
        {
            if (name == null)
            {
                throw new ArgumentNullException(paramName: MemberInfoGetting.GetMemberName(() => name));
                //throw new ArgumentNullException (paramName: nameof(name); =>After C# 6.0
            }

            m_name  = name;
            m_color = color;
            m_size  = size;
        }
 public MultiFunctionMachine(IPrinter printer, IScanner scanner)
 {
     if (printer == null)
     {
         throw new ArgumentNullException(paramName: MemberInfoGetting.GetMemberName(() => printer));
     }
     if (scanner == null)
     {
         throw new ArgumentNullException(paramName: MemberInfoGetting.GetMemberName(() => scanner));
     }
     this.printer = printer;
     this.scanner = scanner;
 }
Esempio n. 8
0
 public GatewayWithStats(string ID, string name)
     : base(ID, name)
 {
     JsConfig.AssumeUtc = true;
     redisClient        = (RedisClient)redis.GetClient();
     exceptions         = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => exceptions));
     rejects            = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => rejects));
     requests           = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => requests));
     cancels            = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => cancels));
     fare      = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => fare));
     completes = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => completes));
     distance  = new RedisStat(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => distance));
 }
Esempio n. 9
0
        public virtual async Task SendMessageByUserNameTest()
        {
            UserNameToSendMessage = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => UserNameToSendMessage)];
            if (string.IsNullOrWhiteSpace(UserNameToSendMessage))
            {
                throw new Exception("Please fill the" + MemberInfoGetting.GetMemberName(() => UserNameToSendMessage) + " setting in app.config file first");
            }

            var client = NewClient();

            await client.ConnectAsync();

            var result = await client.SearchUserAsync(UserNameToSendMessage);

            var user = result.Users
                       .Where(x => x.GetType() == typeof(TLUser))
                       .OfType <TLUser>()
                       .FirstOrDefault(x => x.Username == UserNameToSendMessage.TrimStart('@'));

            if (user == null)
            {
                var contacts = await client.GetContactsAsync();

                user = contacts.Users
                       .Where(x => x.GetType() == typeof(TLUser))
                       .OfType <TLUser>()
                       .FirstOrDefault(x => x.Username == UserNameToSendMessage.TrimStart('@'));
            }

            if (user == null)
            {
                throw new System.Exception("Username was not found: " + UserNameToSendMessage);
            }

            await client.SendTypingAsync(new TLInputPeerUser()
            {
                UserId = user.Id
            });

            Thread.Sleep(3000);
            await client.SendMessageAsync(new TLInputPeerUser()
            {
                UserId = user.Id
            }, "TEST");
        }
Esempio n. 10
0
        public AndSpecification(ISpecification <T> first, ISpecification <T> second)
        {
            if (first == null)
            {
                throw new ArgumentNullException(paramName: MemberInfoGetting.GetMemberName(() => first));
            }

            if (second == null)
            {
                throw new ArgumentNullException(paramName: MemberInfoGetting.GetMemberName(() => second));
            }

            this.first  = first;
            this.second = second;

            //C# 7.0 can write in this way
            //this.first = first ?? throw new ArgumentNullException(paramName: nameof(first));
        }
Esempio n. 11
0
        public virtual async Task SendMessageTest()
        {
            NumberToSendMessage = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => NumberToSendMessage)];
            if (string.IsNullOrWhiteSpace(NumberToSendMessage))
            {
                throw new Exception("Please fill the" + MemberInfoGetting.GetMemberName(() => NumberToSendMessage) + " setting in app.config file first");
            }

            // this is because the contacts in the address come without the "+" prefix
            var normalizedNumber = NumberToSendMessage.StartsWith("+") ?
                                   NumberToSendMessage.Substring(1, NumberToSendMessage.Length - 1) :
                                   NumberToSendMessage;

            var client = NewClient();

            await client.ConnectAsync();

            var result = await client.GetContactsAsync();


            var user = result.Users
                       .OfType <TLUser>()
                       .FirstOrDefault(x => x.Phone == normalizedNumber);

            if (user == null)
            {
                throw new System.Exception("Number was not found in Contacts List of user: "******"TEST");
        }
Esempio n. 12
0
            public string Add()
            {
                string s = MemberInfoGetting.GetMemberName(() => this);

                return(s);
            }
 public void TestMethod(string param1, string param2)
 {
     string nameOfParam1 = MemberInfoGetting.GetMemberName(() => param1);
 }
Esempio n. 14
0
 public RedisStat(RedisClient redis, string id)
 {
     allTime   = new RedisObject <double>(redis, id + ":" + MemberInfoGetting.GetMemberName(() => allTime));
     last24Hrs = new RedisExpiryCounter(redis, id + ":" + MemberInfoGetting.GetMemberName(() => last24Hrs), new TimeSpan(24, 0, 0));
     lastHour  = new RedisExpiryCounter(redis, id + ":" + MemberInfoGetting.GetMemberName(() => lastHour), new TimeSpan(1, 0, 0));
 }
Esempio n. 15
0
        private void InitializePersistantDataObjects()
        {
            partners = new Dictionary <string, Gateway>();
            var redisClient = (RedisClient)redis.GetClient();

            originatingPartnerByTrip = new RedisDictionary <string, string>(redisClient, ID + ":" + MemberInfoGetting.GetMemberName(() => originatingPartnerByTrip));
            originatingPartnerByTrip.Clear();
            servicingPartnerByTrip = new RedisDictionary <string, string>(redisClient, ID + "." + MemberInfoGetting.GetMemberName(() => servicingPartnerByTrip));
            servicingPartnerByTrip.Clear();
            partnerCoverage = new RedisDictionary <string, List <Zone> >(redisClient, ID + "." + MemberInfoGetting.GetMemberName(() => partnerCoverage));
            partnerCoverage.Clear();
            partnerAccounts.Clear();
            clientIdByAccessToken.Clear();
        }
Esempio n. 16
0
 public static void init()
 {
     ApiHash = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => ApiHash)];
     ApiId   = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => ApiId)];
 }
Esempio n. 17
0
        public virtual async Task addMemmberTest()
        {
            NumberToSendMessage = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => NumberToSendMessage)];
            if (string.IsNullOrWhiteSpace(NumberToSendMessage))
            {
                throw new Exception("Please fill the" + MemberInfoGetting.GetMemberName(() => NumberToSendMessage) + " setting in app.config file first");
            }

            // this is because the contacts in the address come without the "+" prefix
            var normalizedNumber = NumberToSendMessage.StartsWith("+") ?
                                   NumberToSendMessage.Substring(1, NumberToSendMessage.Length - 1) :
                                   NumberToSendMessage;

            var client = NewClient();

            await client.ConnectAsync();

            var result = await client.GetContactsAsync();


            var user = result.Users
                       .OfType <TLUser>()
                       .FirstOrDefault(x => x.Phone == normalizedNumber);

            if (user == null)
            {
                throw new System.Exception("Number was not found in Contacts List of user: "******"khune");
            int b = 5;

            TLInputUser u = new TLInputUser()
            {
                UserId = user.Id, AccessHash = (long)user.AccessHash
            };
            int a = 5;
            await client.ConnectAsync();

            //var req = new TLRequestAddChatUser()
            //{
            //    ChatId = chat.Id,
            //    UserId = u,
            //    FwdLimit = 100
            //};
            TLVector <TLAbsInputUser>    u2 = new TLVector <TLAbsInputUser>();
            TLVector <TLAbsInputChannel> c2 = new TLVector <TLAbsInputChannel>();

            u2.Add(u);
            c2.Add(new TLInputChannel()
            {
                ChannelId = chat.Id, AccessHash = (long)chat.AccessHash
            });
            var req2 = new TLRequestInviteToChannel()
            {
                //Channel = new TLInputChannel() { ChannelId = chat.Id },
                Channel = c2[0],
                Users   = u2
            };
            await client.ConnectAsync();

            try
            {
                var update = await client.SendRequestAsync <TLUpdates>(req2);
            }

            catch (Exception e)
            {
                //MessageBox.Show(e.ToString());
            }
            int a2 = 5;
        }
Esempio n. 18
0
        private void GatherTestConfiguration()
        {
            string appConfigMsgWarning = "{0} not configured in app.config! Some tests may fail.";

            ApiHash = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => ApiHash)];
            if (string.IsNullOrEmpty(ApiHash))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => ApiHash));
            }

            var apiId = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => ApiId)];

            if (string.IsNullOrEmpty(apiId))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => ApiId));
            }
            else
            {
                ApiId = int.Parse(apiId);
            }

            NumberToAuthenticate = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => NumberToAuthenticate)];
            if (string.IsNullOrEmpty(NumberToAuthenticate))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => NumberToAuthenticate));
            }

            CodeToAuthenticate = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => CodeToAuthenticate)];
            if (string.IsNullOrEmpty(CodeToAuthenticate))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => CodeToAuthenticate));
            }

            PasswordToAuthenticate = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => PasswordToAuthenticate)];
            if (string.IsNullOrEmpty(PasswordToAuthenticate))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => PasswordToAuthenticate));
            }

            NotRegisteredNumberToSignUp = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => NotRegisteredNumberToSignUp)];
            if (string.IsNullOrEmpty(NotRegisteredNumberToSignUp))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => NotRegisteredNumberToSignUp));
            }

            UserNameToSendMessage = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => UserNameToSendMessage)];
            if (string.IsNullOrEmpty(UserNameToSendMessage))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => UserNameToSendMessage));
            }

            NumberToGetUserFull = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => NumberToGetUserFull)];
            if (string.IsNullOrEmpty(NumberToGetUserFull))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => NumberToGetUserFull));
            }

            NumberToAddToChat = ConfigurationManager.AppSettings[MemberInfoGetting.GetMemberName(() => NumberToAddToChat)];
            if (string.IsNullOrEmpty(NumberToAddToChat))
            {
                Debug.WriteLine(appConfigMsgWarning, MemberInfoGetting.GetMemberName(() => NumberToAddToChat));
            }
        }
        private static void Compare(List <string> lines1, List <string> lines2)
        {
            var filename1 = MemberInfoGetting.GetMemberName(() => lines1);
            var filename2 = MemberInfoGetting.GetMemberName(() => lines2);

            if (lines1.Count != lines2.Count)
            {
                Log($"WARNING: files don't have the same length: {filename1}: {lines1.Count}. {filename2}: {lines2.Count}");
            }

            for (int i = 0; i < lines1.Count; i++)
            {
                if (i > lines2.Count - 1)
                {
                    return;
                }

                var line1     = ParseLine(lines1[i]);
                var line2     = ParseLine(lines2[i]);
                var template  = $"{lines1[i]},{lines2[i]},{(i * 4):X8}";
                var template2 = "";

                // Check if both values aren't equal to 0
                if (lines1[i] == lines2[i] && lines2[i] == "00000000")
                {
                    template2 = "unknown";
                    goto end;
                }

                if (lines1[i] == lines2[i])
                {
                    template2 = "bytes";
                    goto end;
                }

                if (line1[0] == line2[1] &&
                    line1[1] == line2[0] &&
                    line1[2] == line2[3] &&
                    line1[3] == line2[2])
                {
                    template2 = "short";
                    goto end;
                }

                if (line1[0] == line2[3] &&
                    line1[1] == line2[2] &&
                    line1[2] == line2[1] &&
                    line1[3] == line2[0])
                {
                    template2 = "int";
                    goto end;
                }

                if (lines1[i] != lines2[i])
                {
                    template2 = "different";
                    goto end;
                }

end:
                Log($"{template},{template2}");
            }
        }
Esempio n. 20
0
File: Main.cs Progetto: plats98/TI
        // Configures columns for the DataGridView control.
        private void AddColumns()
        {
            //https://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.autogeneratecolumns%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

            //Initial settings
            bindingSource1.Clear();
            bindingSource1.DataSource = typeof(AnalogSignal);
            if (!project.AnalogSignals.IsNullOrEmpty())
            {
                bindingSource1.DataSource = project.AnalogSignals;
            }


            dataGridView1.AutoGenerateColumns = true;
            dataGridView1.DataSource          = bindingSource1;

            DataGridViewColumn column;
            string             fieldNameString;

            // Handle KKS column
            fieldNameString = MemberInfoGetting.GetMemberName(() => new AnalogSignal().KKS);
            if (dataGridView1.Columns.Contains(fieldNameString))
            {
                column          = dataGridView1.Columns[fieldNameString];
                column.Name     = fieldNameString;
                column.Visible  = true;
                column.ReadOnly = true;
                column.Frozen   = true;
            }

            // Handle Address column
            fieldNameString = MemberInfoGetting.GetMemberName(() => new AnalogSignal().Address);
            if (dataGridView1.Columns.Contains(fieldNameString))
            {
                column          = dataGridView1.Columns[fieldNameString];
                column.Name     = fieldNameString;
                column.Visible  = true;
                column.ReadOnly = true;
            }


            // Handle Area1 column
            DataGridViewComboBoxColumn dg_cb_Area1 = new DataGridViewComboBoxColumn();

            dg_cb_Area1.Name          = MemberInfoGetting.GetMemberName(() => new AnalogSignal().Area1);
            dg_cb_Area1.HeaderText    = "Område 1";
            dg_cb_Area1.DisplayMember = "Description";
            dg_cb_Area1.DisplayStyle  = DataGridViewComboBoxDisplayStyle.Nothing;
            dg_cb_Area1.ValueMember   = "GUID";
            dg_cb_Area1.DataSource    = factory.GetAreas(null);
            dataGridView1.Columns.Insert(3, dg_cb_Area1); //TODO: handle index

            // Handle Area2 column
            DataGridViewComboBoxColumn dg_cb_Area2 = new DataGridViewComboBoxColumn();

            dg_cb_Area2.Name          = MemberInfoGetting.GetMemberName(() => new AnalogSignal().Area2);
            dg_cb_Area2.HeaderText    = "Område 2";
            dg_cb_Area2.DisplayMember = "Description";
            dg_cb_Area2.DisplayStyle  = DataGridViewComboBoxDisplayStyle.Nothing;
            dg_cb_Area2.ValueMember   = "GUID";
            dg_cb_Area2.DataSource    = factory.GetAreas(new Area("", "Fællesanlæg5"));
            dataGridView1.Columns.Insert(4, dg_cb_Area2); //TODO: handle index

            // Handle EGU column
            DataGridViewComboBoxColumn dg_cb_EGU = new DataGridViewComboBoxColumn();

            dg_cb_EGU.Name         = MemberInfoGetting.GetMemberName(() => new AnalogSignal().EGU);
            dg_cb_EGU.HeaderText   = "Enhed";
            dg_cb_EGU.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
            dg_cb_EGU.ValueMember  = null;              //Returned value is full object
            dg_cb_EGU.DataSource   = new Factory().GetEGU();
            dataGridView1.Columns.Insert(5, dg_cb_EGU); //TODO: handle index


            /*
             * // Add a button column.
             * DataGridViewButtonColumn buttonColumn = new DataGridViewButtonColumn();
             * buttonColumn.HeaderText = "";
             * buttonColumn.Name = "Status Request";
             * buttonColumn.Text = "Request Status";
             * buttonColumn.UseColumnTextForButtonValue = true;
             * dataGridView1.Columns.Insert(1, buttonColumn); // n is index
             */
        }
Esempio n. 21
0
    public static int OrderItemInsert(Consumer consumer, int order_id)
    {
        int        result = 0;
        SqlCommand cmd    = null;

        SqlConnection conn     = new SqlConnection(_connStr);
        string        queryStr = "INSERT INTO order_items(order_id, item_name, item_price, quantity, cleantype ) values (@order_id, @item_name, @item_price, @quantity, @cleantype)";

        conn.Open();
        SqlTransaction sqlTrans = conn.BeginTransaction();

        if (!String.IsNullOrEmpty(consumer.Tee))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Tee));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("3"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Tee));
            cmd.Parameters.AddWithValue("@cleantype", "-");
            cmd.ExecuteNonQuery();
        }
        if (!String.IsNullOrEmpty(consumer.Shorts))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Shorts));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("4"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Shorts));
            cmd.Parameters.AddWithValue("@cleantype", "-");
            cmd.ExecuteNonQuery();
        }
        if (!String.IsNullOrEmpty(consumer.Jeans))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Jeans));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("4"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Jeans));
            cmd.Parameters.AddWithValue("@cleantype", "-");
            cmd.ExecuteNonQuery();
        }
        if (!String.IsNullOrEmpty(consumer.Jacket))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Jacket));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("5"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Jacket));
            cmd.Parameters.AddWithValue("@cleantype", "Dry Clean");
            cmd.ExecuteNonQuery();
        }
        if (!String.IsNullOrEmpty(consumer.Formal))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Formal));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("6"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Formal));
            cmd.Parameters.AddWithValue("@cleantype", "Iron");
            cmd.ExecuteNonQuery();
        }
        if (!String.IsNullOrEmpty(consumer.Bed))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Bed));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("5"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Bed));
            cmd.Parameters.AddWithValue("@cleantype", "-");
            cmd.ExecuteNonQuery();
        }
        if (!String.IsNullOrEmpty(consumer.Curtain))
        {
            cmd = new SqlCommand(queryStr, conn, sqlTrans);
            cmd.Parameters.AddWithValue("@order_id", order_id);
            cmd.Parameters.AddWithValue("@item_name", MemberInfoGetting.GetMemberName(() => consumer.Curtain));
            cmd.Parameters.AddWithValue("@item_price", Convert.ToDecimal("5"));
            cmd.Parameters.AddWithValue("@quantity", Convert.ToInt32(consumer.Curtain));
            cmd.Parameters.AddWithValue("@cleantype", "-");
            cmd.ExecuteNonQuery();
        }
        sqlTrans.Commit();
        conn.Close();
        return(result);
    }