public ActionResult Create(FormCollection collection) { try { var Client = new ClientsModel { Name = collection["name"], LastName = collection["LastName"], Phone = int.Parse(collection["Phone"]), Description = collection["Description"] }; if (Client.Save()) { return(RedirectToAction("Index")); } else { return(View(Client)); } } catch { return(View()); } }
public ClientsModel Get() { ClientsModel clientList = new ClientsModel(); foreach (var client in clientProviderService.Clients) { if (client.IsAreaServer) { AreaServerModel model = AreaServerModel.ConvertDate(client); if (model != null) { clientList._areaServerList.Add(model); } } else { PlayerModel model = PlayerModel.ConvertData(client); if (model != null) { clientList.PlayerList.Add(model); } } } return(clientList); }
public List <ClientsModel> GetClientDetails() { string cs = CONNECTIONSTRING; var conn = new NpgsqlConnection(cs); conn.Open(); string sql = @"SELECT * FROM clients"; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); var clients = new List <ClientsModel>(); while (dr.Read()) { var clientModel = new ClientsModel { ClientId = dr.GetInt32(0), FirstName = dr.GetString(1) }; clients.Add(clientModel); } conn.Close(); return(clients); }
private void btnSubmit_Click(object sender, EventArgs e) { if (Checker()) { if (txtClientID.Text != "") { ClientsModel client = new ClientsModel( Convert.ToInt32(txtClientID.Text), txtFirstName.Text, txtLastName.Text, txtBarcode.Text, txtPhoneNumber.Text, Convert.ToDecimal(txtDiscount.Text) ); SqliteDataAccess.EditClient(client); } else { ClientsModel client = new ClientsModel( txtFirstName.Text, txtLastName.Text, txtBarcode.Text, txtPhoneNumber.Text, Convert.ToDecimal(txtDiscount.Text), 0 ); SqliteDataAccess.CreateClient(client); } form.Refresh(); this.Close(); } }
public static void AddClient(ClientsModel model, ServicesModel ModelServices, int postedbyId) { DataContext db = new DataContext(); TblClient tbl = new TblClient(); TblBusinessType tblBusinessType = new TblBusinessType(); tbl.Name = model.Name; tbl.TypeOfCompany = model.TypeOfCompany; tbl.LimitedBy = model.LimitedBy; tbl.ShareValue1 = model.ShareValue1; tbl.ShareValue2 = model.ShareValue2; tbl.ShareCapitalProduct = model.ProductOfShareValues; tbl.BusinessObjectives = model.BusinessObjectives; tbl.CNIC = model.CNIC; tbl.NTN = model.NTN; tbl.PINCode = model.PINCode; tbl.FBRLogin = model.FBRLogin; tbl.FBRPassword = model.FBRPassword; tbl.IncorporationNo = model.IncorporationNo; tbl.RegistrationNo = model.RegistrationNo; tbl.RegisteredWith = model.RegisteredWith; tbl.Address = model.Address; tbl.Email = model.Email; tbl.PhoneNo = model.PhoneNo; tbl.MobileNo = model.MobileNo; tbl.FaxNo = model.FaxNo; tbl.CreatedById = postedbyId; tbl.CreatedDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); tbl.IsActive = true; db.TblClients.InsertOnSubmit(tbl); db.SubmitChanges(); TblService tblServices = new TblService(); var res = (from c in db.TblClients orderby c.Id descending select c).FirstOrDefault(); tbl = res; int currentClientId = tbl.Id; tblServices.ClientId = currentClientId; tblBusinessType.BusinessType = model.BusinessType; tblBusinessType.ClientId = currentClientId; tblServices.Accounting = true ? ModelServices.Accounting == "Accounting" : false; tblServices.Audit = true ? ModelServices.Audit == "Audit" : false; tblServices.Legal = true ? ModelServices.Legal == "Legal" : false; tblServices.Taxation = true ? ModelServices.Taxation == "Taxation" : false; tblServices.Corporate = true ? ModelServices.Corporate == "Corporate" : false; db.TblBusinessTypes.InsertOnSubmit(tblBusinessType); db.TblServices.InsertOnSubmit(tblServices); db.SubmitChanges(); db.Dispose(); //UpdateAndSaveService( ModelServices, currentClientId); }
public ActionResult Index() { ClientsModel model = null; try { CheckUserAuthorization(); } catch { ViewBag.Logged = false; ViewBag.UserName = Session["UserName"]; ViewBag.Error = "Access denied. Please log in."; return(View(model)); } ViewBag.Logged = true; try { IEnumerable <ClientModel> clients = ClientsProvider.GetAllClients(); model = new ClientsModel() { Clients = clients.ToList() }; } catch (Exception ex) { //TODO log ViewBag.Error = $"Unable to load clients: {ex.Message}"; } return(View(model)); }
public string EnterNewClient(Car car) { var code = ""; try { ClientsModel client = new ClientsModel { id = car.brand.Substring(0, 1) + car.model.Substring(0, 1) + car.plates, brand = car.brand, model = car.model, plates = car.plates, enter = DateTime.Now, exit = null }; clientsModels.Add(client); SaveChangesAsync(); code = client.id; } catch (Exception ex) { throw; } return(code); }
public IHttpActionResult login([FromBody] Client clientobj) { HandelErrorObject <ClientsModel> handelError = new HandelErrorObject <ClientsModel>(); ClientsModel client = db.Clients.Where(c => c.email == clientobj.email).Where(c => c.password == clientobj.password).ToList().Select(c => mf.create(c)).FirstOrDefault(); if (client != null) { string Clientjson = JsonConvert.SerializeObject(client); JObject jo = JObject.Parse(Clientjson); jo.Property("password").Remove(); ClientsModel ClientCon = jo.ToObject <ClientsModel>(); handelError.data = ClientCon; handelError.status = true; handelError.message = ""; return(Ok(handelError)); } else { handelError.data = null; var message = string.Format("Email or Password incorrect"); handelError.status = false; handelError.message = message; return(Ok(handelError)); } }
public static void CreateClient(ClientsModel client) { using (IDbConnection cnn = new MySqlConnection(LoadConnectionString())) { cnn.Execute("INSERT INTO clients (ClientFirstName, ClientLastName, ClientBarcode, ClientPhone, ClientDiscount, ClientBought) " + "VALUES (@ClientFirstName, @ClientLastName, @ClientBarcode, @ClientPhone, @ClientDiscount, @ClientBought)", client); } }
private void InitClients() { var json = System.IO.File.ReadAllText(Environment.CurrentDirectory + @"\Clients\ClientList.json"); clientsModel = JsonConvert.DeserializeObject <ClientsModel>(json); cbClient.DataSource = clientsModel.Clients; cbClient.DisplayMember = "Name"; cbClient.ValueMember = "Id"; }
public ActionResult Index() { ClientsModel clients = new ClientsModel(); clients.clients = clientBusiness.getClients(); clients.utilisateur = GetChefFromCookie(); return(View(clients)); }
// OAuthAuthorizationServerProvider sınıfının client erişimine izin verebilmek için ilgili ValidateClientAuthentication metotunu override ediyoruz. //public override Task ValidateClientAuthentication(OAuthValidateClientAuthenticationContext context) //{ // context.Validated(); // return Task.FromResult<object>(null); //} // OAuthAuthorizationServerProvider sınıfının kaynak erişimine izin verebilmek için ilgili GrantResourceOwnerCredentials metotunu override ediyoruz. //public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) //{ // // CORS ayarlarını set ediyoruz. // context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); // _kullanici = await _kullanicilarService.GetKullanicilarByKullaniciAdiAsync(context.UserName); // if (_kullanici == null) // { // context.SetError("invalid_grant", "Sistemde kayıtlı böyle bir kullanıcı bulunmamaktadır."); // return; // } // if (_kullanici != null) // { // byte[] salt = Convert.FromBase64String(_kullanici.Salt); // byte[] passwordSaltedHash = Utility.Hash(context.Password, salt); // if (Convert.ToBase64String(passwordSaltedHash).Equals(_kullanici.SifreHash, StringComparison.InvariantCulture)) // { // var identity = new ClaimsIdentity(context.Options.AuthenticationType); // identity.AddClaim(new Claim("userName", _kullanici.KullaniciAdi)); // identity.AddClaim(new Claim("email", _kullanici.Email)); // identity.AddClaim(new Claim("userID", _kullanici.Id.ToString())); // context.Validated(identity); // context.Request.Context.Authentication.SignIn(identity); // } // else // context.SetError("invalid_grant", "Kullanıcı adı veya şifre yanlış."); // } //} //public override Task TokenEndpointResponse(OAuthTokenEndpointResponseContext context) //{ // var accessToken = context.AccessToken; // _kullanicilarService.InsertKullaniciOturumAsync(new KullaniciOturumModel // { // AuthToken = context.AccessToken, // KullaniciId = _kullanici.Id, // SonlanmaTarihi = DateTime.Now.AddMinutes(2) // }); // return Task.FromResult<object>(null); //} #endregion #region v.2.0.0 //public override async Task ValidateClientRedirectUri(OAuthValidateClientRedirectUriContext context) //{ // //if (context.ClientId == Clients.Client1.Id) // //{ // // context.Validated(Clients.Client1.RedirectUrl); // //} // //else if (context.ClientId == Clients.Client2.Id) // //{ // // context.Validated(Clients.Client2.RedirectUrl); // //} // //return Task.FromResult(0); //} /// <summary> /// ValidateClientAuthentication /// </summary> /// <param name="context"></param> /// <returns></returns> public override async Task ValidateClientAuthentication(OAuthValidateClientAuthenticationContext context) { //context.Validated(); string clientId; string clientSecret; _logger.Debug(GetType(), null, "Checking clientId & clientSecret"); if (!context.TryGetBasicCredentials(out clientId, out clientSecret)) { context.TryGetFormCredentials(out clientId, out clientSecret); } _logger.Debug(GetType(), null, "Is ClientId null"); if (context.ClientId == null) { context.SetError("invalid_clientId", "ClientId parametre olarak gönderilmelidir."); return; } _logger.Debug(GetType(), null, "GetByClientIdAsync({0})", context.ClientId); _client = await _clientService.GetByClientIdAsync(context.ClientId); if (_client == null) { context.SetError("invalid_clientId", string.Format("Sistemde kayıtlı böyle bir client bulunmamaktadır.", context.ClientId)); return; } //Client Secret ile işlem yapılmak istenirse açılmalıdır. //if (_client.ApplicationType == ApplicationTypes.WebDevelopment) //{ // if (string.IsNullOrWhiteSpace(clientSecret)) // { // context.SetError("invalid_clientId", "Client secret should be sent."); // return Task.FromResult<object>(null); // } // else // { // if (client.Secret != Helper.GetHash(clientSecret)) // { // context.SetError("invalid_clientId", "Client secret is invalid."); // return Task.FromResult<object>(null); // } // } //} if (!_client.Active) { context.SetError("invalid_clientId", "Client aktif değildir."); return; } context.OwinContext.Set <string>("as:clientAllowedOrigin", _client.AllowedOrigin); context.OwinContext.Set <string>("as:clientRefreshTokenLifeTime", _client.RefreshTokenLifeTime.ToString()); context.Validated(); }
public bool checkLogin(ClientsModel model) { using (var context = new TravelAgencyEntities()) { bool isvalid = context.tbl_Clients.Any(x => x.Username == model.Username && x.Password == model.Password); return(isvalid); } }
public ClientController() { fileStorage = new FileStorage(); ClientsModel = new ClientsModel(); ClientsView = new Clients(ClientsModel.GetAll()); clientParametersView = new ClientParametesView(); LoadClientsModel();//загрузка даннных в модель ClientsView.RefreshList(ClientsModel.GetAll()); Listen(); }
public ActionResult Edit([Bind(Include = "Id,Password,EmailId,FirstName,LastName,MobileNo,Address,City,State")] ClientsModel clientsModel) { if (ModelState.IsValid) { db.Entry(clientsModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clientsModel)); }
public ActionResult Clients() { if (HttpContext.Session["lngId"] == null) { HttpContext.Session["lngId"] = 1; } ClientsModel model = HomeBuilder.BuildClients(Db); ViewBag.Link = 3; return(View(model)); }
public static void EditClient(ClientsModel client) { using (IDbConnection cnn = new MySqlConnection(LoadConnectionString())) { cnn.Execute("UPDATE clients SET ClientFirstName = @ClientFirstName, " + "ClientLastName = @ClientLastName, " + "ClientPhone = @ClientPhone, " + "ClientDiscount = @ClientDiscount, " + "ClientBought = @ClientBought " + "WHERE ClientID = @ClientID ", client); } }
public Task UpdateAsync(ClientsModel model) { if (model == null) { throw new ArgumentNullException("Client ArgumentNullException Insert Async"); } Clients dto = AutoMapperGenericHelper <ClientsModel, Clients> .Convert(model); _clientRepository.Update(dto); return(Task.FromResult <object>(null)); }
private void Clients_Load(object sender, EventArgs e) { num_countRowsOnPage.Value = Math.Round((decimal)dgv_client.Size.Height / dgv_client.RowTemplate.Height, 0, MidpointRounding.AwayFromZero) - 2; clientsModel = new ClientsModel((int)num_countRowsOnPage.Value); num_countRowsOnPage.Maximum = clientsModel.MaxRows; Fill_autoCompleteString(); cmb_countVisit.SelectedIndex = 0; cmb_lastName.SelectedIndex = 0; cmb_dateVisit.SelectedIndex = 0; cmb_gender.SelectedIndex = 0; }
public static void UpdatedClient(ClientsModel model, ServicesModel ModelServices, int postedbyId, int ClientId) { DataContext db = new DataContext(); TblClient result = (from c in db.TblClients where c.Id == ClientId select c).Single(); result.Name = model.Name; result.TypeOfCompany = model.TypeOfCompany; result.LimitedBy = model.LimitedBy; result.BusinessObjectives = model.BusinessObjectives; result.ShareValue1 = model.ShareValue1; result.ShareValue2 = model.ShareValue2; result.ShareCapitalProduct = model.ProductOfShareValues; result.CNIC = model.CNIC; result.IncorporationNo = model.IncorporationNo; result.RegistrationNo = model.RegistrationNo; result.RegisteredWith = model.RegisteredWith; result.Address = model.Address; result.Email = model.Email; result.PhoneNo = model.PhoneNo; result.MobileNo = model.MobileNo; result.FaxNo = model.FaxNo; result.UpdatedById = postedbyId; result.UpdatedDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.SubmitChanges(); /****************************************************************************************/ TblService resultServices = (from s in db.TblServices where s.ClientId == ClientId select s).SingleOrDefault(); resultServices.Accounting = true ? ModelServices.Accounting == "Accounting" : false; resultServices.Audit = true ? ModelServices.Audit == "Audit" : false; resultServices.Legal = true ? ModelServices.Legal == "Legal" : false; resultServices.Taxation = true ? ModelServices.Taxation == "Taxation" : false; resultServices.Corporate = true ? ModelServices.Corporate == "Corporate" : false; /***************************************************************************************/ TblBusinessType resultBusinessType = (from b in db.TblBusinessTypes where b.ClientId == ClientId select b).SingleOrDefault(); resultBusinessType.BusinessType = model.BusinessType; db.SubmitChanges(); db.Dispose(); }
public ActionResult CreateClient(ClientsModel clientsModel) { try { _context.clients.Add(clientsModel); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public ActionResult Create(ClientsModel clientsModel) { if (ModelState.IsValid) { var result = destinationRepository.AddClient(clientsModel); if (result > 0) { ModelState.Clear(); return(RedirectToAction("Create")); } } return(View()); }
public ActionResult DeleteClient(int id, ClientsModel clientsModel) { try { var clientToDelete = _context.clients.Find(id); _context.clients.Remove(clientToDelete); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public ActionResult Login(ClientsModel clientsModel) { if (ModelState.IsValid) { var result = destinationRepository.checkLogin(clientsModel); if (result) { FormsAuthentication.SetAuthCookie(clientsModel.Username, false); ModelState.Clear(); return(RedirectToAction("Index", "Home")); } } ModelState.AddModelError("", "Invalid username or password"); return(View()); }
public ActionResult Clients() { var lngId = 1; if (Session["lngId"] != null) { lngId = (int)Session["lngId"]; } ClientsModel model = HomeBuilder.BuildClients(Db); ViewBag.Link = 3; return(View(model)); }
public Task <ClientsModel> GetByClientIdAsync(string clientId) { var dal = _clientRepository.GetByClientIdAsync(clientId); if (dal == null) { return(Task.FromResult <ClientsModel>(null)); } else { ClientsModel model = AutoMapperGenericHelper <Clients, ClientsModel> .Convert(dal); return(Task.FromResult(model)); } }
public static void SaveClientTax(ClientsModel model, int clientId) { DataContext db = new DataContext(); TblTax tbl = new TblTax(); tbl.UpdatedBy = model.UpdatedById; tbl.FilePathNew = model.FilePathNew; tbl.FilePathOld = model.FilePathOld; tbl.ClientId = clientId; tbl.UserId = model.UserId; tbl.YearId = model.YearId; tbl.LastChangesInfo = model.LastChanges; db.TblTaxes.InsertOnSubmit(tbl); db.SubmitChanges(); db.Dispose(); }
public ResponseModel <int> Post([FromBody] ClientsModel dataToAdd) { var resp = new ResponseModel <int>(); try { if (dataToAdd == null) { throw new Exception("Data is null"); } var model = new Clients() { Name = dataToAdd.Name, IsActive = dataToAdd.IsActive, Creation = DateTime.Now, Updated = DateTime.Now, IdGroup = dataToAdd.IdGroup }; IClientsRepository appRepo = new ClientsRepository(new DataBaseContext()); if (appRepo.ExistByName(model.IdGroup, model.Name)) { throw new Exception("Client already exist"); } if (appRepo.Insert(model)) { resp.Data = model.Id; resp.Status = 200; resp.Description = "OK"; } else { throw new Exception("Not inserted"); } } catch (Exception ex) { resp.Status = 500; resp.Description = $"Error: {ex.Message}"; resp.Data = 0; } return(resp); }
public IHttpActionResult createUser(ClientsModel clientModel) { HandelErrorObject <Client> handelError = new HandelErrorObject <Client>(); ClientsModel clientobj = db.Clients.Where(c => c.email == clientModel.email).ToList().Select(c => mf.create(c)).FirstOrDefault(); try { if (clientobj == null) { Client client = new Client(); client.Client_ID = clientModel.Client_ID; client.full_name = clientModel.full_name; client.email = clientModel.email; client.phone_number = clientModel.phone_number; client.password = clientModel.password; client.cash = clientModel.cash; client.block = clientModel.block; client.points = clientModel.points; db.Clients.Add(client); db.SaveChanges(); string Clientjson = JsonConvert.SerializeObject(client); JObject jo = JObject.Parse(Clientjson); jo.Property("password").Remove(); Client ClientCon = jo.ToObject <Client>(); handelError.data = ClientCon; handelError.status = true; handelError.message = "User created successfully"; return(Ok(handelError)); } else { handelError.data = null; handelError.status = false; handelError.message = "Email is used"; return(Ok(handelError)); } } catch (Exception e) { handelError.data = null; handelError.status = false; handelError.message = e.Message; return(Ok(handelError)); } }
public IHttpActionResult Patch(ClientsModel client) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _clientService.UpdateAsync(client); return(Ok()); } catch (Exception ex) { return(InternalServerError(ex)); } }