Exemple #1
0
        public void SaveOrderContactDetails(OrderContact orderContact)
        {
            var sqlStr = $"if not exists ( select 1 from stoOrderContact where staffOrdNo = {orderContact.OrderId} )" +
                         " begin " +
                         " Insert stoOrderContact (staffOrdNo,ContactName,ContactNo,ExtNo) " +
                         $" values ({orderContact.OrderId}, '{orderContact.ContactName}', '{orderContact.ContactNo}','{orderContact.ExtNo}')" +
                         " end " +
                         " else " +
                         "  begin " +
                         " update stoOrderContact " +
                         $" set ContactName = '{orderContact.ContactName}'," +
                         $" ContactNo = '{orderContact.ContactNo}', " +
                         $" Extno = '{orderContact.ExtNo}' " +
                         $" where StaffOrdNo = {orderContact.OrderId}" +
                         " end ";

            using (IDbConnection conn = _connectionFactory.GetNewSqlConnectionWithLoginDetails(new SqlConnection(connection), String.Empty, String.Empty))
            {
                conn.Execute(sqlStr, null, null, null, CommandType.Text);// StoredProcedure);
            }
        }
Exemple #2
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="objNewOrderViewModel"></param>
        /// <param name="frm"></param>
        private void SaveProperties(NewOrderViewModel objNewOrderViewModel,FormCollection frm)
        {
            StringBuilder sb = new StringBuilder();
            #region Saving Residential Property

            if ((objNewOrderViewModel.UserType == 1) || (objNewOrderViewModel.UserType == 2))
            {
                objNewOrderViewModel.CompanyID = Convert.ToInt32(frm["ddlCompany"].ToString());
            }

            objNewOrderViewModel.PropertyAddrs = (frm["PropertyAddress"].ToString());
            objNewOrderViewModel.SpecialInstruction = (frm["txt_SpecialInsruction"].ToString());

            DateTime dtPropReq;

            if (string.IsNullOrEmpty(frm["Dt_PropertyReady"].ToString()))
            {
                dtPropReq = Convert.ToDateTime(frm["Dt_PropertyReady"].ToString());
            }
            else
            {
                dtPropReq = DateTime.Now.AddMonths(1);
            }

            objNewOrderViewModel.PropertyReady = dtPropReq;

            #region Keys in safe/Office
            string strKeys = string.Empty;
            if (frm["chk_KeyinsafeProp"] != null)
            {
                string strUAVDrone = (frm["chk_KeyinsafeProp"].ToString());
                sb = null;
                if (frm["chk_KeyinsafeProp"] != null)
                {
                    strKeys = frm["chk_KeyinsafeProp"].ToString();
                    // sb.Append(frm["chk_KeyinsafeProp"].ToString());
                }
            }

            if (frm["chk_KeyinOffice"] != null)
            {
                strKeys = strKeys + frm["chk_KeyinOffice"].ToString();
                // sb.Append(frm["chk_KeyinOffice"].ToString());
            }
            // sb.ToString();

            #endregion

            using (var OrderMangtDB = new OrderMgntEntities())
            {
                using (var transaction = new TransactionScope())
                {
                    var EntityProperties = new Property
                    {
                        Company_Id = objNewOrderViewModel.CompanyID,
                        Name = objNewOrderViewModel.PropertyAddrs,
                        Created = DateTime.Now,
                    };

                    // Add the Properties entity
                    OrderMangtDB.Properties.Add(EntityProperties);

                    OrderMangtDB.SaveChanges();
                    // Update the entity in the database

                    // Get the Row_Id generated by the database
                    objNewOrderViewModel.PropRowID = EntityProperties.Row_Id;

                    var EnityOrder = new Order
                    {
                        Property_Id = objNewOrderViewModel.PropRowID,
                        SpecialInstructions = objNewOrderViewModel.SpecialInstruction,
                        OrderId = "DPI-" + DateTime.Now.ToString("yyyyMMddHHmmssf"),
                        Keys = strKeys.ToString(),
                        RequiredDate = objNewOrderViewModel.PropertyReady,
                        Created = DateTime.Now,
                    };

                    // Add the Orders entity
                    OrderMangtDB.Orders.Add(EnityOrder);

                    OrderMangtDB.SaveChanges();
                    // Update the entity in the database

                    // Get the Row_Id generated by the database
                    objNewOrderViewModel.OrderRowID = EnityOrder.Row_Id;

                    #region PhotoGrphy

                    if (frm["Chk_PR_photography"] != null)
                    {
                        string Photography = (frm["Chk_PR_photography"].ToString());

                        #region day PhotoGrphy  Section
                        if (frm["Rd_day_photography"] != null)
                        {
                            string DayphotographyType = frm["Rd_day_photography"].ToString();
                            StringBuilder sbPhotoGraphy = new StringBuilder();
                            sbPhotoGraphy.Append("Day Photography:");

                            switch (DayphotographyType)
                            {
                                case "2ExternalImages":

                                    if (frm["chk_img_2_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_2_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_2_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_2_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_2_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_2_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    if (frm["chk_img_2_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_2_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    break;

                                case "5FinalImages":

                                    if (frm["chk_img_5_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Living"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Living"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Dining"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Dining"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    /////////////
                                    if (frm["chk_img_5_Family"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Family"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Kitchen"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Kitchen"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Bathroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Bathroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Ensuite"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Ensuite"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_img_5_MasterBed"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_MasterBed"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_2Bedroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_2Bedroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Rumpus"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Rumpus"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_HomeTheatre"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_HomeTheatre"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_img_5_Pool"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Pool"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_RE1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_RE2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_5_Lifestyle"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_5_Lifestyle"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    break;

                                case "8FinalImages":

                                    if (frm["chk_img_8_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Living"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Living"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Dining"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Dining"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    /////////////
                                    if (frm["chk_img_8_Family"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Family"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Kitchen"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Kitchen"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Bathroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Bathroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Ensuite"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Ensuite"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_img_8_MasterBed"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_MasterBed"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_2Bedroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_2Bedroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Rumpus"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Rumpus"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_HomeTheatre"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_HomeTheatre"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_img_8_Pool"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Pool"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_RE1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_RE2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_img_8_Lifestyle"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_img_8_Lifestyle"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    // remove last ,

                                    break;
                            }

                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 2);

                        }
                        #endregion Day Photo

                        #region Dusk PhotoGrphy  Section
                        if (frm["chk_dusk_8final_img"] != null)
                        {
                            StringBuilder sbPhotoGraphy = new StringBuilder();
                            sbPhotoGraphy.Append(" Dusk Photography:");

                            if (frm["chk_dusk_8final_FR1"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_FR1"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_FR2"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_FR2"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Living"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Living"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Dining"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Dining"].ToString());
                                sbPhotoGraphy.Append(",");
                            }

                            if (frm["chk_dusk_8final_Family"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Family"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Kitchen"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Kitchen"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Bathroom"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Bathroom"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Ensuite"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Ensuite"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            ///////////////////////

                            if (frm["chk_dusk_8final_MasterBed"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_MasterBed"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_2Bedroom"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_2Bedroom"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Rumpus"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Rumpus"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_HomeTheatre"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_HomeTheatre"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            ///////////////////////

                            if (frm["chk_dusk_8final_Pool"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Pool"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_RE1"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_RE1"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_RE2"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_RE2"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            if (frm["chk_dusk_8final_Lifestyle"] != null)
                            {
                                sbPhotoGraphy.Append(frm["chk_dusk_8final_Lifestyle"].ToString());
                                sbPhotoGraphy.Append(",");
                            }
                            // remove last ,

                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 2);

                        }
                        #endregion Dusk Photo

                        #region Prestige PhotoGrphy  Section

                        if (frm["Rd_day_presphotography"] != null)
                        {
                            string PrestigePhotographyType = frm["Rd_day_presphotography"].ToString();
                            StringBuilder sbPhotoGraphy = new StringBuilder();
                            sbPhotoGraphy.Append("Prestige Photography:");

                            switch (PrestigePhotographyType)
                            {

                                case "12DayFinalImages":

                                    if (frm["chk_Prestige_Day_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Living"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Living"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Dining"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Dining"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    if (frm["chk_Prestige_Day_Family"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Family"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Kitchen"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Kitchen"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Bathroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Bathroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Ensuite"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Ensuite"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_Prestige_Day_MasterBed"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_MasterBed"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_2Bedroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_2Bedroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Rumpus"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Rumpus"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_dusk_8final_HomeTheatre"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_HomeTheatre"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_Prestige_Day_Pool"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Pool"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_RE1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_RE2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_Day_Lifestyle"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_Day_Lifestyle"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    // remove last ,

                                    sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1);

                                    ////////////////////////
                                    break;

                                case "Dusk12FinalImages":

                                    if (frm["chk_Prestige_dusk_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Living"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Living"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Dining"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Dining"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    if (frm["chk_Prestige_dusk_Family"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Family"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Kitchen"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Kitchen"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Bathroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Bathroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Ensuite"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Ensuite"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_Prestige_dusk_MasterBed"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_MasterBed"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_2Bedroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_2Bedroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Rumpus"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Rumpus"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_HomeTheatre"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_HomeTheatre"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_Prestige_dusk_Pool"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Pool"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_RE1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_RE2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_Prestige_dusk_Lifestyle"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Lifestyle"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    break;
                            }

                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 3);
                        }

                        #endregion Prestisge day Photo

                        #region  Rental Photography Section

                        if (frm["rd_day_Rental_photography"] != null)
                        {
                            string RentalPhotographyType = frm["rd_day_Rental_photography"].ToString();
                            StringBuilder sbPhotoGraphy = new StringBuilder();
                            sbPhotoGraphy.Append("Rental Photography:");

                            switch (RentalPhotographyType)
                            {

                                case "5FinalRentalPhotography":

                                    if (frm["chk_RentalOption5_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Living"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Living"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Dining"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Dining"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    if (frm["chk_RentalOption5_Family"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Family"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Kitchen"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Kitchen"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Bathroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Bathroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Ensuite"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Ensuite"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_RentalOption5_MasterBed"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_MasterBed"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_2Bedroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_2Bedroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Rumpus"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Rumpus"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_HomeTheatre"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_HomeTheatre"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_RentalOption5_Pool"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Pool"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_RE1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_RE2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption5_Lifestyle"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption5_Lifestyle"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    // remove last ,

                                    sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1);

                                    ////////////////////////
                                    break;

                                case "10FinalRentalPhotography":

                                    if (frm["chk_RentalOption10_FR1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_FR1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_FR2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_FR2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Living"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Living"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Dining"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Dining"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }

                                    if (frm["chk_RentalOption10_Family"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Family"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Kitchen"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Kitchen"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Bathroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Bathroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Ensuite"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Ensuite"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_RentalOption10_MasterBed"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_MasterBed"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_2Bedroom"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_2Bedroom"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Rumpus"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Rumpus"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_HomeTheatre"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_HomeTheatre"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    ///////////////////////

                                    if (frm["chk_RentalOption10_Pool"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Pool"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_RE1"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_RE1"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_RE2"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_RE2"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    if (frm["chk_RentalOption10_Lifestyle"] != null)
                                    {
                                        sbPhotoGraphy.Append(frm["chk_RentalOption10_Lifestyle"].ToString());
                                        sbPhotoGraphy.Append(",");
                                    }
                                    // remove last ,

                                    sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1);

                                    break;
                            }

                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 4);
                        }

                        #endregion Rental Photography
                    }
                    #endregion Photography

                    #region UAV Drone/Aerial Photography

                    if (frm["Chk_PR_UAVDrone"] != null)
                    {
                        string strUAVDrone = (frm["Chk_PR_UAVDrone"].ToString());

                        StringBuilder sbUAV_Drone = new StringBuilder();
                        string strHead = "UAV Drone/Aerial Photography:";

                        if (frm["chk_UAVDroneUP3"] != null)
                        {
                            sbUAV_Drone.Append(strHead);
                            sbUAV_Drone.Append(frm["chk_UAVDroneUP3"].ToString());
                            sbUAV_Drone.Append(",");
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 3);
                            sbUAV_Drone.Length = 0;

                        }
                        if (frm["chk_UAVDroneUP5"] != null)
                        {
                            sbUAV_Drone.Append(strHead);
                            sbUAV_Drone.Append(frm["chk_UAVDroneUP5"].ToString());
                            sbUAV_Drone.Append(",");
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 15);
                            sbUAV_Drone.Length = 0;
                        }

                        if (frm["chk_UAVDrone_Helicop"] != null)
                        {
                            sbUAV_Drone.Append(strHead);
                            sbUAV_Drone.Append(frm["chk_UAVDrone_Helicop"].ToString());
                            sbUAV_Drone.Append(",");
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 16);
                            sbUAV_Drone.Length = 0;
                        }

                        if (frm["chk_UAVDrone_Elevated"] != null)
                        {
                            sbUAV_Drone.Append(strHead);
                            sbUAV_Drone.Append(frm["chk_UAVDrone_Elevated"].ToString());
                            sbUAV_Drone.Append(",");
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 17);
                            sbUAV_Drone.Length = 0;
                        }
                    }
                    #endregion UAV Drone/Aerial Photography

                    #region Floor Plans/Land-boxes Photography

                    if (frm["Chk_PR_FloorPlan"] != null)
                    {
                        string strUAVDrone = (frm["Chk_PR_FloorPlan"].ToString());

                        StringBuilder sbFloorPlan = new StringBuilder();
                        string strHead = "Floor Plans/Land-boxes:";

                        if ((frm["Rd_day_Floorphotography"] != null))
                        {
                            string FloorphotographyType = frm["Rd_day_Floorphotography"].ToString();

                            switch (FloorphotographyType)
                            {

                                case "FloorPlan":
                                    if (frm["chk_OnsiteColor"] != null)
                                    {
                                        sbFloorPlan.Append(strHead);
                                        sbFloorPlan.Append(frm["chk_OnsiteColor"].ToString());
                                    }
                                    SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 6);
                                    break;

                                case "FloorPlanandSite":
                                    if (frm["chk_OnsiteColor"] != null)
                                    {
                                        sbFloorPlan.Append(strHead);
                                        sbFloorPlan.Append(frm["chk_OnsiteColor"].ToString());
                                    }
                                    SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 6);
                                    break;
                            }

                        }

                        ////////////////////////
                        if ((frm["RedrawFloorSiteRadio"] != null))
                        {
                            string FloorphotographyType = frm["RedrawFloorSiteRadio"].ToString();

                            switch (FloorphotographyType)
                            {
                                case "FloorPlan":
                                    if (frm["chk_RedrawColor"] != null)
                                    {
                                        sbFloorPlan.Append(strHead);
                                        sbFloorPlan.Append(frm["chk_RedrawColor"].ToString());
                                    }
                                    SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 7);
                                    break;

                                case "FloorPlanSitePlan":
                                    if (frm["chk_RedrawColor"] != null)
                                    {
                                        sbFloorPlan.Append(strHead);
                                        sbFloorPlan.Append(frm["chk_RedrawColor"].ToString());
                                    }
                                    SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 7);
                                    break;
                            }
                        }

                        //Saving Landbox value
                        sbFloorPlan.Append(strHead + " Landbox:");
                        sbFloorPlan.Append(frm["ddlLandbox"].ToString());
                        SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 8);
                        ///////////////////
                    }

                    #endregion Floor Plans/Land-boxes Photography

                    #region Copy Writing

                    if (frm["Chk_PR_CopyWriting"] != null)
                    {
                        string strUAVDrone = (frm["Chk_PR_CopyWriting"].ToString());
                        sb = new StringBuilder();
                        string strHead = "Copy Writing:";

                        if (frm["chk_copywrite_Onsite"] != null)
                        {
                            sb.Append(strHead);
                            sb.Append(frm["chk_copywrite_Onsite"].ToString());
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 9);
                            sb.Length = 0;
                        }

                        if (frm["chk_copywrite_Offsite"] != null)
                        {
                            sb.Append(strHead);
                            sb.Append(frm["chk_copywrite_Offsite"].ToString());
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 10);
                            sb.Length = 0;
                        }

                        if (frm["chk_Rewrite_agent"] != null)
                        {
                            sb.Append(strHead);
                            sb.Append(frm["chk_Rewrite_agent"].ToString());
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 11);
                            sb.Length = 0;
                        }
                    }
                    #endregion Copy Writing

                    #region Video and Image tours

                    if (frm["Chk_PR_VideoImageTour"] != null)
                    {
                        string strUAVDrone = (frm["Chk_PR_VideoImageTour"].ToString());
                        sb = new StringBuilder();
                        string strHead = "Video and Image tours:";

                        if (frm["chk_video_propvideo"] != null)
                        {
                            sb.Append(strHead);
                            sb.Append(frm["chk_video_propvideo"].ToString());
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 12);
                            sb.Length = 0;
                        }

                        if (frm["chk_video_profile"] != null)
                        {
                            sb.Append(strHead);
                            sb.Append(frm["chk_video_profile"].ToString());
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 13);
                            sb.Length = 0;
                        }

                        if (frm["chk_ImageTours_stillImg"] != null)
                        {
                            sb.Append(strHead);
                            sb.Append(frm["chk_ImageTours_stillImg"].ToString());
                            SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 14);
                            sb.Length = 0;
                        }
                    }
                    #endregion Copy Writing
                    // End Logic for Copy Writing selected items

                    #region Agent Check
                    if (frm["chkAgent"] != null)
                    {
                        string ContactType = (frm["chkAgent"].ToString());
                        objNewOrderViewModel.AgentName = (frm["txtAgentName"].ToString());

                        string AgentPhoneEmail = string.Empty;
                        if (!string.IsNullOrEmpty(frm["txtAgentPhone"]))
                        {
                            objNewOrderViewModel.AgentPhone = (frm["txtAgentPhone"].ToString());
                            AgentPhoneEmail = "Phone:" + objNewOrderViewModel.AgentPhone;
                        }

                        if (!string.IsNullOrEmpty(frm["txtAgentPhone"]))
                        {
                            objNewOrderViewModel.AgentEmail = (frm["txtAgentEmail"].ToString());
                            AgentPhoneEmail = AgentPhoneEmail + " E-Mail:" + objNewOrderViewModel.AgentEmail;
                        }

                        var EntityContacts = new Contact
                        {
                            CompanyId = objNewOrderViewModel.CompanyID,
                            Name = objNewOrderViewModel.AgentName,
                            Value = AgentPhoneEmail,
                            ContactType = ContactType,
                            Created = DateTime.Now,
                        };

                        OrderMangtDB.Contacts.Add(EntityContacts);
                        OrderMangtDB.SaveChanges();
                        objNewOrderViewModel.ContactRowID = EntityContacts.Row_Id;

                        var EntityOrderContacts = new OrderContact
                        {
                            ContactId = objNewOrderViewModel.ContactRowID,
                            OrderId = objNewOrderViewModel.OrderRowID,
                            Created = DateTime.Now,
                        };

                        OrderMangtDB.OrderContacts.Add(EntityOrderContacts);
                        OrderMangtDB.SaveChanges();
                        objNewOrderViewModel.OrderContactID = EntityOrderContacts.Row_Id;

                    }
                    #endregion Agent

                    #region Owner Section
                    if (frm["chkOwner"] != null)
                    {

                        string ContactType = (frm["chkOwner"].ToString());
                        objNewOrderViewModel.AgentName = (frm["txt_OwnerName"].ToString());

                        string OwnerPhoneEmail = string.Empty;
                        if (!string.IsNullOrEmpty(frm["txt_OwnerPhone"]))
                        {
                            objNewOrderViewModel.OwnerPhone = (frm["txt_OwnerPhone"].ToString());
                            OwnerPhoneEmail = "Phone:" + objNewOrderViewModel.OwnerPhone;
                        }

                        var EntityContacts = new Contact
                        {
                            CompanyId = objNewOrderViewModel.CompanyID,
                            Name = objNewOrderViewModel.OwnerName,
                            Value = OwnerPhoneEmail,
                            ContactType = ContactType,
                            Created = DateTime.Now,
                        };

                        OrderMangtDB.Contacts.Add(EntityContacts);
                        OrderMangtDB.SaveChanges();
                        objNewOrderViewModel.ContactRowID = EntityContacts.Row_Id;

                        var EntityOrderContacts = new OrderContact
                        {
                            ContactId = objNewOrderViewModel.ContactRowID,
                            OrderId = objNewOrderViewModel.OrderRowID,
                            Created = DateTime.Now,
                        };

                        OrderMangtDB.OrderContacts.Add(EntityOrderContacts);
                        OrderMangtDB.SaveChanges();
                        objNewOrderViewModel.OrderContactID = EntityOrderContacts.Row_Id;

                    }
                    #endregion Owner

                    #region Tenant Section
                    if (frm["chkTenant"] != null)
                    {

                        string ContactType = (frm["chkTenant"].ToString());

                        if (!string.IsNullOrEmpty(frm["txt_TenantName"]))
                        {
                            objNewOrderViewModel.TanantName = (frm["txt_TenantName"].ToString());
                        }

                        if (!string.IsNullOrEmpty(frm["txt_TenantPhone"]))
                        {
                            objNewOrderViewModel.TanantPhone = "Phone:" + (frm["txt_TenantPhone"].ToString());
                        }

                        var EntityContacts = new Contact
                        {
                            CompanyId = objNewOrderViewModel.CompanyID,
                            Name = objNewOrderViewModel.TanantName,
                            Value = objNewOrderViewModel.TanantPhone,
                            ContactType = ContactType,
                            Created = DateTime.Now,
                        };

                        OrderMangtDB.Contacts.Add(EntityContacts);
                        OrderMangtDB.SaveChanges();
                        objNewOrderViewModel.ContactRowID = EntityContacts.Row_Id;

                        var EntityOrderContacts = new OrderContact
                        {
                            ContactId = objNewOrderViewModel.ContactRowID,
                            OrderId = objNewOrderViewModel.OrderRowID,
                            Created = DateTime.Now,
                        };

                        OrderMangtDB.OrderContacts.Add(EntityOrderContacts);
                        OrderMangtDB.SaveChanges();
                        objNewOrderViewModel.OrderContactID = EntityOrderContacts.Row_Id;

                    }
                    #endregion Tenant

                    transaction.Complete();
                }

            }
            #endregion
        }
Exemple #3
0
        // POST /order/accept
        protected static void Accept(string json)
        {
            var yaOrder = JsonConvert.DeserializeObject <YaMarketOrderRequest>(json);

            if (yaOrder == null || yaOrder.order == null)
            {
                return;
            }

            Order order = null;

            try
            {
                var adminComment = "";

                adminComment = "Заказ номер: " + yaOrder.order.id + (yaOrder.order.fake ? "(тестовый)" : "") + "\r\n";

                if (yaOrder.order.paymentType.IsNotEmpty())
                {
                    adminComment += "Тип оплаты заказа: " +
                                    (yaOrder.order.paymentType == "PREPAID"
                                        ? "предоплата"
                                        : "постоплата при получении заказа") + "\r\n";
                }

                if (yaOrder.order.paymentMethod.IsNotEmpty())
                {
                    adminComment += "Способ оплаты заказа: ";
                    switch (yaOrder.order.paymentMethod)
                    {
                    case "YANDEX":
                        adminComment += "оплата при оформлении";
                        break;

                    case "SHOP_PREPAID":
                        adminComment += "предоплата напрямую магазину (только для Украины)";
                        break;

                    case "CASH_ON_DELIVERY":
                        adminComment += "наличный расчет при получении заказа";
                        break;

                    case "CARD_ON_DELIVERY":
                        adminComment += "оплата банковской картой при получении заказа";
                        break;
                    }
                }

                adminComment += "\r\n";

                var orderContact       = new OrderContact();
                var shippingCost       = 0f;
                var shippingMethodName = "";

                if (yaOrder.order.delivery != null)
                {
                    adminComment += string.Format("Доставка: {0}, стоимость доставки: {1}, даты: {2} до {3}\r\n",
                                                  yaOrder.order.delivery.serviceName, yaOrder.order.delivery.price ?? 0,
                                                  yaOrder.order.delivery.dates.fromDate, yaOrder.order.delivery.dates.toDate);

                    orderContact = new OrderContact
                    {
                        Address =
                            yaOrder.order.delivery.address.street + " " + yaOrder.order.delivery.address.house + " " +
                            yaOrder.order.delivery.address.subway + " " + yaOrder.order.delivery.address.block + " " +
                            yaOrder.order.delivery.address.floor,
                        City    = yaOrder.order.delivery.address.city,
                        Country = yaOrder.order.delivery.address.country,
                        Name    = string.Empty,
                        Zip     = yaOrder.order.delivery.address.postcode ?? string.Empty,
                        Zone    = string.Empty
                    };

                    if (yaOrder.order.delivery.price != null)
                    {
                        shippingCost = (float)yaOrder.order.delivery.price;
                    }

                    shippingMethodName = yaOrder.order.delivery.serviceName;
                }

                var orderItems = (from item in yaOrder.order.items
                                  let offer = OfferService.GetOffer(Convert.ToInt32(item.offerId))
                                              where offer != null
                                              let product = offer.Product
                                                            select new OrderItem()
                {
                    Name = product.Name,
                    Price = item.price,
                    Amount = item.count,
                    SupplyPrice = product.Offers[0].SupplyPrice,
                    ProductID = product.ProductId,
                    ArtNo = product.ArtNo,
                    IsCouponApplied = false,
                    Weight = product.Weight
                }).ToList();

                var orderCurrency = yaOrder.order.currency == "RUR"
                    ? (CurrencyService.GetAllCurrencies(true)
                       .FirstOrDefault(x => x.Iso3 == yaOrder.order.currency || x.Iso3 == "RUB") ??
                       CurrencyService.GetAllCurrencies(true).FirstOrDefault())
                    : (CurrencyService.GetAllCurrencies(true).FirstOrDefault(x => x.Iso3 == yaOrder.order.currency) ??
                       CurrencyService.GetAllCurrencies(true).FirstOrDefault());

                order = new Order()
                {
                    AdminOrderComment = adminComment,
                    CustomerComment   = yaOrder.order.notes,
                    OrderCustomer     = new OrderCustomer()
                    {
                        Email      = "*****@*****.**",
                        CustomerIP = "127.0.0.1"
                    },
                    OrderItems           = orderItems,
                    OrderCurrency        = orderCurrency,
                    ShippingContact      = orderContact,
                    BillingContact       = orderContact,
                    ShippingCost         = shippingCost,
                    ArchivedShippingName = shippingMethodName,
                    OrderStatusId        = OrderService.DefaultOrderStatus,
                    OrderDate            = DateTime.Now,
                    Number = OrderService.GenerateNumber(1),
                };

                order.OrderID = OrderService.AddOrder(order);
                order.Number  = OrderService.GenerateNumber(order.OrderID);
                OrderService.UpdateNumber(order.OrderID, order.Number);
                OrderService.ChangeOrderStatus(order.OrderID, OrderService.DefaultOrderStatus);


                if (order.OrderID != 0)
                {
                    YaMarketByuingService.AddOrder(new YaOrder()
                    {
                        MarketOrderId = yaOrder.order.id.TryParseInt(),
                        OrderId       = order.OrderID,
                        Status        = string.Format("[{0}] Создан заказ {1}", DateTime.Now.ToString("g"), order.OrderID)
                    });

                    try
                    {
                        var orderTable = OrderService.GenerateHtmlOrderTable(order.OrderItems, order.OrderCurrency,
                                                                             orderItems.Sum(x => x.Price * x.Amount), 0, null, null, 0, 0, 0, 0, 0, 0);

                        var mailTemplate = new BuyInOneClickMailTemplate(order.OrderID.ToString(), "", "", "", orderTable);
                        mailTemplate.BuildMail();

                        SendMail.SendMailNow(SettingsMail.EmailForOrders, "Заказ через Яндекс.Маркет", mailTemplate.Body,
                                             true);
                    }
                    catch (Exception ex)
                    {
                        Debug.LogError(ex);
                    }
                }
            }
            catch (Exception ex)
            {
                Debug.LogError(ex);
            }

            /*
             * Если магазин считает запрос, поступающий от Яндекс.Маркета, некорректным,
             * магазин должен вернуть статус ответа 400 с описанием причины ошибки в теле ответа.
             * Такие ответы будут анализироваться на предмет нарушений и недоработок API со стороны Яндекс.Маркета.
             *
             */
            var orderResponse = new YaMarketOrderResponse()
            {
                order = new YaMarketOrderAccept()
                {
                    accepted = order != null && order.OrderID != 0,
                    id       = yaOrder.order.id
                }
            };

            var context = HttpContext.Current;

            context.Response.ContentType = "application/json";
            context.Response.Write(JsonConvert.SerializeObject(orderResponse));
            context.Response.End();
        }
Exemple #4
0
        public ActionResult AddOrUpdateContacts(ContactModel model)
        {
            var contactObj = Mapper.Map<ContactModel, Contact>(model);
            var status = 0;
            if (model.Row_Id != null && model.Row_Id != 0)
                status = _repository.UpdateContacts(contactObj);
            else
            {
                contactObj.Created = DateTime.Now;
                var contactid = _repository.AddContacts(contactObj);
                if (contactid != 0)
                {
                    var ordercontact = new OrderContact();
                    ordercontact.OrderId = model.Orderid;
                    ordercontact.ContactId = contactid;
                    ordercontact.Created = DateTime.Now;
                    status = _repository.SaveOrdercontact(ordercontact);
                }

            }

            if (status == 1)
            {
                var contactlist = new List<Contact>();
                var companylstModel = new List<ContactModel>();

                var ordercontacts = _repository.GetOrderContactsbyOrder(model.Orderid);

                if (ordercontacts.Count > 0)
                {
                    foreach (var item in ordercontacts)
                    {
                        if (item != null)
                        {
                            if (item.ContactId != null)
                            {
                                var contact = _repository.GetContactsById(item.ContactId.Value);
                                if (contact != null)
                                {
                                    contactlist.Add(contact);
                                }

                            }
                        }

                    }

                    companylstModel = Mapper.Map<IEnumerable<Contact>, List<ContactModel>>(contactlist);

                }

                return PartialView("Controls/Company/_CompanyContacts", companylstModel);
            }
            return null;
        }
Exemple #5
0
 public int SaveOrdercontact(OrderContact ordercontacts)
 {
     db.OrderContacts.Add(ordercontacts);
       return db.SaveChanges();
 }
        protected int CreateCertificateOrder()
        {
            var certificate = new GiftCertificate
            {
                CertificateCode    = GiftCertificateService.GenerateCertificateCode(),
                ToName             = txtTo.Text,
                FromName           = txtFrom.Text,
                Sum                = Convert.ToSingle(txtSum.Text.Trim()),
                CertificateMessage = txtMessage.Text,
                Enable             = true,
                ToEmail            = txtEmail.Text
            };

            var orderContact = new OrderContact
            {
                Address = string.Empty,
                City    = string.Empty,
                Country = string.Empty,
                Name    = string.Empty,
                Zip     = string.Empty,
                Zone    = string.Empty
            };

            var taxes = TaxServices.CalculateCertificateTaxes(certificate.Sum);

            var taxOverPay = taxes.Where(tax => !tax.Key.ShowInPrice).Sum(tax => tax.Value);

            float orderSum = certificate.Sum + taxOverPay;

            var   payment      = PaymentService.GetPaymentMethod(hfPaymentMethod.Value.TryParseInt());
            float paymentPrice = payment.Extracharge == 0 ? 0 : (payment.ExtrachargeType == ExtrachargeType.Fixed ? payment.Extracharge : payment.Extracharge / 100 * certificate.Sum + taxOverPay);

            var baseCurrency = CurrencyService.BaseCurrency;

            var order = new Order
            {
                OrderDate     = DateTime.Now,
                OrderCustomer = new OrderCustomer
                {
                    CustomerID = CustomerContext.CurrentCustomer.Id,
                    Email      = txtEmailFrom.Text,
                    FirstName  = CustomerContext.CurrentCustomer.FirstName,
                    LastName   = CustomerContext.CurrentCustomer.LastName,
                    CustomerIP = HttpContext.Current.Request.UserHostAddress
                },
                OrderCurrency = new OrderCurrency
                {
                    //CurrencyCode = CurrencyService.CurrentCurrency.Iso3,
                    //CurrencyNumCode = CurrencyService.CurrentCurrency.NumIso3,
                    //CurrencyValue = CurrencyService.CurrentCurrency.Value,
                    //CurrencySymbol = CurrencyService.CurrentCurrency.Symbol,
                    //IsCodeBefore = CurrencyService.CurrentCurrency.IsCodeBefore
                    CurrencyCode    = baseCurrency.Iso3,
                    CurrencyValue   = baseCurrency.Value,
                    CurrencySymbol  = baseCurrency.Symbol,
                    CurrencyNumCode = baseCurrency.NumIso3,
                    IsCodeBefore    = baseCurrency.IsCodeBefore
                },
                OrderStatusId        = OrderService.DefaultOrderStatus,
                AffiliateID          = 0,
                ArchivedShippingName = Resource.Client_GiftCertificate_DeliveryByEmail,
                PaymentMethodId      = Convert.ToInt32(hfPaymentMethod.Value),
                ArchivedPaymentName  = payment.Name,
                PaymentDetails       = null,
                Sum               = orderSum + paymentPrice,
                PaymentCost       = paymentPrice,
                OrderCertificates = new List <GiftCertificate>
                {
                    certificate
                },
                TaxCost = taxes.Sum(tax => tax.Value),
                Taxes   = taxes.Select(tax => new OrderTax()
                {
                    TaxID = tax.Key.TaxId, TaxName = tax.Key.Name, TaxShowInPrice = tax.Key.ShowInPrice, TaxSum = tax.Value
                }).ToList(),
                ShippingContact = orderContact,
                BillingContact  = orderContact,
                Number          = OrderService.GenerateNumber(1)
            };

            if (order.PaymentMethod.Type == PaymentType.QIWI)
            {
                order.PaymentDetails = new PaymentDetails()
                {
                    Phone = txtPhone.Text
                };
            }

            OrderId     = order.OrderID = OrderService.AddOrder(order);
            OrderNumber = order.Number = OrderService.GenerateNumber(order.OrderID);
            OrderService.UpdateNumber(order.OrderID, order.Number);
            OrderService.ChangeOrderStatus(order.OrderID, OrderService.DefaultOrderStatus);

            string email = txtEmailFrom.Text;

            string htmlOrderTable = OrderService.GenerateHtmlOrderCertificateTable(order.OrderCertificates,
                                                                                   CurrencyService.CurrentCurrency,
                                                                                   order.PaymentCost, order.TaxCost);

            var orderMailTemplate = new NewOrderMailTemplate(order.OrderID.ToString(), order.Number, email, string.Empty,
                                                             order.ArchivedShippingName,
                                                             order.ArchivedPaymentName, htmlOrderTable,
                                                             CurrencyService.CurrentCurrency.Iso3, order.Sum.ToString(),
                                                             order.CustomerComment,
                                                             OrderService.GetBillingLinkHash(order));

            orderMailTemplate.BuildMail();

            SendMail.SendMailNow(email, orderMailTemplate.Subject, orderMailTemplate.Body, true);
            SendMail.SendMailNow(SettingsMail.EmailForOrders, orderMailTemplate.Subject, orderMailTemplate.Body, true);

            return(OrderId);
        }