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