// public ActionResult InsertMasterData(MasterTable _Master) public ActionResult InsertMasterData(HybridClass _obj) { //string _FolderPath = "~/FileFolder/UserRegFiles"; //string _fileName = _obj.ProjectInformation.FileName; //string _fileExt = System.IO.Path.GetExtension(_fileName); //bool exists = System.IO.Directory.Exists(Server.MapPath(_FolderPath)); //if (!exists) // System.IO.Directory.CreateDirectory(Server.MapPath(_FolderPath)); // string _folderPath= DateTime.Now.ToString("yyyyMMddHHmmssfff") + "_" + Guid.NewGuid().ToString("N")+ _fileExt; //var path = System.IO.Path.Combine(Server.MapPath(_FolderPath), _folderPath); // _obj.ProjectInformation.SaveAs(path); MasterTable _objmaster = new MasterTable(); _objmaster.Master_Email = Request.Form["_MasterTable.Master_Email"]; _objmaster.PassWord = Request.Form["_MasterTable.PassWord"]; _objmaster.Master_Name = Request.Form["_MasterTable.Master_Name"]; // _objmaster.ImageId = Convert.ToInt16(Request.Form["_MasterTable.ImageId"]); _objmaster.ImageId = 1; _objmaster.ContryId = Convert.ToInt16(Request.Form["_MasterTable.ContryId"]); _objmaster.StateId = Convert.ToInt16(Request.Form["_MasterTable.StateId"]); _objmaster.CityId = Convert.ToInt16(Request.Form["_MasterTable.CityId"]); if (ModelState.IsValid) { int res = _ObjRepo.InsertData(_objmaster); return(RedirectToAction("Index")); } return(View("Index")); }
private void Button_Click(object sender, RoutedEventArgs e) { MasterTable masterTable = new MasterTable(); masterTable.Show(); this.Close(); }
private void Btndeletemastergp_Click(object sender, EventArgs e) { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "accounts.sqlite"); var db = new SQLiteConnection(dpPath); var subitem = new SubAccountTable(); subitem.MId = Convert.ToInt32(txtviewid.Text); var data_s = db.Query <SubAccountTable>("select * from SubAccountTable where mid=" + Convert.ToInt32(txtviewid.Text)); if (data_s.Count > 0) { Toast.MakeText(this, "Record Will not deleted as Sub A/c Exists...,", ToastLength.Short).Show(); } else { var item = new MasterTable(); item.Id = Convert.ToInt32(txtviewid.Text); var data = db.Delete(item); Toast.MakeText(this, "Record Deleted Successfully...,", ToastLength.Short).Show(); txtmastergp.Text = ""; load_spiner_master(); } }
internal Master(kcsapi_start2 start2) { this.ShipTypes = new MasterTable<ShipType>(start2.api_mst_stype.Select(x => new ShipType(x))); this.Ships = new MasterTable<ShipInfo>(start2.api_mst_ship.Select(x => new ShipInfo(x))); this.SlotItems = new MasterTable<SlotItemInfo>(start2.api_mst_slotitem.Select(x => new SlotItemInfo(x))); this.UseItems = new MasterTable<UseItemInfo>(start2.api_mst_useitem.Select(x => new UseItemInfo(x))); this.Missions = new MasterTable<Mission>(start2.api_mst_mission.Select(x => new Mission(x))); }
internal SlotItemInfo(kcsapi_mst_slotitem rawData, MasterTable <SlotItemEquipType> types) : base(rawData) { this.EquipType = types[rawData.api_type?[2] ?? 0] ?? SlotItemEquipType.Dummy; KanColleClient.Current.Translations.Subscribe(x => { this.RaisePropertyChanged("Name"); }); }
public MapArea(kcsapi_mst_maparea maparea, MasterTable <MapInfo> mapInfos) : base(maparea) { this.Id = maparea.api_id; this.Name = maparea.api_name; this.MapInfos = new MasterTable <MapInfo>(mapInfos.Values.Where(x => x.MapAreaId == maparea.api_id)); foreach (var cell in this.MapInfos.Values) { cell.MapArea = this; } }
internal Master(kcsapi_start2 start2) { this.ShipTypes = new MasterTable<ShipType>(start2.api_mst_stype.Select(x => new ShipType(x))); this.Ships = new MasterTable<ShipInfo>(start2.api_mst_ship.Select(x => new ShipInfo(x))); this.SlotItemEquipTypes = new MasterTable<SlotItemEquipType>(start2.api_mst_slotitem_equiptype.Select(x => new SlotItemEquipType(x))); this.SlotItems = new MasterTable<SlotItemInfo>(start2.api_mst_slotitem.Select(x => new SlotItemInfo(x, this.SlotItemEquipTypes))); this.UseItems = new MasterTable<UseItemInfo>(start2.api_mst_useitem.Select(x => new UseItemInfo(x))); this.Missions = new MasterTable<Mission>(start2.api_mst_mission.Select(x => new Mission(x))); this.MapCells = new MasterTable<MapCell>(start2.api_mst_mapcell.Select(x => new MapCell(x))); this.MapInfos = new MasterTable<MapInfo>(start2.api_mst_mapinfo.Select(x => new MapInfo(x, this.MapCells))); this.MapAreas = new MasterTable<MapArea>(start2.api_mst_maparea.Select(x => new MapArea(x, this.MapInfos))); }
public JsonResult Getstatelist(string countryid) { MasterTable mastertable = new MasterTable(); var statelist = _ObjRepo.GetStateById(Convert.ToInt32(countryid)).ToList(); mastertable.statelist = statelist.Select(x => new SelectListItem { Text = x.Sts_Name.ToString(), Value = x.Sts_Id.ToString() }).ToList(); return(Json(mastertable.statelist, JsonRequestBehavior.AllowGet)); }
public MapInfo(kcsapi_mst_mapinfo mapinfo, MasterTable<MapArea> mapAreas) : base(mapinfo) { this.Id = mapinfo.api_id; this.Name = mapinfo.api_name; this.MapAreaId = mapinfo.api_maparea_id; this.MapArea = mapAreas[mapinfo.api_maparea_id] ?? MapArea.Dummy; this.IdInEachMapArea = mapinfo.api_no; this.Level = mapinfo.api_level; this.OperationName = mapinfo.api_opetext; this.OperationSummary = mapinfo.api_infotext; this.RequiredDefeatCount = mapinfo.api_required_defeat_count ?? 1; }
public IEnumerable masterView() { MasterTable mt = new MasterTable(); if (PXView.Filters != null && PXView.Filters.Length > 0) { PhoneCallerAudit pca = new PhoneCallerAudit(); for (int i = 0; i < PXView.Filters.Length; i++) { var fr = PXView.Filters[i]; if (fr.DataField == "PhoneNbr") { pca.PhoneNubmer = fr.Value.ToString(); mt.PhoneNbr = pca.PhoneNubmer; } if (fr.DataField == "CallerID") { pca.CallerID = fr.Value.ToString(); mt.CallerID = pca.CallerID; } } PXResultset <BAccount> resultset = PXSelectJoin <BAccount, InnerJoin <Contact, On <Contact.bAccountID, Equal <BAccount.bAccountID> > >, Where <Contact.phone1, Equal <Required <Contact.phone1> > > > .Select(this, pca.PhoneNubmer); if (resultset.Count > 0) { PXResult <BAccount, Contact> res = (PXResult <BAccount, Contact>)resultset[0]; Contact contact = res; BAccount bacct = res; pca.ContactID = contact.ContactID; if (bacct != null) { mt.AcctName = bacct.AcctName; } } if (savingRequired) { Audit.Insert(pca); //Caches[typeof(PhoneCallerAudit)].Persist(PXDBOperation.Insert); Save.Press(); savingRequired = false; } } List <MasterTable> result = new List <MasterTable>(); result.Add(mt); return(result); }
private void Btnsavemastergp_Click(object sender, EventArgs e) { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "accounts.sqlite"); var db = new SQLiteConnection(dpPath); db.CreateTable <MasterTable>(); MasterTable tbl = new MasterTable(); tbl.MasterName = txtmastergp.Text; db.Insert(tbl); Toast.MakeText(this, "Record Added Successfully...,", ToastLength.Short).Show(); txtmastergp.Text = ""; load_spiner_master(); }
private void CreateOrEditMasterTable(Game game, IStorage storage) { var db = CreateSQLLiteConnection.Create(MasterTableFile); db.CreateTable <MasterTable>(); MasterTable master = new MasterTable(); master.GameGuid = game.ID; master.Me = game.Me.ID; master.GameType = game.GameType; master.StorageType = storage.Type; db.Insert(master); storage.Accept(db); }
public ActionResult UpdatedMaster(EditViewModel _mastyer) { if (ModelState.IsValid) { MasterTable _objmaster = new MasterTable(); _objmaster.ContryId = Convert.ToInt16(Request.Form["_MasterTable.ContryId"]); _objmaster.StateId = Convert.ToInt16(Request.Form["_MasterTable.StateId"]); _objmaster.CityId = Convert.ToInt16(Request.Form["_MasterTable.CityId"]); _objmaster.Master_Email = (Request.Form["_MasterTable.Master_Email"]); _objmaster.Master_Name = Convert.ToString(Request.Form["_MasterTable.Master_Name"]); } return(RedirectToAction("EditMasterDatadetails/" + 2)); }
public MapInfo(kcsapi_mst_mapinfo mapinfo, MasterTable <MapCell> mapCells) : base(mapinfo) { this.Id = mapinfo.api_id; this.Name = mapinfo.api_name; this.MapAreaId = mapinfo.api_maparea_id; this.IdInEachMapArea = mapinfo.api_no; this.Level = mapinfo.api_level; this.OperationName = mapinfo.api_opetext; this.OperationSummary = mapinfo.api_infotext; this.RequiredDefeatCount = mapinfo.api_required_defeat_count ?? 1; this.MapCells = new MasterTable <MapCell>(mapCells.Values.Where(x => x.MapInfoId == mapinfo.api_id)); foreach (var cell in this.MapCells.Values) { cell.MapInfo = this; } }
internal void BindDataSourceSession() { if (HttpContext.Current == null || HttpContext.Current.Session == null) { return; } MasterTable.ClearDataSourceSession(); if (MasterTable.DataSource != null) { HttpContext.Current.Session[UniqueID + "_Datasourcedotnet"] = MasterTable.DataSource; } if (MasterTable.m_DataSourceColumns != null) { HttpContext.Current.Session[UniqueID + "_DataTableSettings"] = MasterTable.m_DataSourceColumns; } }
public List <MasterTable> GetMasterTableData() { dbConnector _dbconnection = new dbConnector(); SqlConnection con = _dbconnection.GetConnection; con.Open(); try { List <MasterTable> _mat = new List <MasterTable>(); if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand _cmd = new SqlCommand("select * from Usp_GetMasterData", con); _cmd.CommandType = CommandType.Text; SqlDataReader READER = _cmd.ExecuteReader(); while (READER.Read()) { MasterTable _mastertab = new MasterTable(); _mastertab.Master_Email = Convert.ToString(READER["Master_Email"]); _mastertab.PassWord = Convert.ToString(READER["PassWord"]); _mastertab.Master_Token = Convert.ToString(READER["Master_Token"]); _mastertab.Master_Name = Convert.ToString(READER["Master_Name"]); _mastertab.Id = Convert.ToInt32(READER["Id"]); _mat.Add(_mastertab); } return(_mat); } catch (Exception) { throw; } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } } }
public int InsertData(MasterTable _master) { dbConnector _dbconnector = new dbConnector(); SqlConnection con = _dbconnector.GetConnection; con.Open(); try { if (con.State != ConnectionState.Open) { con.Open(); } var _key = EncryptionLibrary.EncryptText(_master.PassWord); SqlCommand _commd = new SqlCommand("Usp_InsertMaster", con); _commd.CommandType = CommandType.StoredProcedure; _commd.Parameters.AddWithValue("@UserID", 1); _commd.Parameters.AddWithValue("@Master_Name", _master.Master_Name); _commd.Parameters.AddWithValue("@Master_Email", _master.Master_Email); _commd.Parameters.AddWithValue("@PassWord", _key); _commd.Parameters.AddWithValue("@ImageId", _master.ImageId); _commd.Parameters.AddWithValue("@ContryId", _master.ContryId); _commd.Parameters.AddWithValue("@StateId", _master.StateId); _commd.Parameters.AddWithValue("@CityId", _master.CityId); int _finalresult = _commd.ExecuteNonQuery(); // int _finalresult =Convert.ToInt32( _commd.ExecuteScalar()); return(_finalresult); } catch (Exception ex) { throw ex; } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } } }
public object BindModel(ControllerContext controllerContext, System.Web.Mvc.ModelBindingContext bindingContext) { HttpContextBase Objcontext = controllerContext.HttpContext; string Name = Objcontext.Request.Form["saveEmployee.EmpName"]; string Password = Objcontext.Request.Form["saveEmployee.Psw"]; string conPsw = Objcontext.Request.Form["saveEmployee.ConfirmPsw"]; int CntId = Convert.ToInt32(Objcontext.Request.Form["saveEmployee.Cnt_Id"]); int StsId = Convert.ToInt32(Objcontext.Request.Form["saveEmployee.Sts_Id"]); MasterTable ObjEmployee = new MasterTable() { //EmpName = Name, //Psw = Password, //ConfirmPsw = conPsw, //Cnt_Id = CntId, //Sts_Id = StsId }; return(ObjEmployee); }
public List <MasterTable> GetMasterById(int Id) { dbConnector _dbconnector = new dbConnector(); SqlConnection con = _dbconnector.GetConnection; con.Open(); MasterTable _master = new MasterTable(); try { if (con.State != ConnectionState.Open) { con.Open(); } List <MasterTable> _ListStates = new List <MasterTable>(); SqlCommand _commd = new SqlCommand("Usp_GetMasterDataBy_Id", con); _commd.CommandType = CommandType.StoredProcedure; _commd.Parameters.AddWithValue("@Id", Id); SqlDataReader _Reader = _commd.ExecuteReader(); while (_Reader.Read()) { _master.Id = Convert.ToInt32(_Reader["Id"]); _master.Master_Name = Convert.ToString(_Reader["Master_Name"]); _master.Master_Token = Convert.ToString(_Reader["Master_Token"]); _master.Master_Email = Convert.ToString(_Reader["Master_Email"]); _master.ContryId = Convert.ToInt32(_Reader["ContryId"]); _master.StateId = Convert.ToInt32(_Reader["StateId"]); _master.CityId = Convert.ToInt32(_Reader["CityId"]); _ListStates.Add(_master); } return(_ListStates); // return _master; } catch (Exception ex) { throw ex; } }
private void Btnupdatemastergp_Click(object sender, EventArgs e) { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "accounts.sqlite"); var db = new SQLiteConnection(dpPath); var item = new MasterTable(); item.Id = Convert.ToInt32(txtviewid.Text); item.MasterName = txtmastergp.Text; db.Update(item); Toast.MakeText(this, "Record Updated Successfully...,", ToastLength.Short).Show(); load_spiner_master(); }
/// <summary> /// Raises the <see cref="E:System.Web.UI.Control.PreRender"></see> event. /// </summary> /// <param name="e">An <see cref="T:System.EventArgs"></see> object that contains the event data.</param> protected override void OnPreRender(EventArgs e) { // Bubble effect if (Equals(m_EventRanpreRender, true)) { return; } if (Trace.IsTracing) { Trace.Trace("Start PreRender()"); } if (m_EventRanLoad == false) { if (Trace.IsTracing) { Trace.Trace("Running onLoad event from onPreRender event"); } OnLoad(new EventArgs()); } m_EventRanpreRender = true; if (MasterWebGrid != null && RequiredbyMasterWebGrid() == false) { return; } if (Trace.IsTracing) { Trace.Trace("base.OnPreRender({0})", ID); } if (m_IsRecordUpdateRows) { UpdateRowsClickEvent(); ReLoadData = true; } else if (m_UpdateRow != null && m_UpdateRow.Length > 0) { UpdateRowClickEvent(m_UpdateRow); if (m_ResetEditIndex) { InternalId = null; } ReLoadData = true; } base.OnPreRender(e); //BUG: Make SubmitGridOnEnter work without '???_wgupdaterecord' and '???_wgupdaterecords'. if (UseSubmitBehavior && !DesignMode) { switch (DisplayView) { case DisplayView.Detail: Attributes.Add("onkeydown", string.Format("return SubmitGridOnEnter(event,'{0}_wgupdaterecord');", ID)); break; default: Attributes.Add("onkeydown", string.Format("return SubmitGridOnEnter(event,'{0}_wgupdaterecords');", ID)); break; } } SetupGridRelations(); if (CacheGridStructure) { MasterTable.SaveDataStructure(); } if (ReLoadData) { //Clean-up if (InternalId != null && DisplayView == DisplayView.Grid) { InternalId = null; } if (Debug) { m_DebugString.AppendFormat("<b>ReloadingData ({0})</b> - DataSource: {1}<br/>", ID, DataSourceId); } MasterTable.GetData(true); if (SlaveGrid.Count > 0) { SlaveGrid.ForEach(delegate(Grid grid) { grid.ReLoadData = true; }); } } ViewState["LastGridMode"] = DisplayView; //Saving group state; GroupState = GroupState; if (Trace.IsTracing) { Trace.Trace("Start DisableShowRequiredIconIfThereIsNoRequiredFields({0});", ID); } // Disable DisplayRequiredColumn if there is no required fields in the table DisableShowRequiredIconIfThereIsNoRequiredFields(); if (Trace.IsTracing) { Trace.Trace("Finished DisableShowRequiredIconIfThereIsNoRequiredFields({0});", ID); } if (Trace.IsTracing) { Trace.Trace("Start errors.Render({0});", ID); } // SystemMessage.m_Panel = m_SystemMessagePanel; // If Data is not loaded yet.. do it before rendering errors.. if (m_MasterTable.m_GotData == false) { MasterTable.GetData(false); } if (IsDemo) { if (!Security.IsLocal && new Random().Next(1, 7) == 3) { SystemMessage.Add( "For full version register at <a href=\"http://www.webgrid.com\"><b>WebGrid Support Account</b></a>."); if (DisplayView == DisplayView.Detail && Page != null && Page.ClientScript != null) { const string alert = "alert('For full version register at www.webgrid.com');"; if (EnableCallBack && Anthem.Manager.IsCallBack) { Anthem.Manager.AddScriptForClientSideEval(alert); } else { Page.ClientScript.RegisterClientScriptBlock(GetType(), "AlertScript", alert, true); } } } } LoadLanguage(); SystemMessages.ForEach(delegate(SystemMessageItem key) { if (key is OverrideSystemMessage) { SetSystemMessage( ((OverrideSystemMessage)key).SystemMessageID.ToString(), key.DisplayText, key.CssClass); } }); // This should move in the future. //SetupGridFilterByColumns(); SetupGridMessages(); SetupGridScripts(); m_DesignRender.Render(); if (Trace.IsTracing) { Trace.Trace("Finished errors.Render({0});", ID); } UpdateDebug(); // bool AllRows = (System.Web.HttpContext.Current.RequestQueryString("AllRows"] != null && System.Web.HttpContext.Current.RequestQueryString("AllRows") == "1"); if (m_DoExcelExport) { Excel.StreamToBrowser(Page, MasterTable, ExportFileName, Excel.ExcelFile(MasterTable, true)); } BindDataSourceSession(); if (Trace.IsTracing) { Trace.Trace("Finish PreRender. Rows Rendered: {0}", MasterTable.Rows.Count); } }
public JsonResult CreateCustomer([Bind(Exclude = "CustomerID")] MasterTable customers) { return(Json("")); }
internal SlotItemInfo(kcsapi_mst_slotitem rawData, MasterTable <SlotItemEquipType> types) : base(rawData) { this.EquipType = types[rawData.api_type?[2] ?? 0] ?? SlotItemEquipType.Dummy; }
// 概要: // コンストラクタ public ImprovementArsenalInfoViewModel(MasterTable <SlotItemInfo> slotItems) { this.slotItems = slotItems; }
public LexicalComponent BuildComponent() { LexicalComponent component = null; _lexeme = ""; var currentState = 0; var continueAnalysis = true; while (continueAnalysis) { #region State 0 if (currentState == 0) { ReadNextCharacter(); IgnoreWhitespaces(); if (CurrentCharacterIsDigit()) { currentState = 57; Concatenate(); } else if (CurrentCharacterIsEqual()) { currentState = 22; Concatenate(); } else if (CurrentCharacterIsGreaterThan()) { currentState = 39; Concatenate(); } else if (CurrentCharacterIsLessThan()) { currentState = 44; Concatenate(); } else if (CurrentCharacterIsExclamationMark()) { currentState = 48; Concatenate(); } else if (_currentCharacter.ToLower() == "s") { currentState = 1; Concatenate(); } else if (_currentCharacter.ToLower() == "c") { currentState = 7; Concatenate(); } else if (_currentCharacter.ToLower() == "f") { currentState = 12; Concatenate(); } else if (_currentCharacter.ToLower() == "t") { currentState = 16; Concatenate(); } else if (_currentCharacter.ToLower() == "w") { currentState = 24; Concatenate(); } else if (CurrentCharacterIsSinglequote()) { currentState = 30; Concatenate(); } else if (_currentCharacter.ToLower() == "a") { currentState = 33; Concatenate(); } else if (_currentCharacter.ToLower() == "d") { currentState = 40; Concatenate(); } else if (_currentCharacter.ToLower() == "o") { currentState = 45; Concatenate(); } else if (CurrentCharacterIsComma()) { currentState = 84; Concatenate(); } else if (CurrentCharacterIsEndOfLine()) { currentState = 38; Concatenate(); } else if (CurrentCharacterIsEndOfFile()) { currentState = 32; } else { currentState = 71; } } #endregion #region State 1 else if (currentState == 1) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "e") { currentState = 2; Concatenate(); } else { currentState = 72; } } #endregion #region State 2 else if (currentState == 2) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "l") { currentState = 3; Concatenate(); } else { currentState = 72; } } #endregion #region State 3 else if (currentState == 3) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "e") { currentState = 4; Concatenate(); } else { currentState = 72; } } #endregion #region State 4 else if (currentState == 4) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "c") { currentState = 5; Concatenate(); } else { currentState = 72; } } #endregion #region State 5 else if (currentState == 5) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "t") { currentState = 6; Concatenate(); } else { currentState = 72; } } #endregion #region State 6 - Return SELECT else if (currentState == 6) { component = LexicalComponent.CreateSymbol(Category.Select, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 7 else if (currentState == 7) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "a") { currentState = 8; Concatenate(); } else { currentState = 81; } } #endregion #region State 8 else if (currentState == 8) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "m") { currentState = 9; Concatenate(); } else { currentState = 81; } } #endregion #region State 9 else if (currentState == 9) { ReadNextCharacter(); if (CurrentCharacterIsUnderscore()) { currentState = 10; Concatenate(); } else { currentState = 81; } } #endregion #region State 10 else if (currentState == 10) { ReadNextCharacter(); if (CurrentCharacterIsLetterOrDigit() || CurrentCharacterIsUnderscore()) { currentState = 10; Concatenate(); } else { currentState = 11; } } #endregion #region State 11 - Return Field else if (currentState == 11) { MovePointerBackward(); component = LexicalComponent.CreateSymbol(Category.Field, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 12 else if (currentState == 12) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "r") { currentState = 13; Concatenate(); } else { currentState = 73; } } #endregion #region State 13 else if (currentState == 13) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "o") { currentState = 14; Concatenate(); } else { currentState = 73; } } #endregion #region State 14 else if (currentState == 14) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "m") { currentState = 15; Concatenate(); } else { currentState = 73; } } #endregion #region State 15 - Return From else if (currentState == 15) { component = LexicalComponent.CreateSymbol(Category.From, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 16 else if (currentState == 16) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "a") { currentState = 17; Concatenate(); } else { currentState = 80; } } #endregion #region State 17 else if (currentState == 17) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "b") { currentState = 18; Concatenate(); } else { currentState = 80; } } #endregion #region State 18 else if (currentState == 18) { ReadNextCharacter(); if (CurrentCharacterIsUnderscore()) { currentState = 19; Concatenate(); } else { currentState = 80; } } #endregion #region State 19 else if (currentState == 19) { ReadNextCharacter(); if (CurrentCharacterIsLetterOrDigit() || CurrentCharacterIsUnderscore()) { currentState = 19; Concatenate(); } else { currentState = 20; } } #endregion #region State 20 - Return Table else if (currentState == 20) { MovePointerBackward(); component = LexicalComponent.CreateSymbol(Category.Table, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 22 - Return Equal to else if (currentState == 22) { component = LexicalComponent.CreateSymbol(Category.EqualTo, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 24 else if (currentState == 24) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "h") { currentState = 25; Concatenate(); } else { currentState = 74; } } #endregion #region State 25 else if (currentState == 25) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "e") { currentState = 26; Concatenate(); } else { currentState = 74; } } #endregion #region State 26 else if (currentState == 26) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "r") { currentState = 27; Concatenate(); } else { currentState = 74; } } #endregion #region State 27 else if (currentState == 27) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "e") { currentState = 28; Concatenate(); } else { currentState = 74; } } #endregion #region State 28 - Return Where else if (currentState == 28) { component = LexicalComponent.CreateSymbol(Category.Where, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 30 else if (currentState == 30) { ReadNextCharacter(); if (CurrentCharacterIsSinglequote()) { currentState = 31; Concatenate(); } else if (!CurrentCharacterIsEndOfFile() || !CurrentCharacterIsEndOfLine()) { currentState = 30; Concatenate(); } else if (CurrentCharacterIsEndOfLine()) { currentState = 69; } else { currentState = 70; } } #endregion #region State 31 - Return Literal else if (currentState == 31) { component = LexicalComponent.CreateSymbol(Category.Literal, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 32 - Return End of File else if (currentState == 32) { component = LexicalComponent.CreateSymbol(Category.EndOfFile, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 33 else if (currentState == 33) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "n") { currentState = 34; Concatenate(); } else if (_currentCharacter.ToLower() == "s") { currentState = 35; Concatenate(); } else { currentState = 75; } } #endregion #region State 34 else if (currentState == 34) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "d") { currentState = 37; Concatenate(); } else { currentState = 75; } } #endregion #region State 35 else if (currentState == 35) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "c") { currentState = 36; Concatenate(); } else { currentState = 76; } } #endregion #region State 36 - Return ASC else if (currentState == 36) { component = LexicalComponent.CreateSymbol(Category.Asc, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 37 - Return AND else if (currentState == 37) { component = LexicalComponent.CreateSymbol(Category.And, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 38 else if (currentState == 38) { LoadNewLine(); currentState = 0; } #endregion #region State 39 else if (currentState == 39) { ReadNextCharacter(); if (CurrentCharacterIsEqual()) { currentState = 63; Concatenate(); } else { currentState = 64; } } #endregion #region State 40 else if (currentState == 40) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "e") { currentState = 41; Concatenate(); } else { currentState = 77; } } #endregion #region State 41 else if (currentState == 41) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "s") { currentState = 42; Concatenate(); } else { currentState = 77; } } #endregion #region State 42 else if (currentState == 42) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "c") { currentState = 43; Concatenate(); } else { currentState = 77; } } #endregion #region State 43 - Return DESC else if (currentState == 43) { component = LexicalComponent.CreateSymbol(Category.Desc, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 44 else if (currentState == 44) { ReadNextCharacter(); if (CurrentCharacterIsGreaterThan()) { currentState = 60; Concatenate(); } else if (CurrentCharacterIsEqual()) { currentState = 61; Concatenate(); } else { currentState = 62; } } #endregion #region State 45 else if (currentState == 45) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "r") { currentState = 46; Concatenate(); } else { currentState = 78; } } #endregion #region State 46 else if (currentState == 46) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "d") { currentState = 49; Concatenate(); } else { currentState = 47; } } #endregion #region State 47 - Return OR else if (currentState == 47) { MovePointerBackward(); component = LexicalComponent.CreateSymbol(Category.Or, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } #endregion #region State 48 else if (currentState == 48) { ReadNextCharacter(); if (CurrentCharacterIsEqual()) { currentState = 65; Concatenate(); } else { currentState = 82; } } #endregion #region State 49 else if (currentState == 49) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "e") { currentState = 50; Concatenate(); } else { currentState = 79; } } #endregion #region State 50 else if (currentState == 50) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "r") { currentState = 51; Concatenate(); } else { currentState = 79; } } #endregion #region State 51 else if (currentState == 51) { ReadNextCharacter(); if (_currentCharacter == " ") { currentState = 52; Concatenate(); } else { currentState = 79; } } #endregion #region State 52 else if (currentState == 52) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "b") { currentState = 53; Concatenate(); } else { currentState = 79; } } #endregion #region State 53 else if (currentState == 53) { ReadNextCharacter(); if (_currentCharacter.ToLower() == "y") { currentState = 54; Concatenate(); } else { currentState = 79; } } #endregion else if (currentState == 54) { component = LexicalComponent.CreateSymbol(Category.Order_by, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 57) { ReadNextCharacter(); if (CurrentCharacterIsDigit()) { currentState = 57; Concatenate(); } else if (_currentCharacter == ".") { currentState = 66; Concatenate(); } else { currentState = 58; } } else if (currentState == 58) { component = LexicalComponent.CreateSymbol(Category.Integer, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 60) { component = LexicalComponent.CreateSymbol(Category.DifferentThan, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 61) { component = LexicalComponent.CreateSymbol(Category.LessThanOrEqualTo, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 62) { MovePointerBackward(); component = LexicalComponent.CreateSymbol(Category.LessThan, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 63) { component = LexicalComponent.CreateSymbol(Category.GreaterThanOrEqualTo, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 64) { MovePointerBackward(); component = LexicalComponent.CreateSymbol(Category.GreaterThan, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 65) { component = LexicalComponent.CreateSymbol(Category.DifferentThan, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 66) { ReadNextCharacter(); if (CurrentCharacterIsDigit()) { currentState = 67; Concatenate(); } else { currentState = 83; } } else if (currentState == 67) { ReadNextCharacter(); if (CurrentCharacterIsDigit()) { currentState = 67; Concatenate(); } else { currentState = 68; } } else if (currentState == 68) { MovePointerBackward(); component = LexicalComponent.CreateSymbol(Category.Decimal, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 69) { LoadNewLine(); currentState = 0; } else if (currentState == 70) { component = LexicalComponent.CreateSymbol(Category.EndOfFile, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else if (currentState == 72) { component = LexicalComponent.CreateDummy(Category.Select, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid Select", "Invalid Select ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 73) { component = LexicalComponent.CreateDummy(Category.From, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid From", "Invalid From ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 74) { component = LexicalComponent.CreateDummy(Category.Where, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid Where", "Invalid Where ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 75) { var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Error lexical", "Invalid symbol entered ", "Make sure the symbols entered are valid"); ErrorHandler.ErrorHandler.Report(error); throw new Exception("Se ha presentado un error léxico que tiene el proceso, por favor validar la consola de errores"); } else if (currentState == 76) { component = LexicalComponent.CreateDummy(Category.Asc, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid Asc", "Invalid Asc ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 77) { component = LexicalComponent.CreateDummy(Category.Desc, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid Desc", "Invalid Desc ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 78) { var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Error lexical", "Invalid symbol entered ", "Make sure the symbols entered are valid"); ErrorHandler.ErrorHandler.Report(error); throw new Exception("Se ha presentado un error léxico que tiene el proceso, por favor validar la consola de errores"); } else if (currentState == 79) { component = LexicalComponent.CreateDummy(Category.Order_by, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid ORDER BY", "Invalid ORDER BY ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 80) { component = LexicalComponent.CreateDummy(Category.Table, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid table", "Invalid table ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 81) { component = LexicalComponent.CreateDummy(Category.Field, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid field", "Invalid field ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 82) { component = LexicalComponent.CreateDummy(Category.DifferentThan, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid diferent than", "Invalid different than ", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 83) { component = LexicalComponent.CreateDummy(Category.Decimal, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); var error = Error.CreateLexicalError( _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1, "Invalid decimal", "Invalid decimal number", "Use a dot"); MasterTable.Add(component); ErrorHandler.ErrorHandler.Report(error); continueAnalysis = false; } else if (currentState == 84) { component = LexicalComponent.CreateSymbol(Category.Separator, _lexeme, _currentLineNumber, _pointer - _lexeme.Length, _pointer - 1); MasterTable.Add(component); continueAnalysis = false; } else { throw new Exception("Programa invalido"); } } return(component); }