private void ToolStripButtonsave_Click(object sender, EventArgs e)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
VENDOR vENDOR = new VENDOR
{
CONTACTNAME = txtContactName.Text,
COUNTRY = txtCountry.Text,
EMAIL = txtEmail.Text,
PHONENO = txtphoneNumber.Text,
POSTALADDRESS = txtAdress.Text,
TOWN = txtTown.Text,
VENDORNAME = txtVendorName.Text,
VENDORNO = txtVendorNumber.Text,
WEBSITE = txtWebsite.Text
};
db.VENDORs.Add(vENDOR);
db.SaveChanges();
this.Close();
MessageBox.Show("Saved Successfully to Database.");
Application.Restart();;
}
}
internal void PopulateControls(string vendno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var vendorDetails = db.VENDORs.Where(c => c.VENDORNO == vendno).ToList();
txtContactName.Text = vendorDetails[0].CONTACTNAME;
txtCountry.Text = vendorDetails[0].COUNTRY;
txtEmail.Text = vendorDetails[0].EMAIL;
txtphoneNumber.Text = vendorDetails[0].PHONENO;
txtAdress.Text = vendorDetails[0].POSTALADDRESS;
txtTown.Text = vendorDetails[0].TOWN;
txtVendorName.Text = vendorDetails[0].VENDORNAME;
txtVendorNumber.Text = vendorDetails[0].VENDORNO;
txtWebsite.Text = vendorDetails[0].VENDORNO;
this.Text = "Edit Vendor " + vendorDetails[0].VENDORNO;
//this.userControl11.Show();
//userControl11.BringToFront();
}
}
private void UpdateAssetTable()
{
List <Asset> empAsset = new List <Asset>();
Save_NewMembers saveEmp = new Save_NewMembers();
int staId, locId;
using (AccetManagementEntities db = new AccetManagementEntities())
{
var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList();
var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList();
// UPDATE ASSETS TABLE
staId = statusId[0];
locId = LocationId[0];
empAsset.Add(new Asset()
{
AssetNo = this.dgvCheckin.CurrentRow.Cells[0].Value.ToString(),
Comment = richTextBoxComent.Text.ToString().Trim(),
EmpName = "",
CheckoinDate = DateTime.Now,
StatusId = statusId[0],
LocationId = LocationId[0],
EmpId = ""
});
}
saveEmp.CheckinUpdate(empAsset);
}
public void CheckinUpdate(List <Asset> assets)
{
try
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
foreach (var empDetails in assets)
{
//get the Asset table
var assetTableData = db.ASSETs.Where(c => c.ASSETNO == empDetails.AssetNo).OrderBy(c => c.ASSETNO).ToList();
var results = db.ASSETs.SingleOrDefault(a => a.ASSETNO == empDetails.AssetNo);
if (results != null)
{
results.CHECKOUTCOMMENT = empDetails.Comment;
results.EMPNAME = "";
results.STATUSID = empDetails.StatusId;
results.LOCATIONID = empDetails.LocationId;
db.SaveChanges();
}
}
// db.EMPLOYEETABLEs.Add(employeeTable);
}
}
catch (Exception)
{
throw;
}
//update the row
}
public void SaveMember(List <Employee> empid)
{
try
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
foreach (var empDetails in empid)
{
employeeTable.EMPID = empDetails.EmpId;
employeeTable.FNAME = empDetails.Fname;
employeeTable.LNAME = empDetails.Lname;
employeeTable.WORKPHONE = empDetails.Workno;
employeeTable.MOBILEPHONE = empDetails.MobilePhone;
employeeTable.EMAIL = empDetails.Email;
employeeTable.STATUSID = empDetails.Statusid;
employeeTable.GROUPID = empDetails.GROUPID;
employeeTable.TITLEID = empDetails.TITLEID;
employeeTable.IMAGEID = empDetails.IMAGEID;
}
db.EMPLOYEETABLEs.Add(employeeTable);
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
private void RptAssignedUserControl_Load(object sender, EventArgs e)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
rPTASSIGNEDALLASSETBindingSource.DataSource = db.RPTASSIGNEDALLASSETS.ToList();
}
}
private void RptEmployeeUserControl_Load(object sender, EventArgs e)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
vIEWALLEMPBindingSource.DataSource = db.VIEWALLEMPs.ToList();
}
}
private void ToolStripBtnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this record?", "DELETE ASSET?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var assno = Convert.ToString(this.dgvAllAssets.CurrentRow.Cells["ASSETNO"].Value);
//delete image if any.
DeleteImage(assno);
//delete finance attatched to the asset
DeleteAssetFinance(assno);
using (AccetManagementEntities db = new AccetManagementEntities())
{
var empname = db.VIEWALLASSETS.Where(x => x.ASSETNO == assno).Select(x => x.EMPNAME).FirstOrDefault();
if (empname == "" || empname == null)
{
int rows = dgvAllAssets.RowCount;
for (int i = rows - 1; i >= 0; i--)
{
if (dgvAllAssets.Rows[i].Selected)
{
iEWALLASSET.ASSETNO = assno;
iEWALLASSET = db.ASSETs.Where(x => x.ASSETNO == iEWALLASSET.ASSETNO).FirstOrDefault();
var entry = db.Entry(iEWALLASSET);
if (entry.State == EntityState.Unchanged)
{
db.ASSETs.Attach(iEWALLASSET);
db.ASSETs.Remove(iEWALLASSET);
db.SaveChanges();
LoadGrid();
if (dgvAllAssets.CurrentRow == null)
{
MessageBox.Show("All Items deleted successfully");
}
else
{
dgvAllAssets.Rows[0].Selected = false;
}
}
//db.VIEWALLASSETS.Remove(dgvAllAssets.Rows[i].DataBoundItem as VIEWALLASSET);
//vIEWALLASSETBindingSource.RemoveAt(dgvAllAssets.Rows[i].Index);
}
}
}
else
{
MessageBox.Show("This particular Item cannot be deleted because it's been assigned to an Employee " + empname
+ " CheckIn the Item first for it to be deleted");
}
}
}
}
private void LoadGridView()
{
dgvSearch.DataSource = null;
using (AccetManagementEntities db = new AccetManagementEntities())
{
dgvSearch.AutoGenerateColumns = false;
dgvSearch.DataSource = db.VIEWCHECKOUTsearches.ToList <VIEWCHECKOUTsearch>(); //db.VIEWCHECKOUTsearches.ToList<VIEWCHECKOUTsearches>();
}
}
private void SaveCloseToolStripMenuItem_Click(object sender, EventArgs e)
{
var serial = userControl11.Controls.Find("txtserial", true);
var status = userControl11.Controls.Find("cmBStatus", true);
var condition = userControl11.Controls.Find("cmBCondition", true);
var checkedOutto = userControl11.Controls.Find("txtcheckedOutto", true);
var datepicker = userControl11.Controls.Find("dueDatepicker", true);
var txtNotes = userControl11.Controls.Find("txtNotes", true);
var r = condition[0].Text;
var currentStatus = status[0].Text;
try
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var currentConditionId = db.CONDITIONs.Where(c => c.CONDITIONNAME == r).OrderBy(c => c.CONDITIONID).Select(c => c.CONDITIONID).ToList();
var assetId = db.ASSETTYPEs.Where(c => c.ASSETTYPE1 == cmBAssetType.Text).OrderBy(c => c.ASSETTYPEID).Select(c => c.ASSETTYPEID).ToList();
var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmBLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList();
var statusId = db.STATUS.Where(c => c.STATUSNAME == currentStatus).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList();
myAsset.ASSETNO = txtAssetNumber.Text.Trim();
myAsset.DESCRIPTION = txtDesription.Text.Trim();
myAsset.ASSETTYPEID = assetId[0];
myAsset.LOCATIONID = LocationId[0];
myAsset.MANUFACTURER = txtmanu.Text.Trim();
myAsset.BRAND = txtBrand.Text.Trim();
myAsset.MODEL = "NO MODEL YET";
myAsset.SERIALNUMBER = serial[0].Text; // data.serial;
myAsset.STATUSID = statusId[0]; //data.statusId;
myAsset.CONDITIONID = currentConditionId[0]; //data.conditionId;
myAsset.EMPNAME = checkedOutto[0].Text.ToString().Trim(); // data.Emp;
myAsset.DUEDATE = Convert.ToDateTime(datepicker[0].Text);
myAsset.NOTES = txtNotes[0].Text.ToString().Trim();
myAsset.ASSETIMAGEID = 1;
myAsset.CHECKOUTDATE = DateTime.Now;
myAsset.CHECKOUTCOMMENT = "";
myAsset.EMPID = "";
myAsset.RECEIVEDDATE = DateTime.Now;
db.ASSETs.Add(myAsset);
db.SaveChanges();
this.Close();
MessageBox.Show("Saved Successfully to Database.");
Application.Restart();
//Main newMain = new Main();
//newMain.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex);
//throw;
}
}
private void FormCheckin_Load(object sender, EventArgs e)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
dgvCheckin.AutoGenerateColumns = false;
//dgvChqInOut.DataSource = db.VIEWCHECKOUTsearches.ToList<VIEWCHECKOUTsearch>();
dgvCheckin.DataSource = db.VIEWEMPCHECKOUTLISTs.Where(a => a.EMPID == CommonData.PersonalNumber).ToList <VIEWEMPCHECKOUTLIST>();
}
}
public void LoadDatagridView(List <string> assNo)
{
dgvItemsCheckedOut.DataSource = null;
using (AccetManagementEntities db = new AccetManagementEntities())
{
//dgvItemsCheckedOut.DataSource = db.VIEWCHECKOUTsearches.Where(e => assNo.Contains(e.ASSETNO)).ToList<VIEWCHECKOUTsearches>();
dgvItemsCheckedOut.DataSource = db.VIEWCHECKOUTsearches.Where(e => assNo.Contains(e.ASSETNO)).ToList <VIEWCHECKOUTsearch>();
}
}
private void ToolStripButtonDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this record?", "DELETE VENDOR?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var vendNo = Convert.ToString(this.dgvVendor.CurrentRow.Cells[1].Value);
using (AccetManagementEntities db = new AccetManagementEntities())
{
var getvendorFromDb = db.FINANCEs.Where(x => x.VENDORNO == vendNo).Select(x => x.VENDORNO).FirstOrDefault();
if (getvendorFromDb == null)
{
int rows = dgvVendor.RowCount;
for (int i = rows - 1; i >= 0; i--)
{
if (dgvVendor.Rows[i].Selected)
{
VENDOR iVendor = new VENDOR
{
VENDORNO = vendNo
};
iVendor = db.VENDORs.Where(x => x.VENDORNO == iVendor.VENDORNO).FirstOrDefault();
var entry = db.Entry(iVendor);
if (entry.State == EntityState.Unchanged)
{
db.VENDORs.Attach(iVendor);
db.VENDORs.Remove(iVendor);
db.SaveChanges();
LoadGrid();
if (dgvVendor.CurrentRow == null)
{
MessageBox.Show("All Items deleted successfully");
}
else
{
dgvVendor.Rows[0].Selected = false;
}
}
//db.VIEWALLASSETS.Remove(dgvAllAssets.Rows[i].DataBoundItem as VIEWALLASSET);
//vIEWALLASSETBindingSource.RemoveAt(dgvAllAssets.Rows[i].Index);
}
}
}
else
{
MessageBox.Show("Vendor is currently attached to an Asset");
}
}
}
}
public void LoadGrid()
{
dgvAllAssets.DataSource = null;
this.dgvAllAssets.SelectionMode =
DataGridViewSelectionMode.FullRowSelect;
this.dgvAllAssets.MultiSelect = false;
using (AccetManagementEntities db = new AccetManagementEntities())
{
dgvAllAssets.AutoGenerateColumns = false;
dgvAllAssets.DataSource = db.VIEWALLASSETS.ToList <VIEWALLASSET>();
}
}
public void LoadGrid()
{
dgvEmployee.DataSource = null;
using (AccetManagementEntities db = new AccetManagementEntities())
{
dgvEmployee.AutoGenerateColumns = false;
dgvEmployee.DataSource = db.VIEWALLEMPs.ToList <VIEWALLEMP>();
//this.dgvEmployee.SelectionMode =
//DataGridViewSelectionMode.FullRowSelect;
//this.dgvEmployee.MultiSelect = false;
}
}
public void LoadGrid()
{
dgvVendor.DataSource = null;
this.dgvVendor.SelectionMode =
DataGridViewSelectionMode.FullRowSelect;
this.dgvVendor.MultiSelect = false;
using (AccetManagementEntities db = new AccetManagementEntities())
{
dgvVendor.AutoGenerateColumns = false;
dgvVendor.DataSource = db.VENDORs.ToList <VENDOR>();
}
}
private void ToolStripButtonDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this record?", "DELETE EMPLOYEE?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
EMPLOYEETABLE eMPLOYEETABLE = new EMPLOYEETABLE
{
EMPID = Convert.ToString(this.dgvEmployee.CurrentRow.Cells["EMPNUMBER"].Value)
};
var empname = db.ASSETs.Where(x => x.EMPID == eMPLOYEETABLE.EMPID).Select(x => x.EMPNAME).FirstOrDefault();
if (empname == "" || empname == null)
{
int rows = dgvEmployee.RowCount;
for (int i = rows - 1; i >= 0; i--)
{
if (dgvEmployee.Rows[i].Selected)
{
eMPLOYEETABLE = db.EMPLOYEETABLEs.Where(x => x.EMPID == eMPLOYEETABLE.EMPID).FirstOrDefault();
var entry = db.Entry(eMPLOYEETABLE);
if (entry.State == EntityState.Unchanged)
{
db.EMPLOYEETABLEs.Attach(eMPLOYEETABLE);
db.EMPLOYEETABLEs.Remove(eMPLOYEETABLE);
db.SaveChanges();
LoadGrid();
if (dgvEmployee.CurrentRow == null)
{
MessageBox.Show("All Items deleted successfully");
}
else
{
dgvEmployee.Rows[0].Selected = false;
}
}
//db.VIEWALLASSETS.Remove(dgvAllAssets.Rows[i].DataBoundItem as VIEWALLASSET);
//vIEWALLASSETBindingSource.RemoveAt(dgvAllAssets.Rows[i].Index);
}
}
}
else
{
MessageBox.Show("Employee Cannot be deleted because there is an asset attatched to " + empname);
}
}
}
}
private void BtnCompleteCheckout_Click(object sender, EventArgs e)
{
CHECKOUTIN choi = new CHECKOUTIN();
try
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList();
var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList();
// UPDATE ASSETS TABLE
staId = statusId[0];
locId = LocationId[0];
UpdateAssetTable();
choi.EMPNAME = cmbCheckout.Text.ToString().Trim();// CommonData.Fname + " " + CommonData.Lname;
choi.ASSETNO = this.dgvItemsCheckedOut.CurrentRow.Cells[1].Value.ToString();
choi.COMMENT = rctComment.Text.ToString();
choi.DUEDATE = Convert.ToDateTime(dtpDate.Text.ToString());
choi.STATUSID = statusId[0];
choi.LOCATIONID = LocationId[0];
choi.DESCRIPTION = this.dgvItemsCheckedOut.CurrentRow.Cells[0].Value.ToString();
choi.CHECKOUTDATE = DateTime.Now;
choi.COMPNAME = Environment.MachineName;
//choi.EMPID = CommonData.PersonalNumber;
db.CHECKOUTINs.Add(choi);
db.SaveChanges();
this.Close();
MessageBox.Show("Saved Successfully to Database.");
Application.Restart();
//Main newMain = new Main();
//newMain.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex);
//throw;
}
}
void LoadCombobox()
{
//Clear combobox items first
cmBAssetType.Items.Clear();
cmBLocation.Items.Clear();
//get the items from db
using (AccetManagementEntities db = new AccetManagementEntities())
{
var assettypequery = db.ASSETTYPEs
.Select(e => e.ASSETTYPE1).ToList();
cmBAssetType.DataSource = assettypequery;
var locationquery = db.LOCATIONs
.Select(a => a.LOCATIONNAME).ToList();
cmBLocation.DataSource = locationquery;
}
}
private void LoadComboboxItems()
{
//Clear combobox items first
cmbStatus.Items.Clear();
cmbLocation.Items.Clear();
//get the items from db
using (AccetManagementEntities db = new AccetManagementEntities())
{
var statusquery = db.STATUS
.Select(a => a.STATUSNAME).ToList();
cmbStatus.DataSource = statusquery;
var locationquery = db.LOCATIONs
.Select(a => a.LOCATIONNAME).ToList();
cmbLocation.DataSource = locationquery;
}
}
public void populateControl(string assno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
//var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList();
//var statusId = assDetails[0].STATUSID;
//var dd = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList();
//var cond = assDetails[0].CONDITIONID;
//var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList();
//txtserial.SelectedText = assDetails[0].SERIALNUMBER;
//cmBStatus.Text = dd[0].ToString();
//txtcheckedOutto.Text = assDetails[0].EMPNAME;
//dueDatepicker.Text = assDetails[0].DUEDATE.ToString();
//txtNotes.Text = assDetails[0].NOTES;
}
}
private void InsetCheckinTable()
{
CHECKOUTIN choi = new CHECKOUTIN();
try
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList();
var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList();
choi.EMPNAME = CommonData.Fname + " " + CommonData.Lname;
choi.ASSETNO = this.dgvCheckin.CurrentRow.Cells[0].Value.ToString();
choi.COMMENT = richTextBoxComent.Text.ToString();
choi.DUEDATE = Convert.ToDateTime(this.dgvCheckin.CurrentRow.Cells[3].Value.ToString());
choi.STATUSID = statusId[0];
choi.LOCATIONID = LocationId[0];
choi.DESCRIPTION = this.dgvCheckin.CurrentRow.Cells[1].Value.ToString();
choi.CHECKOUTDATE = Convert.ToDateTime(this.dgvCheckin.CurrentRow.Cells[2].Value.ToString());
choi.COMPNAME = Environment.MachineName;
choi.CHECKINDATE = DateTime.Now;
//choi.EMPID = CommonData.PersonalNumber;
db.CHECKOUTINs.Add(choi);
db.SaveChanges();
this.Close();
MessageBox.Show("Saved Successfully to Database.");
Application.Restart();
//Main newMain = new Main();
//newMain.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex);
//throw;
}
}
void LoadCombobox()
{
//Clear combobox items first
// cmdDepreciation.Items.Clear();
cmdVendor.Items.Clear();
//get the items from db
using (AccetManagementEntities db = new AccetManagementEntities())
{
//var depquery = db.Depreciations
// .Select(e => e.DepresiationName).ToList();
//cmdDepreciation.DataSource = depquery;
//TO DO: ONCE DONE WITH VENDOR PAGE, LOAD VENDORS HERE
var vendorName = db.VENDORs
.Select(a => a.VENDORNAME).ToList();
cmdVendor.DataSource = vendorName;
}
}
private void DeleteImage(string assno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
ASSETIMAGE aSSETIMAGE = new ASSETIMAGE();
var assImage = db.ASSETIMAGEs.SingleOrDefault(x => x.ASSETID == assno);
aSSETIMAGE = db.ASSETIMAGEs.Where(x => x.ASSETID == assno).FirstOrDefault();
if (aSSETIMAGE != null)
{
var entry = db.Entry(aSSETIMAGE);
if (entry.State == EntityState.Unchanged)
{
db.ASSETIMAGEs.Attach(aSSETIMAGE);
db.ASSETIMAGEs.Remove(aSSETIMAGE);
db.SaveChanges();
}
}
}
}
internal void PopulateControls(string assno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var financeTableData = db.FINANCEs.SingleOrDefault(c => c.ASSETNO == assno);
var vendorId = db.VENDORs.Where(e => e.VENDORNO == financeTableData.VENDORNO).ToList();
Finances.VendorName = vendorId[0].VENDORNAME;
Finances.TxtPoNumber = financeTableData.PONO;
cmdVendor.Text = Finances.VendorName;
txtPoNumber.Text = Finances.TxtPoNumber;
recPeriod.Value = financeTableData.RECOVERYPERIOD;
txtPurchasePrice.Text = financeTableData.PURCHASEPRICE.ToString();
txtMarketVlaue.Text = financeTableData.MARKETVALUE.ToString();
txtScrapValue.Text = financeTableData.SCRAPEVALUE.ToString();
dtpPurchase.Value = financeTableData.PURCHASEDATE;
dtpWarranty.Value = financeTableData.WARRANTYEND;
dtpService.Value = financeTableData.INSERVICEDATE;
}
}
private void DeleteAssetFinance(string assno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
FINANCE aFinance = new FINANCE();
//var assFinance = db.FINANCEs.SingleOrDefault(x => x.ASSETNO == assno);
aFinance = db.FINANCEs.SingleOrDefault(x => x.ASSETNO == assno);
//db.ASSETIMAGEs.Where(x => x.ASSETID == assno).FirstOrDefault();
if (aFinance != null)
{
var entry = db.Entry(aFinance);
if (entry.State == EntityState.Unchanged)
{
db.FINANCEs.Attach(aFinance);
db.FINANCEs.Remove(aFinance);
db.SaveChanges();
}
}
}
}
void LoadCombobox()
{
//Clear combobox items first
cmBStatus.Items.Clear();
cmBCondition.Items.Clear();
//get the items from db
using (AccetManagementEntities db = new AccetManagementEntities())
{
var statusquery = db.STATUS
.Select(e => e.STATUSNAME).ToList();
cmBStatus.DataSource = statusquery;
var locationquery = db.CONDITIONs
.Select(a => a.CONDITIONNAME).ToList();
cmBCondition.DataSource = locationquery;
}
if (txtcheckedOutto.Text == " ")
{
btnUser.Enabled = false;
}
}
internal void PopulateControls(string assno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList();
var assetId = assDetails[0].ASSETTYPEID;
var dd = db.ASSETTYPEs.Where(e => e.ASSETTYPEID == assetId).Select(e => e.ASSETTYPE1).ToList();
var loc = assDetails[0].LOCATIONID;
var ddLoc = db.LOCATIONs.Where(e => e.LOCATIONID == loc).Select(e => e.LOCATIONNAME).ToList();
var statusId = assDetails[0].STATUSID;
var ddsi = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList();
var cond = assDetails[0].CONDITIONID;
var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList();
txtDesription.Text = assDetails[0].DESCRIPTION;
cmBAssetType.Text = dd[0].ToString();
cmBLocation.Text = ddLoc[0].ToString();
txtmanu.Text = assDetails[0].MANUFACTURER;
txtBrand.Text = assDetails[0].BRAND;
txtAssetNumber.Text = assDetails[0].ASSETNO;
//userControl11.txtserial.Text = assDetails[0].SERIALNUMBER;
//userControl11.cmBStatus.Text = ddsi[0].ToString();
//userControl11.cmBCondition.Text = ddCon[0].ToString();
//userControl11.txtcheckedOutto.Text = assDetails[0].EMPNAME.ToString();
//userControl11.dueDatepicker.Text = assDetails[0].DUEDATE.ToString();
//userControl11.txtNotes.Text = assDetails[0].NOTES;
//this.userControl11.Show();
//userControl11.BringToFront();
}
}
private void SaveCloseToolStripMenuItem_Click_1(object sender, EventArgs e)
{
UserControlFinance userControlFinance = new UserControlFinance();
var serial = userControl11.Controls.Find("txtserial", true);
var status = userControl11.Controls.Find("cmBStatus", true);
var condition = userControl11.Controls.Find("cmBCondition", true);
var checkedOutto = userControl11.Controls.Find("txtcheckedOutto", true);
var datepicker = userControl11.Controls.Find("dueDatepicker", true);
var txtNotes = userControl11.Controls.Find("txtNotes", true);
var r = condition[0].Text;
var currentStatus = status[0].Text;
var assetImage = userControl11.pictureBox1;
try
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var currentConditionId = db.CONDITIONs.Where(c => c.CONDITIONNAME == r).OrderBy(c => c.CONDITIONID).Select(c => c.CONDITIONID).ToList();
var assetId = db.ASSETTYPEs.Where(c => c.ASSETTYPE1 == cmBAssetType.Text).OrderBy(c => c.ASSETTYPEID).Select(c => c.ASSETTYPEID).ToList();
var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmBLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList();
var statusId = db.STATUS.Where(c => c.STATUSNAME == currentStatus).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList();
var aSSETs = txtAssetNumber.Text.Trim().ToString();
var assetTableData = db.ASSETs.SingleOrDefault(c => c.ASSETNO == aSSETs);
if (assetTableData == null)
{
userControlFinance.GetControls(txtAssetNumber.Text.Trim());
myAsset.ASSETNO = txtAssetNumber.Text.Trim();
myAsset.DESCRIPTION = txtDesription.Text.Trim();
myAsset.ASSETTYPEID = assetId[0];
myAsset.LOCATIONID = LocationId[0];
myAsset.MANUFACTURER = txtmanu.Text.Trim();
myAsset.BRAND = txtBrand.Text.Trim();
myAsset.MODEL = "NO MODEL YET";
myAsset.SERIALNUMBER = serial[0].Text; // data.serial;
myAsset.STATUSID = statusId[0]; //data.statusId;
myAsset.CONDITIONID = currentConditionId[0]; //data.conditionId;
myAsset.EMPNAME = checkedOutto[0].Text.ToString().Trim(); // data.Emp;
myAsset.DUEDATE = Convert.ToDateTime(datepicker[0].Text);
myAsset.NOTES = txtNotes[0].Text.ToString().Trim();
myAsset.ASSETIMAGEID = 1;
myAsset.CHECKOUTDATE = DateTime.Now;
myAsset.CHECKOUTCOMMENT = "";
myAsset.EMPID = "";
myAsset.RECEIVEDDATE = DateTime.Now;
db.ASSETs.Add(myAsset);
//save Picture
if (pictureBox1.Image != null)
{
ASSETIMAGE aSSETIMAGE = new ASSETIMAGE
{
ASSETID = aSSETs,
ASSETIMAGEID = 1,
Filepath = CommonData.Filename ?? ""
};
db.ASSETIMAGEs.Add(aSSETIMAGE);
}
}
else
{
// check whether userImage is in the database
var assImage = db.ASSETIMAGEs.SingleOrDefault(x => x.ASSETID == aSSETs);
string fileNamePth = CommonData.Filename ?? "";
if (assImage == null)
{
if (pictureBox1.Image != null)
{
ASSETIMAGE aSSETIMAGE = new ASSETIMAGE
{
ASSETID = aSSETs,
ASSETIMAGEID = 1,
Filepath = fileNamePth
};
db.ASSETIMAGEs.Add(aSSETIMAGE);
}
}
else
{
assImage.ASSETIMAGEID = 1;
assImage.ASSETID = aSSETs;
assImage.Filepath = fileNamePth;
}
//save finances changes first
userControlFinance.GetControls(txtAssetNumber.Text.Trim());
assetTableData.ASSETNO = txtAssetNumber.Text.Trim();
assetTableData.DESCRIPTION = txtDesription.Text.Trim();
assetTableData.ASSETTYPEID = assetId[0];
assetTableData.LOCATIONID = LocationId[0];
assetTableData.MANUFACTURER = txtmanu.Text.Trim();
assetTableData.BRAND = txtBrand.Text.Trim();
assetTableData.MODEL = "NO MODEL YET";
assetTableData.SERIALNUMBER = serial[0].Text; // data.serial;
assetTableData.STATUSID = statusId[0]; //data.statusId;
assetTableData.CONDITIONID = currentConditionId[0]; //data.conditionId;
assetTableData.EMPNAME = checkedOutto[0].Text.ToString().Trim(); // data.Emp;
assetTableData.DUEDATE = Convert.ToDateTime(datepicker[0].Text);
assetTableData.NOTES = txtNotes[0].Text.ToString().Trim();
assetTableData.ASSETIMAGEID = 1;
assetTableData.CHECKOUTDATE = DateTime.Now;
assetTableData.CHECKOUTCOMMENT = "";
assetTableData.EMPID = "";
assetTableData.RECEIVEDDATE = DateTime.Now;
}
db.SaveChanges();
this.Close();
MessageBox.Show("Saved Successfully to Database.");
Application.Restart();
//Main newMain = new Main();
//newMain.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex);
//throw;
}
}
internal void PopulateControls(string assno)
{
using (AccetManagementEntities db = new AccetManagementEntities())
{
var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList();
var assetId = assDetails[0].ASSETTYPEID;
var dd = db.ASSETTYPEs.Where(e => e.ASSETTYPEID == assetId).Select(e => e.ASSETTYPE1).ToList();
var loc = assDetails[0].LOCATIONID;
var ddLoc = db.LOCATIONs.Where(e => e.LOCATIONID == loc).Select(e => e.LOCATIONNAME).ToList();
var statusId = assDetails[0].STATUSID;
var ddsi = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList();
var cond = assDetails[0].CONDITIONID;
var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList();
txtDesription.Text = assDetails[0].DESCRIPTION;
cmBAssetType.Text = dd[0].ToString();
cmBLocation.Text = ddLoc[0].ToString();
txtmanu.Text = assDetails[0].MANUFACTURER;
txtBrand.Text = assDetails[0].BRAND;
txtAssetNumber.Text = assDetails[0].ASSETNO;
userControl11.txtserial.Text = assDetails[0].SERIALNUMBER;
userControl11.cmBStatus.Text = ddsi[0].ToString();
userControl11.cmBCondition.Text = ddCon[0].ToString();
userControl11.txtcheckedOutto.Text = assDetails[0].EMPNAME.ToString();
userControl11.dueDatepicker.Text = assDetails[0].DUEDATE.ToString();
userControl11.txtNotes.Text = assDetails[0].NOTES;
this.Text = "Edit Asset " + assDetails[0].ASSETNO;
var er = userControlFinance1.Controls.Find("txtPoNumber", true);
var financeTableData = db.FINANCEs.SingleOrDefault(c => c.ASSETNO == assno);
if (financeTableData != null)
{
if (financeTableData.VENDORNO != "")
{
var vendorId = db.VENDORs.Where(e => e.VENDORNO == financeTableData.VENDORNO).ToList();
userControlFinance1.txtPoNumber.Text = financeTableData.PONO;
userControlFinance1.cmdVendor.Text = vendorId[0].VENDORNAME;
userControlFinance1.recPeriod.Value = financeTableData.RECOVERYPERIOD;
userControlFinance1.txtPurchasePrice.Text = financeTableData.PURCHASEPRICE.ToString();
userControlFinance1.txtScrapValue.Text = financeTableData.SCRAPEVALUE.ToString();
userControlFinance1.txtMarketVlaue.Text = financeTableData.MARKETVALUE.ToString();
userControlFinance1.dtpPurchase.Value = financeTableData.PURCHASEDATE;
userControlFinance1.dtpWarranty.Value = financeTableData.WARRANTYEND;
userControlFinance1.dtpService.Value = financeTableData.INSERVICEDATE;
}
}
CommonData.SelectedEmpId = assDetails[0].EMPID;
//picture
string fileName = db.ASSETIMAGEs.Where(f => f.ASSETID == assno).Select(f => f.Filepath).FirstOrDefault();
if (fileName != null && fileName != "")
{
userControl11.pictureBox1.Image = UserControl1.ResizeImage(Image.FromFile(fileName), this.Width, this.Height);
}
else
{
}
}
}
