Exemple #1
0
        public string Customer_Insert(Customer_Class obj)
        {
            SqlConnection con = new SqlConnection(objCon.ConnectionReturn());
            SqlCommand    cmd = new SqlCommand("Customer_Insert", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Name", obj.Name);
            cmd.Parameters.AddWithValue("@PhoneNumber", obj.PhoneNumber);
            cmd.Parameters.AddWithValue("@Email", obj.Email);
            cmd.Parameters.AddWithValue("@Password", obj.Password);
            cmd.Parameters.AddWithValue("@HouseNo", obj.HouseNo);
            cmd.Parameters.AddWithValue("@AddressLine2", obj.AddressLine2);
            cmd.Parameters.AddWithValue("@AddressLine3", obj.AddressLine3);
            cmd.Parameters.AddWithValue("@AddressLine4", obj.AddressLine4);
            cmd.Parameters.AddWithValue("@PostCode", obj.PostCode);
            cmd.Parameters.AddWithValue("@InvoiceName", obj.InvoiceName);
            cmd.Parameters.AddWithValue("@Company", obj.Company);
            cmd.Parameters.AddWithValue("@InvoiceAddessLine2", obj.InvoiceAddessLine2);
            cmd.Parameters.AddWithValue("@InvoiceAddressLine3", obj.InvoiceAddressLine3);
            cmd.Parameters.AddWithValue("@InvoiceAddressLine4", obj.InvoiceAddressLine4);
            cmd.Parameters.AddWithValue("@InvoicePostCode", obj.InvoicePostCode);
            cmd.Parameters.AddWithValue("@AgreeSendSpecialOffer", obj.AgreeSendSpecialOffer);
            cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 50).Value     = "";
            cmd.Parameters.Add("@ReturnCode", SqlDbType.NVarChar, 50).Value = "";
            cmd.Parameters["@Return"].Direction     = ParameterDirection.Output;
            cmd.Parameters["@ReturnCode"].Direction = ParameterDirection.Output;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            string Return = Convert.ToString(cmd.Parameters["@Return"].Value);

            return(Return);
        }
Exemple #2
0
 public CustomerRegistrationPageViewModel(INavigation navigation)
 {
     _INavigation              = navigation;
     this.SubmitCommand        = new Command(async() => await Submit());
     this.Customer_Class_GeSet = new Customer_Class();
     this._IAllDataServices    = new AllDataServices();
 }
 public SellViewModel(INavigation _navigation)
 {
     navigation = _navigation;
     App.isBusy = false;
     ArticleMaster_Class_Data_List = new ObservableCollection <ArticleMaster_Class>();
     this.Customer_Class           = new Customer_Class();
     GetContectNoCommand           = new Command(async() => await CheckContectNo());
     GetArticleNoCommand           = new Command(async() => await CheckArticleNo());
     GetScanCommand = new Command(async() => await ScanArticleNo());
     AddCommand     = new Command(async() => await Add());
     //  CancelCommand = new Command(  CancelTask());
     SaveCommand               = new Command(async() => await Save());
     CustomerClassToBind       = new Customer_Class();
     _IAllDataServices         = new AllDataServices();
     Franchise_Sell_Class_Data = new FranchiseSell_Class();
     ArticleMasterClassList    = new ObservableCollection <ArticleMaster_Class>();
     GetListAsync();
 }
        private async Task CheckContectNo()
        {
            if (!App.isBusy)
            {
                try
                {
                    if (HasErrors)
                    {
                        App.isBusy = false;
                        ScrollToControlProperty(GetFirstInvalidPropertyName);
                    }
                    else
                    {
                        if (!string.IsNullOrEmpty(Customer_Class.Contact_No))
                        {
                            if (_Get_Btn_Text == "Get")
                            {
                                var Wait = UserDialogs.Instance.Loading("Wait..", null, null, true, MaskType.Black);
                                Wait.Show();
                                JObject result = await _IAllDataServices.GetCustomerByMobileNo(Customer_Class);

                                if (result != null)
                                {
                                    App.isBusy = false;
                                    string type = result["Type"].ToString();
                                    if (type == "1")
                                    {
                                        _Show_And_Hide_Stack = true;
                                        _Get_Btn_Text        = "Cancel";
                                        _Text_Enable         = false;

                                        //await App.Current.MainPage.DisplayAlert("Success!", "Customer : " + (string)result["Result"]["Customer_Name"] + " Is Registered", "Ok");
                                        Franchise_Sell_Class_Data.Customer_Id = (int)result["Result"]["Customer_Id"];
                                        Customer_Class customer_ = new Customer_Class();
                                        customer_.Contact_No    = result["Result"]["Contact_No"].ToString();
                                        customer_.Email_Id      = result["Result"]["Email_Id"].ToString();
                                        customer_.Customer_Name = result["Result"]["Customer_Name"].ToString();
                                        CustomerClassToBind     = customer_;

                                        Franchise_Sell_Class_Data.Customer_Class_Data = Customer_Class;
                                    }
                                    else
                                    {
                                        App.isBusy           = false;
                                        Registration_layout  = true;
                                        _Show_And_Hide_Stack = true;
                                        _Get_Btn_Text        = "Cancel";
                                        //await App.Current.MainPage.DisplayAlert("Error!", (string)result["ResponseMessage"], "Ok");
                                        _Text_Enable = false;
                                        Franchise_Sell_Class_Data.Customer_Id = 0;
                                    }
                                }
                                else
                                {
                                    App.isBusy           = false;
                                    _Show_And_Hide_Stack = false;
                                    //_Get_Btn_Text = "Get";
                                    _Get_Btn_Text = "Cancel";
                                    _Text_Enable  = true;
                                    await App.Current.MainPage.DisplayAlert("Oops!", "Please Refresh Page And try Again....", "Ok");
                                }
                                Wait.Dispose();
                            }
                            else
                            {
                                //var fm = new FranchiseMaster();
                                //var page = (Page)Activator.CreateInstance(typeof(SellPage));
                                //page.Title = "Sell";
                                //fm.Detail = new NavigationPage(page)
                                //{
                                //    BarBackgroundColor = Color.Black,
                                //    BarTextColor = Color.White,
                                //};
                                //fm.IsPresented = false;
                                //await navigation.PushModalAsync(fm);
                                App.isBusy = false;
                                SellPage cp = new SellPage();
                                var      ChackPriousPage = navigation.NavigationStack.Where(x => x.Title == cp.Title).FirstOrDefault();

                                if (ChackPriousPage != null)
                                {
                                    await navigation.PopAsync();
                                }
                                await navigation.PushAsync(new SellPage());

                                // null List
                            }
                        }
                        else
                        {
                            _Contect_No          = string.Empty;
                            _Show_And_Hide_Stack = false;
                            _Get_Btn_Text        = "Get";
                            _Text_Enable         = true;
                        }
                    }
                }
                catch (Exception ee)
                {
                    App.isBusy = false;
                    await App.Current.MainPage.DisplayAlert("Error", ee.Message, "Ok");
                }
            }
        }
Exemple #5
0
        public string Customer_Insert(Customer_Class obj)
        {
            string Return = objModels.Customer_Insert(obj);

            return(Return);
        }