private void ValidateUser() { if (string.IsNullOrEmpty(txtExecutiveName.Text)) { MessageBox.Show("Please Enter Executive Name", "Message", MessageBoxButtons.OK); return; } if (UserDetail.SrNo <= 0) { var uniDb = new UniDBDataContext(); UserDetail = uniDb.UserDetails.SingleOrDefault(x => x.UserId == txtExecutiveName.Text); } if (UserDetail == null) { MessageBox.Show("You have enter wrong User Name", "Message", MessageBoxButtons.OK); return; } if (UserDetail.Password.ToUpper() == txtPassword.Text.ToUpper()) { IsLogedIn = true; this.Close(); } else { MessageBox.Show("You have enter wrong password ", "Message", MessageBoxButtons.OK); } }
private void BindGridView() { uniDb = new UniDBDataContext(); _userDetails = uniDb.UserDetails.ToList(); dataGridView1.DataSource = _userDetails; }
private void toolStripComboBox1_SelectedIndexChanged(object sender, EventArgs e) { // ask for password var frmLogin = new Loginfrm(HomePage.UserDetail); frmLogin.ShowDialog(); if (!frmLogin.IsLogedIn) return; var selectedSrNos = _reportForm.GetSelectedSrNo(); var uniDb = new UniDBDataContext(); var selectedVendors = uniDb.VendorDetails.Where(x => selectedSrNos.Contains(x.SrNo)); uniDb.VendorDetails.DeleteAllOnSubmit(selectedVendors); if (toolStripComboBox1.Text != UniEnums.CompanyType.Customer.ToString()) { var query = uniDb.VendorDetails.Where(x => x.VendorType == toolStripComboBox1.Text); var srNo = query.Any() ? query.Max(c => c.SrNo) : 0; var newVendors = new List<VendorDetail>(); foreach (var vendor in selectedVendors) { srNo++; newVendors.Add(new VendorDetail() { SrNo = srNo, AnnualTurnover = vendor.AnnualTurnover, BusinessType = vendor.BusinessType, CompanyName = vendor.CompanyName, ContactPerson = vendor.ContactPerson, Email = vendor.Email, EstablishedYear = vendor.EstablishedYear, ExecutiveName = vendor.ExecutiveName, Expert = vendor.Expert, FactoryAddress = vendor.FactoryAddress, IsDeleted = vendor.IsDeleted, MobileNo = vendor.MobileNo, Networking = vendor.Networking, NoOfEmployees = vendor.NoOfEmployees, Note = vendor.Note, OfficeAddress = vendor.OfficeAddress, PhoneNo = vendor.PhoneNo, ProcessedDate = vendor.ProcessedDate, Profile1 = vendor.Profile1, Profile2 = vendor.Profile2, Sector = vendor.Sector, Source = vendor.Source, Website = vendor.Website, VendorType = toolStripComboBox1.Text, }); uniDb.VendorDetails.InsertAllOnSubmit(newVendors); } } else { var srNo = uniDb.CustomerDetails.Any(c => c.CompanyType == UniEnums.CompanyType.Customer.ToString()) ? uniDb.CustomerDetails.Where(c => c.CompanyType == UniEnums.CompanyType.Customer.ToString()) .Max(c => c.SrNo) : 0; var newCustomers = new List<CustomerDetail>(); foreach (var vendor in selectedVendors) { srNo++; newCustomers.Add(new CustomerDetail() { SrNo = srNo, CompanyType = UniEnums.CompanyType.Customer.ToString(), AnnualTurnover = vendor.AnnualTurnover, BusinessType = vendor.BusinessType, CompanyName = vendor.CompanyName, ContactPerson = vendor.ContactPerson, Email = vendor.Email, EstablishedYear = vendor.EstablishedYear, ExecutiveName = vendor.ExecutiveName, Expert = vendor.Expert, FactoryAddress = vendor.FactoryAddress, IsDeleted = vendor.IsDeleted, MobileNo = vendor.MobileNo, Networking = vendor.Networking, NoOfEmployees = vendor.NoOfEmployees, Note = vendor.Note, OfficeAddress = vendor.OfficeAddress, PhoneNo = vendor.PhoneNo, ProcessedDate = vendor.ProcessedDate, Profile1 = vendor.Profile1, Profile2 = vendor.Profile2, Sector = vendor.Sector, Source = vendor.Source, Website = vendor.Website }); } uniDb.CustomerDetails.InsertAllOnSubmit(newCustomers); } uniDb.SubmitChanges(); _reportForm.RefreshGrid(); }