private void BindddNazar() { DataSet ds = CatalogClass.GetListTypeID("11"); ddnazar.DataSource = ds; ddnazar.DataTextField = "CatalogName"; ddnazar.DataValueField = "CatalogValue"; ddnazar.DataBind(); ddRequestStatus.DataSource = ds; ddRequestStatus.DataTextField = "CatalogName"; ddRequestStatus.DataValueField = "CatalogValue"; ddRequestStatus.DataBind(); ddRequestStatus.Items.Insert(0, new ListItem("همه موارد", "-1")); ddRequestStatus.Items.Insert(1, new ListItem("پرداخت شده", "-2")); ClCompany cl = new ClCompany(); ddcompany.DataSource = CompanyClass.GetList(cl); ddcompany.DataTextField = "CompanyName"; ddcompany.DataValueField = "CompanyID"; ddcompany.DataBind(); ddcompany.Items.Insert(0, new ListItem("بدون انتخاب", "0")); ds.Dispose(); }
public void GetCompany() { CompanyClass com = new CompanyClass(); company comp =com.getCompanyByName(Request.Form["name"]); if (comp != null) { Response.Write("success," + comp.name + "," ); foreach (product p in comp.products) { Response.Write(p.name+"&&"+p.price+" ج &&"+p.enterDate.ToString("yyyy-MM-dd")+"&&"); int currentCost = 0; foreach (productPay pp in p.productPays) { currentCost += pp.cost; Response.Write(pp.cost + " ج %%" + pp.payDate.ToString("yyyy-MM-dd")+"%%"+pp.id+"##"); } Response.Write("&&" + currentCost + " ج &&" + p.notes + "&&"+p.id+ "^^"); } } else { Response.Write("fail"); } }
protected void BtnInsert_Click(object sender, EventArgs e) { ClCompany cl = new ClCompany(); cl = Data; int i = 0; if (LblParamCompanyID.Text == "0") { i = CompanyClass.insert(cl); } else { i = CompanyClass.Update(cl); } if (i.ToString() == "0") { Utility.ShowMsg(Page, ProPertyData.MsgType.General_Fault, "ثبت با خطا مواجه شد"); } else { // Utility.ShowMsg(Page, ProPertyData.MsgType.General_Success, "ثبت با موفقیت انجام شد."); //Session["CompanyID"] = LblParamCompanyID.Text; BindGrid(); LightBox.Value = "0"; } LblParamCompanyID.Text = "0"; }
public int CompnaytypeID() { string ctype = "0"; ClCompany cl = new ClCompany(); cl.PersonalID = PersonID; DataSet ds = CompanyClass.GetListPersonl(cl); if (ds.Tables[0].Rows.Count > 0) { ctype = ds.Tables[0].Rows[0]["CompanyTypeID"].ToString(); if (ctype == "2") { sa1.Visible = true; sa2.Visible = true; } else { sa1.Visible = false; sa2.Visible = false; } } else { sa1.Visible = false; sa2.Visible = false; ctype = "-1"; } return(Convert.ToInt32(ctype)); }
public List <CompanyClass> GetDataSource() { SqlConnection con = new SqlConnection(Constring); string query = @"SELECT * FROM CompanyTable"; SqlCommand command = new SqlCommand(query, con); con.Open(); SqlDataAdapter da = new SqlDataAdapter(command); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); List <CompanyClass> company = new List <CompanyClass>(); foreach (DataRow a in dt.Rows) { CompanyClass companyc = new CompanyClass(); // dipstudent.Id = Convert.ToInt32(a["Id"]); companyc.Name = a["Name"].ToString(); //dipstudent.Code = a["Code"].ToString(); //dipstudent.Address = a["Address"].ToString(); company.Add(companyc); } return(company); }
public List <CompanyClass> CheckCompanyID(string companyID) { List <CompanyClass> company = new List <CompanyClass>(); CompanyClass objemp = new CompanyClass(); company = objemp.CheckCompanyID(companyID); return(company); }
public void BindDD() { ClCompany cl = new ClCompany(); DataSet ds = CompanyClass.GetList(new ClCompany()); ddCompany.DataSource = ds; ddCompany.DataTextField = "CompanyName"; ddCompany.DataValueField = "CompanyID"; ddCompany.DataBind(); }
private void twUsers_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { CompanyClass uc = e.Node.Tag as CompanyClass; txtTrivetId.Text = uc.CompanyID.ToString(); txtTrivetName.Text = uc.CompanyName; textTrivetCount.Text = uc.CompanyCount.ToString(); // twUserAssociated.Nodes.Clear(); }
private void twWishItems_AfterSelect(object sender, TreeViewEventArgs e) { twTrivet.Nodes.Clear(); List <CompanyClass> _users = CompanyClass.GetAllCompany(); foreach (CompanyClass user in _users) { TreeNode tn = new TreeNode(user.CompanyName); tn.Tag = user; twTrivet.Nodes.Add(tn); } }
private void LoadSomeData(String s) { twDataItems.Nodes.Clear(); List <DataClass> items = DataClass.GetSomeData(CompanyClass.GetAllCompanyWithName(s)); foreach (DataClass dc in items) { TreeNode tn = new TreeNode(CompanyClass.GetCompanyNameByCompanyIDAsString(DataClass.GetCompanyIDFromDataIDAsString(dc.DataID)) + dc.DataWeight.ToString() + "g " + dc.DataTime); tn.Tag = dc; twDataItems.Nodes.Add(tn); } }
private void LoadAllCompanies() { twCompany.Nodes.Clear(); List <CompanyClass> _company = CompanyClass.GetAllCompany(); foreach (CompanyClass company in _company) { TreeNode tn = new TreeNode(company.CompanyName + " (" + company.CompanyCount + ") "); tn.Tag = company; twCompany.Nodes.Add(tn); } }
public void deleteDof3a() { int Id = int.Parse(Request.Form["id"]); CompanyClass com = new CompanyClass(); if (com.deleteDof3a(Id)) { Response.Write("success"); } else { Response.Write("fail"); } }
public ActionResult UserEdit() { try { Company company = db.Company.Find(GlobalClass.Company.CompanyKey); CompanyClass model = val.FillCompanyInfo(company); return(View(model)); } catch (Exception e) { return(View("Error", new HandleErrorInfo(e, "Index", "UserHome"))); } }
public ActionResult UserEdit(CompanyClass company, HttpPostedFileBase file) { try { if (ModelState.IsValid) { Company obj = db.Company.Find(company.CompanyKey); if (file != null) { byte[] data = null; using (Stream inputStream = file.InputStream) { MemoryStream memoryStream = inputStream as MemoryStream; if (memoryStream == null) { memoryStream = new MemoryStream(); inputStream.CopyTo(memoryStream); } data = memoryStream.ToArray(); } obj.Logo = data; obj.LogoType = file.ContentType; } company = val.ValidateCompanyClass(company); obj.CompanyID = company.CompanyID; obj.CompanyName = company.CompanyName; obj.ZIPKey = company.ZIPKey; obj.StateCode = company.StateCode; obj.CityKey = company.CityKey; obj.CompanyAddress = company.CompanyAddress; obj.CompanyPhone = company.CompanyPhone; obj.CompanyMobile = company.CompanyMobile; obj.CompanyEmail = company.CompanyEmail; obj.CompanyWebsite = company.CompanyWebsite; obj.CompanyFax = company.CompanyFax; obj.ContactPersonName = company.ContactPersonName; obj.ContactPersonNo = company.ContactPersonNo; obj.Title = company.Title; obj.ContactEmail = company.ContactEmail; db.SaveChanges(); return(RedirectToAction("UserDetails")); } return(View(company)); } catch (Exception e) { return(View("Error", new HandleErrorInfo(e, "Index", "UserHome"))); } }
public void BindDD() { ClCompany cl = new ClCompany(); DDCompanyID.DataSource = CompanyClass.GetList(cl); DDCompanyID.DataTextField = "CompanyName"; DDCompanyID.DataValueField = "CompanyID"; DDCompanyID.DataBind(); DDCompanyID.Items.Insert(0, new ListItem("", "0")); //DDDiscountTypeID.DataSource = CatalogClass.GetListDiscountType(); //DDDiscountTypeID.DataTextField = "CatalogName"; //DDDiscountTypeID.DataValueField = "caid"; //DDDiscountTypeID.DataBind(); }
private string GetCompanyID(int PersonalId) { ClCompany clCompany = new ClCompany(); clCompany.PersonalID = PersonalId; DataSet ds = CompanyClass.GetListPersonl(clCompany); DataRow dr; if (ds.Tables[0].Rows.Count > 0) { dr = ds.Tables[0].Rows[0]; lblCompanyID.Text = dr["CompanyID"].ToString(); } ds.Dispose(); return(lblCompanyID.Text); }
public bool DuplicateCheck(CompanyClass _companyClass) { SqlConnection con = new SqlConnection(Constring); string quary = @"Select * from CompanyTable Where Name='" + _companyClass.Name + "' "; SqlCommand cmd = new SqlCommand(quary, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { try { if (Request.QueryString["cname"] == null) { ClCompany cl = new ClCompany(); cl.companyID = Convert.ToInt32(Request.QueryString["cid"]); DataSet ds = CompanyClass.GetList(cl); DataRow dr = ds.Tables[0].Rows[0]; lblCompanyName.Text = dr[""].ToString(); } lblCompanyName.Text = Request.QueryString["cname"].ToString(); } catch { } }
private void BindGrid() { ClCompany cl = new ClCompany(); cl.YearIDfilter = Convert.ToInt32(ddDefauleYear.SelectedValue); DataSet ds = CompanyClass.GetListCompanyRequest(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["PersonalID"] == null) { ViewState["PersonalID"] = "PersonalID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["PersonalID"].ToString()).ToString(); grid1.DataSource = dv; grid1.DataBind(); }
public void BindGrid() { ClCompany cl = new ClCompany(); cl = Data; DataSet ds = CompanyClass.GetList(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["CompanyID"] == null) { ViewState["CompanyID"] = "CompanyID Desc"; } dv.Sort = ViewState["CompanyID"].ToString(); GridView1.DataSource = dv; GridView1.DataBind(); }
public bool Save(CompanyClass _companyClass) { SqlConnection con = new SqlConnection(Constring); string query = @"Insert into CompanyTable (Name) Values('" + _companyClass.Name + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); int rowAffected = cmd.ExecuteNonQuery(); con.Close(); if (rowAffected > 0) { return(true); } return(false); }
//Save Company - Also updates the TreeNode and Resets the textboxes so you can't overwrite the newly made entity. Pop-up box with if it saved or not private void btnSaveCompany_Click(object sender, EventArgs e) { CompanyClass cc = new CompanyClass(); cc.CompanyID = System.Convert.ToInt32(txtCompanyId.Text); cc.CompanyName = txtCompanyName.Text; cc.CompanyCount = System.Convert.ToInt32(txtCompanySize.Text); if (cc.SaveMe("") != true) { MessageBox.Show("Could not save"); } else { MessageBox.Show("Company Saved"); LoadAllCompanies(); ResetCompany(); } }
//遍历子公司 private void RecursivelyCompanyClass(Guid companyClassId, RadTreeNode node) { var companyClass = new CompanyClass(GlobalConfig.DB.FromType.Read); IList <CompanyClassInfo> childCompanyClassList = companyClass.GetChildCompanyClassList(companyClassId); foreach (CompanyClassInfo companyClassInfo in childCompanyClassList) { if (string.IsNullOrWhiteSpace(companyClassInfo.CompanyClassName)) { continue; } RadTreeNode childNode = CreateNode(companyClassInfo.CompanyClassName, "BusinessRelatedUnits", false, companyClassInfo.CompanyClassId.ToString()); childNode.PostBack = true; node.Nodes.Add(childNode); RecursivelyCompanyClass(companyClassInfo.CompanyClassId, childNode); RepetitionCompanyCussent(companyClassInfo.CompanyClassId, childNode); } }
/// <summary> /// Clear the invite and send a whisper letting them know that /// this has occured. /// </summary> /// <param name="companyName"></param> /// <returns></returns> IEnumerator ClearInvite(string companyName) { Debug.Log("Clearing invite."); yield return(new WaitForSeconds(300)); company = companies[companyName]; string invitedUsername = company.GetFirstInvite(); company.RemoveFirstInvite(); string founderUsername = company.GetOwner; // TODO - Currently whispers are broken client.SendWhisper(founderUsername, "Your invite to " + invitedUsername + " has run out."); Debug.Log("Invite ran out."); }
public bool Save(CompanyClass _companyClass) { bool dupCheck = _companyRepository.DuplicateCheck(_companyClass); if (dupCheck) { MessageBox.Show("Name is Exist"); } else { bool isSave = _companyRepository.Save(_companyClass); if (isSave) { return(true); } } return(false); }
public void DeleteItem(object sender, System.EventArgs e) { String cid = ((HtmlAnchor)sender).HRef.ToString(); //ClCompany cl = new ClCompany(); //cl.CompanyID = Convert.ToInt32(cid); int i = CompanyClass.Delete(cid); if (i == 0) { Utility.ShowMsg(Page, ProPertyData.MsgType.warning, "خطا در حذف"); //ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true); } else { BindGrid(); } LightBox.Value = "0"; }
public void AddDof3a() { int productId = int.Parse(Request.Form["id"]); int cost = int.Parse(Request.Form["cost"]); DateTime date; CultureInfo enUS = new CultureInfo("en-US"); DateTime.TryParseExact(Request.Form["date"], "yyyy-MM-dd", enUS, DateTimeStyles.None, out date); CompanyClass com = new CompanyClass(); int productPayId = 0; if (com.AddDof3a(productId, cost, date , out productPayId)) { Response.Write("success," + productPayId); } else { Response.Write("fail"); } }
public DiConnectionCompany(string server, int dbServerType, string userName, string password, string companyDb) { Company = new CompanyClass { Server = server, DbServerType = (BoDataServerTypes)dbServerType, UserName = userName, Password = password, CompanyDB = companyDb, language = BoSuppLangs.ln_English }; Company.Connect(); if (!Company.Connected) { throw new Exception($"Cannot Connect To the Server : {Company.GetLastErrorDescription()} : " + $"Server : {Company.Server}, " + $"DbServerType : {Company.DbServerType}," + $"UserName : {Company.UserName}," + $"CompanyDB : {Company.CompanyDB}"); } }
private string CreateCustomerID(CompanyClass classID) { string id = null; if (classID == CompanyClass.Customer) { id = ProviderFactory.Create <IAutoNumberCreater>(RepoUri).CreateNumber(UserSettings.Current.CustomerPrefix, UserSettings.Current.CustomerSerialCount, "customer"); } else if (classID == CompanyClass.Supplier) { id = ProviderFactory.Create <IAutoNumberCreater>(RepoUri).CreateNumber(UserSettings.Current.SupplierPrefix, UserSettings.Current.SupplierSerialCount, "supplier"); } else if (classID == CompanyClass.Proxy) { id = ProviderFactory.Create <IAutoNumberCreater>(RepoUri).CreateNumber("P", 3, "ProxyCompany"); } else { id = ProviderFactory.Create <IAutoNumberCreater>(RepoUri).CreateNumber("RC", 3, "relatedCompany"); } return(id); }
/// <summary>获取往来单位分类 /// </summary> /// <param name="companyClassId"></param> /// <param name="depth"></param> /// <returns></returns> public static IList <CompanyClassInfo> RecursionCompanyClass(Guid companyClassId, int depth) { depth++; var companyClass = new CompanyClass(GlobalConfig.DB.FromType.Read); IList <CompanyClassInfo> companyClassTree = new List <CompanyClassInfo>(); IList <CompanyClassInfo> companyClassList = companyClass.GetChildCompanyClassList(companyClassId); string tag = depth == 1 ? "+" : "|" + new String('-', depth * 2); foreach (CompanyClassInfo companyClassInfo in companyClassList) { companyClassInfo.CompanyClassName = tag + companyClassInfo.CompanyClassName; companyClassTree.Add(companyClassInfo); foreach ( CompanyClassInfo childCompanyClassInfo in RecursionCompanyClass(companyClassInfo.CompanyClassId, depth)) { companyClassTree.Add(childCompanyClassInfo); } } return(companyClassTree); }
private void CompanySelectForm_Load(object sender, EventArgs e) { CompanyClass cn = new CompanyClass(); DataTable dt = cn.getAllCompany(); foreach (DataRow d in dt.Rows) { Button bt = new Button(); bt.Tag = d["com_id"]; bt.BackColor = Color.DodgerBlue; //Color.FromArgb(0, 0, 180, 255); bt.ForeColor = Color.White; bt.Font = new Font("Tahoma", 10, FontStyle.Bold); bt.Cursor = Cursors.Hand; bt.FlatStyle = FlatStyle.Flat; bt.Width = 250; bt.Padding = new Padding(5, 5, 5, 5); bt.AutoSize = true; bt.Text = d["com_name"].ToString(); bt.Click += Bt_Click; flowLayoutPanel1.Controls.Add(bt); } }
public int InsertCompany(CompanyClass comp) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmdQual = new SqlCommand("INSERT INTO Company(CompanyID, CompanyName, RegistrationNum, FspNum, Title, FirstName, Surname, Initials, Designation, PhoneNo, FaxNo, CellNo, Email, Address, Region, Suburb, Town, PostalCode) VALUES(@CompanyID, @CompanyName, @RegistrationNum, @FspNum, @Title, @FirstName, @Surname, @Initials, @Designation, @PhoneNo, @FaxNo, @CellNo, @Email, @Address, @Region, @Suburb, @Town, @PostalCode)", conn); cmdQual.Parameters.Add(new SqlParameter("@CompanyID", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@CompanyID"].Value = comp.CompanyID; cmdQual.Parameters.Add(new SqlParameter("@CompanyName", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@CompanyName"].Value = comp.CompanyName; cmdQual.Parameters.Add(new SqlParameter("@RegistrationNum", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@RegistrationNum"].Value = comp.RegistrationNum; cmdQual.Parameters.Add(new SqlParameter("@FspNum", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@FspNum"].Value = comp.FspNum; cmdQual.Parameters.Add(new SqlParameter("@Title", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Title"].Value = comp.Title; cmdQual.Parameters.Add(new SqlParameter("@FirstName", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@FirstName"].Value = comp.FirstName; cmdQual.Parameters.Add(new SqlParameter("@Surname", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Surname"].Value = comp.Surname; cmdQual.Parameters.Add(new SqlParameter("@Initials", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Initials"].Value = comp.Initials; cmdQual.Parameters.Add(new SqlParameter("@Designation", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Designation"].Value = comp.Designation; cmdQual.Parameters.Add(new SqlParameter("@PhoneNo", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@PhoneNo"].Value = comp.PhoneNo; cmdQual.Parameters.Add(new SqlParameter("@FaxNo", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@FaxNo"].Value = comp.FaxNo; cmdQual.Parameters.Add(new SqlParameter("@CellNo", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@CellNo"].Value = comp.CellNo; cmdQual.Parameters.Add(new SqlParameter("@Email", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Email"].Value = comp.Email; cmdQual.Parameters.Add(new SqlParameter("@Address", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Address"].Value = comp.Address; cmdQual.Parameters.Add(new SqlParameter("@Region", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Region"].Value = comp.Region; cmdQual.Parameters.Add(new SqlParameter("@Suburb", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Suburb"].Value = comp.Suburb; cmdQual.Parameters.Add(new SqlParameter("@Town", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@Town"].Value = comp.Town; cmdQual.Parameters.Add(new SqlParameter("@PostalCode", System.Data.SqlDbType.NVarChar)); cmdQual.Parameters["@PostalCode"].Value = comp.PostalCode; try { conn.Open(); return(cmdQual.ExecuteNonQuery()); } catch (SqlException ex) { throw new ApplicationException("Error adding Company\n\n" + ex.Message); } finally { conn.Close(); } } }
public static bool ProcessItem(string fileContent) { item item = new item(); DALPortalDataContext dc = new DALPortalDataContext(); Boolean update; String companyCode = String.Empty; //outCompanyCode = String.Empty; try { XDocument xmldoc = XDocument.Parse(fileContent); XElement docTypeElement = xmldoc.Element("MATMAS05"); XElement iDocElement = docTypeElement.Element("IDOC"); var itemHeaderElement = iDocElement.Element("E1MARAM"); // ItemCode, remove leading zero's from ItemCode String itemCode = RemoveLeadingZeros(itemHeaderElement.Element("MATNR").Value).ToString(); String sectionCode = itemHeaderElement.Element("E1MVKEM").Element("VKORG").Value; companyCode = CompanyClass.GetCompanyBasedOnSection(sectionCode, dc); // Check if item Already exists item = ItemClass.GetItem(itemCode, companyCode, dc); if (item == null) { item = new item(); update = false; } else { update = true; } if (!update) { item.companyCode = companyCode; } // Mapp customer header data item.itemCode = itemCode; // English description XElement ItemDescElement = itemHeaderElement.Elements("E1MAKTM").ToList().Where(c => c.Element("MSGFN").Value.Equals("005") && c.Element("SPRAS_ISO").Value.Equals("EN")).FirstOrDefault(); if (ItemDescElement != null) { XElement ItemDescElement2 = ItemDescElement.Element("MAKTX"); if (ItemDescElement2 != null) { item.description = ItemDescElement2.Value; } } // Certificate Type. // 00 = Cert. Niet van toepassing if (itemHeaderElement.Elements().Any(c => c.Name.ToString().Equals("GTIN_VARIANT"))) { item.CertificateType = itemHeaderElement.Element("GTIN_VARIANT").Value; } } catch (Exception ex) { Trace.WriteLine(String.Format("Error converting item {0} for company {1} from SAP ECC6 XML format. Error: {2}", item.itemCode, companyCode, ex.Message), "ProcessItem"); return(false); } if (update) { try { dc.SubmitChanges(); Trace.WriteLine(String.Format("Updating Item {0} for company {1} Successfull.", item.itemCode, companyCode), "ProcessItem"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Updating Item {0} for company {1}. Error: {2}", item.itemCode, companyCode, ex.Message), "ProcessItem"); return(false); } } else { try { dc.items.InsertOnSubmit(item); dc.SubmitChanges(); Trace.WriteLine(String.Format("Creating Item {0} for company {1} Successfull.", item.itemCode, companyCode), "ProcessItem"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Creating Item {0} for company {1}. Error: {2}", item.itemCode, companyCode, ex.Message), "ProcessItem"); return(false); } } return(true); }
private void button_refreshcompany_Click(object sender, EventArgs e) { this.input_forceDB.Checked = false; CompanyClass db = new CompanyClass(); db.Server = this.input_server.Text; db.DbUserName = this.input_serveruserid.Text; db.DbPassword = this.input_serverpassword.Text; db.UseTrusted = this.input_usetrusted.Checked; db.language = BoSuppLangs.ln_English; Recordset rs; try { rs = db.GetCompanyList(); DataTable myTable = new DataTable("companies"); DataColumn dbItem = new DataColumn("dbName", Type.GetType("System.String")); DataColumn cmpItem = new DataColumn("cmpName", Type.GetType("System.String")); DataColumn versItem = new DataColumn("versStr", Type.GetType("System.String")); myTable.Columns.Add(dbItem); myTable.Columns.Add(cmpItem); myTable.Columns.Add(versItem); DataView firstView = new DataView(myTable); int companyCount = rs.RecordCount; rs.MoveFirst(); DataRow NewRow; for (int c = 0; c < companyCount; c++) { NewRow = myTable.NewRow(); NewRow["dbName"] = rs.Fields.Item("dbName").Value; NewRow["cmpName"] = rs.Fields.Item("cmpName").Value; NewRow["versStr"] = rs.Fields.Item("versStr").Value; myTable.Rows.Add(NewRow); rs.MoveNext(); } this.input_company.DataSource = firstView; this.input_company.DisplayMember = "cmpName"; this.input_company.ValueMember = "dbName"; } catch (System.Exception ex) { MessageBox.Show("Failed to get company list (perhaps you should try DB direct):" + ex.Message); return; } }
private CompanyClass SetLoginInfo() { CompanyClass session = new CompanyClass(); session.Server = this.input_server.Text; session.UserName = this.input_username.Text; session.Password = this.input_password.Text; session.DbUserName = this.input_serveruserid.Text; session.DbPassword = this.input_serverpassword.Text; session.UseTrusted = this.input_usetrusted.Checked; session.LicenseServer = this.input_licensesrv.Text; session.language = BoSuppLangs.ln_English; switch ((string)this.input_dbservertype.SelectedItem) { case "MSSQL2005": session.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2005; break; case "MSSQL": session.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL; break; case "DB2": session.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_DB_2; break; case "SYBASE": session.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_SYBASE; break; default: session.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2005; break; } return session; }