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();
}
