/// <summary>
/// Ritorna Xml con dati oggetti. E' possibile specificare un delegato per poter manipolare
/// l'xml di ogni oggetto con altri dati. Utilizzando rewriteAll viene soppresso l'output Xml standard
/// dell'oggetto
/// </summary>
/// <param name="function">
/// Delegato ad una funzione (e.s. AggiornaXmlUtente(Utente ut, Xmlwrite xw)) per la manipolazione dell'xml
/// </param>
/// <param name="rewriteAll">
/// Impostato a true disabilita l'output xml standard dell'oggetto
/// </param>
/// <param name="args">
/// Dati esterni da inviare alla funzione di scrittura xml
/// </param>
/// <returns></returns>
public string ToXml(XmlFunction function, bool rewriteAll, params object[] args)
{
DataObjectBase o;
using (XmlWrite xw = new XmlWrite())
{
for (int i = 0; i < this.Count; i++)
{
o = this[i];
xw.WriteStartElement(o.mClassSchema.ClassName);
try
{
if (!rewriteAll)
{
xw.WriteRaw(o.ToXml());
}
//Se fornita funzione allora la richiama
if (function != null)
{
function((T)o, xw, args);
}
}
finally
{
xw.WriteEndElement();
}
}
return(xw.ToString());
}
}
internal XDocument ExecuteRequest(XmlFunction function, Parameters.Parameters parameters)
{
var url = new PrtgUrl(prtgClient.Server, prtgClient.UserName, prtgClient.PassHash, function, parameters);
var response = ExecuteRequest(url);
return(XDocument.Parse(XDocumentHelpers.SanitizeXml(response)));
}
internal async Task <XDocument> ExecuteRequestAsync(XmlFunction function, Parameters.Parameters parameters)
{
var url = new PrtgUrl(prtgClient.Server, prtgClient.UserName, prtgClient.PassHash, function, parameters);
var response = await ExecuteRequestAsync(url).ConfigureAwait(false);
return(XDocument.Parse(XDocumentHelpers.SanitizeXml(response)));
}
internal XDocument ExecuteRequest(XmlFunction function, Parameters.Parameters parameters, Action <string> responseValidator = null)
{
var url = GetPrtgUrl(function, parameters);
var response = ExecuteRequest(url);
responseValidator?.Invoke(response);
return(XDocumentHelpers.SanitizeXml(response));
}
internal async Task <XDocument> ExecuteRequestAsync(XmlFunction function, Parameters.Parameters parameters, Action <string> responseValidator = null)
{
var url = GetPrtgUrl(function, parameters);
var response = await ExecuteRequestAsync(url).ConfigureAwait(false);
responseValidator?.Invoke(response);
return(XDocumentHelpers.SanitizeXml(response));
}
/// <summary>
/// Validation Text Changed Method
/// </summary>
/// <param name="sender">Pass the object of sender</param>
/// <param name="e">Pass the parameter of e</param>
private void txtUsername_TextChanged(object sender, EventArgs e)
{
if (!txtUsername.Text.Contains(Constant.Common.SPECIAL_CHARACTER_AT_THE_RATE) || !txtUsername.Text.Contains(Constant.Common.DOT_COM))
{
errorProvider1.SetError(txtUsername, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_9));
}
else
{
errorProvider1.SetError(txtUsername, string.Empty);
}
}
/// <summary>
///
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public static string GetUserNameById(int Id)
{
string lstrFullName = string.Empty;
string istrPath = Path.Combine(Application.StartupPath, Constant.Common.XML);
string str = XmlFunction.GetQueriesById(istrPath, Constant.Common.ENTITY_NAME, Constant.Query.GET_USER_INFO_BY_ID);
str = String.Format(str, Id);
DataTable dataTable = DBFunction.FetchDataFromDatabase(Constant.Common.DATABASE_NAME, str);
if (dataTable != null && dataTable.Rows.Count > 0)
{
lstrFullName = Convert.ToString(dataTable.Rows[0][TableEnum.enmLogin_Info.USERNAME.ToString()]);
}
return(lstrFullName);
}
public void RunXmlToCodeTest(string id)
{
string xml = GetXml(id);
XmlDocument document = new XmlDocument();
document.LoadXml(xml);
XmlFunction function = new XmlFunction();
function.ConstructFromXml(document.GetFirstChild("function"), document);
string generatedCode = SerializeToCode(function);
string expectedCode = GetExpectedResult(id);
Assert.AreEqual(expectedCode, generatedCode);
}
/// <summary>
/// Scrive Xml con possibilita' di integrazione dati attraverso la specifica di una funzione
/// di manipolazione
/// </summary>
/// <param name="function"></param>
/// <param name="rewriteAll">
/// Se true allora non emette l'Xml standard dell'oggetto
/// </param>
/// <param name="args"></param>
/// <returns></returns>
public string ToXml(XmlFunction function, bool rewriteAll, params object[] args)
{
using (XmlWrite xw = new XmlWrite())
{
//Se deve riscrivere
if (!rewriteAll)
{
xw.WriteRaw(this.ToXml(1));
}
//Se fornita funzione allora la richiama
if (function != null)
{
function((T)this, xw, args);
}
return(xw.ToString());
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUser.Text == string.Empty)
{
errorProvider1.SetError(txtUser, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_2));
}
if (txtpassword.Text == string.Empty)
{
errorProvider1.SetError(txtpassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_3));
}
if (txtUser.Text != string.Empty && txtpassword.Text != string.Empty)
{
errorProvider1.Clear();
string str = XmlFunction.GetQueriesById(istrPath, Constant.Common.ENTITY_NAME, Constant.Query.GET_USER_INFO);
str = String.Format(str, txtUser.Text, txtpassword.Text);
string result = DBFunction.FetchScalarFromDatabase(Constant.Common.DATABASE_NAME, str);
if (result != string.Empty && Convert.ToInt32(result) > 0)
{
Login.UserId = Convert.ToInt32(result);
if (checkBoxRemember.Checked)
{
str = XmlFunction.GetQueriesById(istrPath, Constant.Common.ENTITY_NAME, Constant.Query.UPDATE_REMEMBER_ME_CODE_VALUE);
str = String.Format(str, Login.UserId);
DBFunction.UpdateTable(Constant.Common.DATABASE_NAME, str);
}
this.Hide();
ExpensesMain form1 = new ExpensesMain();
form1.Show();
}
else
{
MessageBox.Show(XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_1));
}
}
}
static void Main()
{
try
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new Login());
//string istrPath = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName + Constant.Common.XML;
string istrPath = Path.Combine(Application.StartupPath, Constant.Common.XML);
string str = XmlFunction.GetQueriesById(istrPath, Constant.Common.ENTITY_NAME, Constant.Query.GET_UPDATE_REMEMBER_CODE_VALUE);
DataTable dataTable = DBFunction.FetchDataFromDatabase(Constant.Common.DATABASE_NAME, str);
if (dataTable != null && dataTable.Rows.Count > 0)
{
if (Convert.ToString(dataTable.Rows[0][TableEnum.enmCode_Value.DATA1.ToString()]) == string.Empty)
{
Application.Run(new Login());
}
else
{
Login.UserId = Convert.ToInt32(dataTable.Rows[0][TableEnum.enmCode_Value.DATA1.ToString()]);
Application.Run(new ExpensesMain());
}
}
else
{
Application.Run(new ShowIds());
}
}
catch (Exception ex)
{
Error.Exception_Msg = ex.Message;
Error.Source = ex.Source;
Error.Stack_Trace = ex.StackTrace;
Application.Run(new Error());
}
}
//public FunctionApply(string jointable, string joincolumn, string basetable, string basecolumn)
// : this(ApplyType.CROSS, jointable, joincolumn, basetable, basecolumn) { }
//public FunctionApply(ApplyType applytype, string jointable, string joincolumn, string basetable, string basecolumn)
//{
// _applystring = string.Format("{0} JOIN {1} ON [{1}].[{2}] = [{3}].[{4}]"
// , getApplyType(applytype)
// , jointable
// , joincolumn
// , basetable
// , basecolumn
// );
//}
//public FunctionApply(string joinname, string jointable, string joincolumn, string basetable, string basecolumn)
// : this(ApplyType.CROSS, joinname, jointable, joincolumn, basetable, basecolumn) { }
public FunctionApply(ApplyType applyType, string applynameTable, string applynameColumn, XmlFunction xmlFunction, string xmlXPath, string xmlColumn)
{
_applystring = string.Format("{0} APPLY {1}.{2}('{3}') as {4}({5})"
, getApplyType(applyType)
, xmlColumn
, xmlFunction
, xmlXPath
, applynameTable
, applynameColumn
);
}
public PrtgUrl(ConnectionDetails connectionDetails, XmlFunction function, IParameters parameters) :
this(connectionDetails, GetResourcePath(function), parameters)
{
}
public XmlFunctionParameters(XmlFunction function)
{
Function = function;
}
/// <summary>
///
/// </summary>
/// <param name="astrMessage"></param>
/// <returns></returns>
public static string GetQueryById(string astrMessage)
{
string istrPath = Path.Combine(Application.StartupPath, Constant.Common.XML);
return(XmlFunction.GetQueriesById(istrPath, Constant.Common.ENTITY_NAME, astrMessage));
}
internal PrtgRequestMessage(ConnectionDetails connectionDetails, XmlFunction function, IParameters parameters) :
this(connectionDetails, GetResourcePath(function), parameters)
{
}
private void btnRegister_Click(object sender, EventArgs e)
{
Dictionary <string, string> ldict = new Dictionary <string, string>();
if (txtUsername.Text == string.Empty)
{
errorProvider1.SetError(txtPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_2));
}
else
{
ldict.Add(TableEnum.enmLogin_Info.USERNAME.ToString(), txtUsername.Text);
}
if (txtPassword.Text == string.Empty)
{
errorProvider1.SetError(txtPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_3));
}
if (txtConfirmPassword.Text == string.Empty)
{
errorProvider1.SetError(txtConfirmPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_4));
}
else if (txtPassword.Text != txtConfirmPassword.Text)
{
errorProvider1.SetError(txtPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_5));
errorProvider1.SetError(txtConfirmPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_5));
}
else
{
ldict.Add(TableEnum.enmLogin_Info.PASSWORD.ToString(), txtPassword.Text);
}
if (txtFirstname.Text == string.Empty)
{
errorProvider1.SetError(txtPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_6));
}
else
{
ldict.Add(TableEnum.enmLogin_Info.FIRST_NAME.ToString(), txtFirstname.Text);
}
if (txtlastname.Text == string.Empty)
{
errorProvider1.SetError(txtPassword, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_7));
}
else
{
ldict.Add(TableEnum.enmLogin_Info.LAST_NAME.ToString(), txtlastname.Text);
}
if (!radioMale.Checked && !radioFemale.Checked)
{
errorProvider1.SetError(radioFemale, XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Error.ERROR_8));
}
else
{
string str = radioMale.Checked ? Constant.Common.Gender.MALE : radioFemale.Checked ? Constant.Common.Gender.FEMALE : string.Empty;
ldict.Add(TableEnum.enmLogin_Info.GENDER.ToString(), str);
}
int Id = DBFunction.InsertIntoTable(Constant.Common.DATABASE_NAME, TableEnum.enmTableName.LOGIN_INFO.ToString(), ldict);
if (Id > 0)
{
InsertIntoAssetHeader(Id);
MessageBox.Show(XmlFunction.GetMessageById(istrPath, Constant.Common.ENTITY_NAME, Constant.Message.REGISTRATION_SUCCESSFULY));
}
}
private PrtgUrl GetPrtgUrl(XmlFunction function, IParameters parameters) => new PrtgUrl(prtgClient.connectionDetails, function, parameters);
public PrtgUrl(string server, string username, string passhash, XmlFunction function, Parameters.Parameters parameters) :
this(server, username, passhash, GetResourcePath(function), parameters)
{
}
