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); }
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"); } } }
public string Customer_Insert(Customer_Class obj) { string Return = objModels.Customer_Insert(obj); return(Return); }