public NewJobDescription(IdentityObject ident, string docNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
textBox_DocNum.Text = docNum;
}
public DisplaySelectedObject_emp(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
//String userid = ident.UserID;
//String inp = textBox_DocNum.Text;
//string qty = "select ed.docRef from EmployeeBenefits_Details as ed, EmployeeBenefits as e where e.EmpID = '" + userid + "' and e.DocNum=ed.DocNum and ed.docRef = '" + inp + "' and ed.reqStatus = '2'";
//int quant = Utilities.DataBaseUtility.Execute(ident, qty);
//MessageBox.Show(quant.ToString());
//if (quant != 1)
//{
// //delete active
// //add inactive
// btn_add_benefit.Visible = false;
// btn_delete_benefit.Visible = true;
//}
//else
//{
// //delete inactive
// //add active
// btn_add_benefit.Visible = true;
// btn_delete_benefit.Visible = false;
//}
}
public List_Suppliers(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
comboBox1.SelectedIndex = 3;
}
public DisplayDelivery(IdentityObject _ident)
{
InitializeComponent();
ident = _ident;
LoadDelivery();
// comboBox1.SelectedIndex = 0;
}
public static void DeleteEntity(IdentityObject ident, string _tablename, string docNumStr, string docTypeStr)
{
OleDbConnection conn = GetConnectionObject();
//if (ident.ActionLevel < 5)
//{
// _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : "******"delete from {0} where DocNum = {1} ", _tablename, docNum); //, docType); //where DocNum = {1}",/* and
OleDbCommand cmd = new OleDbCommand(cmdStr, conn);
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show("Error Report: " + e.Message);
}
finally
{
conn.Close();
}
}
public SalesAndMarketingMain(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
label_SubName.Text = "Sales And Marketing";
}
public NewInterview(IdentityObject ident, string docNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
textBox_DocNum.Text = docNum;
}
public ConfirmOrder(IdentityObject ident,int promoProdId,String id,String price)
{
productOrBundle = id;
InitializeComponent();
this. price=Convert.ToDouble(price);
base.SaveIdent(ident);
base.DisplayIdent(ident);
this.promoProdId = promoProdId;
label_SubName.Text = "Pre Sales";
// MessageBox.Show("price-----------------------"+price);
label7.Text += price;
dataGridView2.DataSource= Utilities.DataBaseUtility.GetTable("select EmplID,FirstName,LastName from Employees");
dataGridView3.DataSource = Utilities.DataBaseUtility.GetTable("select CustomerID,FirstName,LastName from Customers");
if (id.Equals("bundle"))
{
dataGridView1.DataSource = Utilities.DataBaseUtility.GetTable("select * from Bundle_Details where PromoCode=" + promoProdId);
label6.Text = "Confirm Promo Bundle Details";
}
else
{
// MessageBox.Show("Confirm order"+promoProdId);
dataGridView1.DataSource = Utilities.DataBaseUtility.GetTable("select * from Products where ProductID=" + promoProdId);
label6.Text = "Confirm Product Details";
}
//MessageBox.Show("Confirm order");
}
public CreateTransaction(IdentityObject _ident)
{
InitializeComponent();
base.SaveIdent(_ident);
base.DisplayIdent(_ident);
// LoadBBasicDocInfo();
}
public DisplaySelectedObject(IdentityObject ident)
{
this.components = null;
this.InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public NewServiceOrder(IdentityObject ident)
{
InitializeComponent();
textBox_DocNum.Text = serObj.docnum.ToString();
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public DisplayEntity2(IdentityObject _ident, string entityID)
{
InitializeComponent();
base.SaveIdent(_ident);
textBox0.Text = entityID;
FillEntityList();
}
public AddServiceOrder(IdentityObject ident, String _Orderid, string Customerinp)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
ident_local = ident;
label_SubName.Text = "Sales_sm";
Doctype.Text ="22";
CustomerID.Text = Customerinp;
if (_Orderid == "")
{
_NewOrder = Utilities.DataBaseUtility.GetList("select max(Docnum)+1 from Service_Order_Details" );
FillTextBoxes("New");
FormMode = "New";
}
else {
_NewOrder = Utilities.DataBaseUtility.GetList("select * from Service_Order where Docnum =" +_Orderid );
FillTextBoxes("Update");
FormMode = "Update";
}
bind_data("Service_Order_Details", DocNum.Text );
ResultString = Customerinp;
}
public ShippingDoc( IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
label_UserName.Text = base.ident.UserName.Trim();
label_UserID.Text = base.ident.UserID.Trim();
}
public static Boolean Authorize(IdentityObject _ident, string _resource)
{
bool _authorized = false;
if (_ident.Role == "employee")
_authorized = true;
return _authorized;
}
public LogSrvcReq(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
label_SubName.Text="SALES S&M > LIST OF SERVICES";
}
public CreateReceivableDoc(IdentityObject ident)
{
this.components = null;
this.InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public Applications_ListObjects(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
loadTable();
}
public static int Execute(IdentityObject ident, string _sqlCommand)
{
// int retcode = 0; //string _message = "no errors";
OleDbConnection conn;
conn = GetConnectionObject();
try
{
//if (ident.ActionLevel < 5)
//{
// // _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : "******"could not execute " + _sqlCommand;
}
else
{
return(0); // "no errors";
}
}
catch (Exception)
{
return(2); // (e.ToString());
}
finally
{
conn.Close();
}
}
public CreateSalesOrder(IdentityObject ident, string tableName, string docType, string docNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
textBox_DocNum.Text = docNum;
textBox_DocType.Text = docType;
textBox_TableName.Text = tableName;
textBox_IntAgent.Text = ident.UserID;
textBox_Status.Text = "2";
textBox_ExtAgent.Text = "0";
textBox_TextValue1.Text = DateTime.Now.ToShortDateString().Substring(0, 9);
textBox_TextValue2.Text = DateTime.Now.ToShortDateString().Substring(0, 9);
textBox_ExpectedAmount.Text = "0";
textBox_ActualAmount.Text = "0";
//find next processID
nextProcessID = Sales_Main.GetNextNumber("ProcessDocs", 0, "");
textBox_ProcessID.Text = nextProcessID.ToString();
button_ResetCommand_Click(this, null);
List <string> materials = Utilities.DataBaseUtility.GetList("select Comments from Materials order by Comments", ',');
for (int i = 0; i < materials.Count; i++)
{
this.comboBox_Material.Items.Add(materials[i]);
}
Bind();
}
public Accounting_Main()
{
InitializeComponent();
IdentityObject _ident = new IdentityObject();
base.SaveIdent(_ident);
}
public DisplayServiceTypes(IdentityObject _ident)
{
InitializeComponent();
base.SaveIdent( _ident);
base.DisplayIdent(ident);
//FillCustomerList();
}
public Materials_Main(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
new Applications.Materials.MaterialsManagement.MaterialsManagement_Main(ident).Show();
}
public DisplayServiceTypes(IdentityObject _ident, String DocNum)
{
InitializeComponent();
base.SaveIdent(_ident);
base.DisplayIdent(ident);
textBox1.Text = DocNum;
}
public ReceivePayment(IdentityObject ident)
{
this.components = null;
this.InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public DisplayEmployee(IdentityObject _ident)
{
InitializeComponent();
base.SaveIdent(_ident);
LoadEmployees();
comboBox1.SelectedIndex = 1;
}
public HrAdmin_Update_Benefit(IdentityObject ident, String docNum, String benefitType)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
doc_Num = docNum;
benefit_Type = benefitType;
label_pickedDocNum.Text = docNum;
label_show_Btype.Text = benefitType;
List <string> _records = new List <string>();
try
{
// _documentValues = Utilities.DataBaseUtility.GetTable(cmdStr);
_records = Utilities.DataBaseUtility.GetList("select * from Benefits_Details where docNum = " + docNum + " and benefitType = " + benefitType);
}
catch (Exception ex)
{
MessageBox.Show(" error in reading table : select * from Benefits_Details where docNum = " + docNum + " and benefitType = " + benefitType, ex.Message);
return;
}
_records.RemoveAt(0);
string[] _documentValues = _records[0].Split(',');
level_o = _documentValues[2].ToString();
percent_o = _documentValues[4].ToString();
comment_o = _documentValues[7].ToString();
textBox_level.Text = level_o;
textBox_Percentage.Text = percent_o;
textBox_desc.Text = comment_o;
}
public AddServiceOrderItem(IdentityObject _ident, String _ServiceProductType ,String _DocNUM, String _DocType, String _ProductID, String _Quantity , String _Comment)
{
InitializeComponent();
base.SaveIdent( _ident);
//FillCustomerList();
panel1.Visible = true;
DataTable Services = Utilities.DataBaseUtility.GetTable("Select ServiceProductType, ServiceProductDescription from Service_Type");
ServiceProductTypeCombobox.DataSource = Services;
ServiceProductTypeCombobox.DisplayMember = "ServiceProductDescription";
ServiceProductTypeCombobox.ValueMember = "ServiceProductType";
CommentTxt.Text = _Comment;
ORDER_DOCNUMTXT.Text = _DocNUM;
ORDERDOCTYPETXT.Text = _DocType;
ProductIDTXT.Text = _ProductID;
QuanitytTXT.Text = _Quantity;
//If service product is passed then it is update else it is add item
if (!String.IsNullOrEmpty(_ServiceProductType) )
{ ServiceProductTypeCombobox.SelectedValue = _ServiceProductType;
button2.Text = "Update ServiceOrder";
}
// _ServiceTypes = Utilities.DataBaseUtility.GetList("select DocNum, DocType, EmployeeID, ServiceProductType, ServiceProductDescription, Rate, Standard_Hrs, GrossPrice, DateCreated, DateModified from Service_Type " + ProdTypeSql );
//FillTextBoxes();
}
public view_training_progress_and_report(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public DisplayEmployee(IdentityObject _ident)
{
InitializeComponent();
base.SaveIdent(_ident);
LoadEmployees();
comboBox1.SelectedIndex = 1;
}
public DisplaySelectedObject(IdentityObject ident)
{
InitializeComponent();
// textBox_TableName.Text = "Sales_sm";
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public DisplayInventoryItem(IdentityObject in_ident)
{
InitializeComponent();
_ident = in_ident;
base.ident = in_ident;
label_Ident.Text = _ident.UserID.ToString() + " : " + _ident.UserName;
}
public static string Execute(string _sqlCommand, IdentityObject ident)
{
string _message = "no errors";
OleDbConnection conn;
conn = GetConnectionObject();
try
{
//if (ident.ActionLevel < 5)
//{
// _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : "******"could not execute " + _sqlCommand;
return _message;
}
else return "no errors";
}
catch (Exception e)
{
return (e.ToString());
}
finally
{
conn.Close();
}
}
public HR_Main()
{
InitializeComponent();
IdentityObject ident = new IdentityObject();
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public HrBenefit_Employee(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
if (label_UserID.Text != "000")
{
emp_num = label_UserID.Text;
List <string> _records = new List <string>();
try
{
// _documentValues = Utilities.DataBaseUtility.GetTable(cmdStr);
_records = Utilities.DataBaseUtility.GetList("select docNum from EmployeeBenefits where EmpID = " + emp_num);
}
catch (Exception ex)
{
MessageBox.Show(" error in reading table : select docNum from EmployeeBenefits where EmpID = 101", ex.Message);
return;
}
_records.RemoveAt(0);
string[] _documentValues = _records[0].Split(',');
emp_doc_num = _documentValues[0].ToString();
}
}
public Documents_Main(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
Utilities.Documents.ListObjects pds = new Utilities.Documents.ListObjects(base.ident); pds.Show();
}
public DisplaySelectedObject(IdentityObject ident, string tableName, string docType, string docNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
textBox_DocNum.Text = docNum;
textBox_DocType.Text = docType;
textBox_TableName.Text = tableName;
button_ResetCommand_Click(this, null);
string sqlPosted = String.Format("Select DocNum from ProcessDocs where DocNum = {0} and DocType = {1}", docNum, docType);
List <string> mPosted = Utilities.DataBaseUtility.GetList(sqlPosted, ',');
if (mPosted.Count > 1)
{
button_PostSalesOrder.Visible = true;
}
if (docType == "21")
{
label_SubName.Text = "Sales Order";
button1.Visible = false;
}
else if (docType == "29")
{
label_SubName.Text = "Sales Quote";
string sqlConverted = String.Format("Select DocNum from ProcessDocs where DocType = 21 and DocNum =(Select DocRef from SalesQuotes where DocNum = {0})", docNum);
List <string> mConverted = Utilities.DataBaseUtility.GetList(sqlConverted, ',');
if (mConverted.Count > 1)
{
button1.Visible = false;
}
}
}
public Change(IdentityObject _ident, string _cmd, string tablename, string _docNum,string _docType, string type)
{
InitializeComponent();
base.SaveIdent(_ident);
base.DisplayIdent(_ident);
label_UserName.Text = base.ident.UserName.Trim();
label_UserID.Text = base.ident.UserID.Trim();
textBox_Cmd.Text = _cmd;
textBox_TableName.Text = tablename;
textBox_DocNum.Text = _docNum;
textBox_DocType.Text = _docType;
textBox_DataStrings.Visible = true;
//LoadSelectionInfo(_docType, _docNum);
LoadBBasicDocInfo();
// button_GetDocument_Click(this, null);
if (type == "view")
{
button_approve.Visible = false;
}
else if (type == "approve")
{
button_approve.Visible = true;
}
button_GetDoc_Click(this, null);
}
public AddNewJob(IdentityObject ident, string docNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
txtDocNum.Text = docNum;
}
public HrBenefit_Emp_Report(IdentityObject ident, String empDocNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
emp_num = empDocNum;
}
public DisplaySelectedObject(IdentityObject _ident)
{
InitializeComponent();
base.SaveIdent(_ident);
base.DisplayIdent(_ident);
LoadBBasicDocInfo();
}
public Training_Evaluation_Template(IdentityObject ident)
{
InitializeComponent();
label_SubName.Text = "Training and Evaluation";
base.SaveIdent(ident);
base.DisplayIdent(ident);
}
public Documents_Main(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
Utilities.Documents.ListObjects pds = new Utilities.Documents.ListObjects(base.ident); pds.Show();
}
public InventoryManagement_List(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
label_UserName.Text = base.ident.UserName.Trim();
label_UserID.Text = base.ident.UserID.Trim();
}
public int SaveDocument(IdentityObject ident, string _tableName, string inDocNum, string inDocType, List <string> myData)
{
int retCode = 0;
// DocNum = inDocNum;
DocNum = Int32.Parse(inDocNum);
DocType = Int32.Parse(inDocType);
string cmdString = String.Format("insert into {0} Values ({1})", _tableName.Trim(), myData[0]); //where DocNum = {1} and DocType = {2}", _tableName, inDocNum, inDocType);
string retMessage = Utilities.DataBaseUtility.Execute(cmdString, ident);
// if (mainString.Count < 2) return 0;
// if (mainString.Count > 2) return 3;
// count = 2, therefore found 1 data record and 1 string of names
// new GenDoc(mainString[1]);
// cmdString = String.Format("select * from DocumentDetails where DucNum = {0} and DocType = {1}, inDocNum, inDocType");
// List<string> detailStrings = Utilities.DataBaseUtility.GetList(cmdString);
if (myData.Count < 2)
{
return(0);
}
for (int i = 1; i < myData.Count; i++)
{
string cmdString2 = String.Format("insert into {0}_Details Values ({1})", _tableName.Trim(), myData[i]);
string retMessage2 = Utilities.DataBaseUtility.Execute(cmdString2, ident);
}
return(retCode);
}
public DisplayEntity(IdentityObject _ident, string custID)
{
InitializeComponent();
base.SaveIdent(_ident);
// textBox1.Text = custID;
// FillCustomerList();
}
public DisplayTransaction(IdentityObject _ident)
{
InitializeComponent();
IdentityObject ident = _ident;
LoadTransactions();
}
public Applications_DisplaySelectedObject(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
LoadApplications();
}
public Chart_Template(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
LoadChartTypes();
LoadReports();
}
public CreatePurchaseOrder(IdentityObject in_ident)
{
InitializeComponent();
_ident = in_ident;
if (_ident == null) _ident = base.ident;
if (_ident == null)
{
MessageBox.Show(" must log in with authority level > 1 to create purchase order");
return;
}
if (_ident.ActionLevel < 2)
{
MessageBox.Show(" must have higher authority level to create purchase order");
return;
}
FillSupplier();
textBox_Comment.Text = "new_PO";
textBox_Role.Text = _ident.Role;
textBox_Employee.Text = _ident.UserID;
textBox_AuthLevel.Text = _ident.ActionLevel.ToString();
button_Preview.Visible = false;
button_DataToText.Visible = false;
button_ConvertToSql.Visible = false;
textBox_Commands.Visible = false;
NewPurchaseOrder(_ident);
}
public CreateDelivery(string poID_Str, IdentityObject ident)
{
InitializeComponent();
_ident = ident;
_poID_Str = poID_Str;
NewDelivery(ident);
}
public PurchaseOrderDisplay(IdentityObject in_ident)
{
InitializeComponent();
loadPO_IDs();
base.SaveIdent( in_ident);
button_Display_Click(this, null);
}
public Interview_ListObjects(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
loadTable();
}
public DisplayCustomer(IdentityObject _ident, string custID)
{
InitializeComponent();
base.SaveIdent(_ident);
textBox1.Text = custID;
FillCustomerList();
}
public Inventory_product1(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
label_UserName.Text = base.ident.UserName.Trim();
label_UserID.Text = base.ident.UserID.Trim();
}
public ListObjects(IdentityObject ident)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
label_SubName.Text="Sales_sm";
}
public CreatePurchaseOrder(IdentityObject ident,Purchases.InventoryItem item)
{
InitializeComponent();
label_SubName.Text = "New Purchase Order";
_ident = ident;
textBox_Role.Text = _ident.Role;
if (_ident == null) _ident = new IdentityObject("111", "Johnson", "clerk", 1, 2);
textBox_Employee.Text = _ident.UserID;
textBox_AuthLevel.Text = _ident.ActionLevel.ToString();
FillSupplier();
comboBox1.SelectedIndex = item.Supplier;
textBox_Supplier.Text = item.Supplier.ToString();
comboBox1_SelectedIndexChanged(this, null);
_productID = item.ProductID.ToString();
//textBox_Comment.Text = "Product No:" + _productID + "(" + item.ProductName +")";
textBox_OnHand.Text = item.OnHand.ToString();
textBox_MinQuantity.Text = item.MinQuantity.ToString();
textBox_Quantity.Text = (item.MinQuantity - item.OnHand).ToString();
textBox_Price.Text = item.Cost.ToString();
textBox_ProductID.Text = item.InvID.ToString();
textBox_PO_ID2.Text = item.ProductName.ToString();
button_Preview.Visible = false;
button_DataToText.Visible = false;
button_ConvertToSql.Visible = false;
NewPurchaseOrder(_ident);
}
public Products_List(IdentityObject identObject)
{
InitializeComponent();
base.SaveIdent(identObject);
_supplierNames = Utilities.DataBaseUtility.GetList(" select Name from suppliers");
for (int i = 1; i < 8; i++)
comboBox1.Items.Add(i.ToString() + " : " + _supplierNames[i]);
}
public Employees_List(IdentityObject identObject)
{
InitializeComponent();
base.SaveIdent(identObject);
_employeeIDs = Utilities.DataBaseUtility.GetList(" select EmplID, LastName from employees");
for (int i = 1; i < _employeeIDs.Count; i++)
comboBox1.Items.Add(_employeeIDs[i] + " : ");
}
//public CreateDelivery()
//{
// InitializeComponent();
// _ident = new IdentityObject();
// textBox_Comment.Text = "new_PO";
// NewDelivery(_ident);
//}
public CreateDelivery(IdentityObject ident)
{
InitializeComponent();
_ident = ident;
base.ident = ident;
textBox_Comment.Text = "new_PO";
NewDelivery(_ident);
}
