void tb_TextChanged(object sender, EventArgs e)
{
try
{
TextBox tb = ((TextBox)sender);
bool iscomming = true;
if (tb.ID.Substring(tb.ID.IndexOf("_") + 1, 2).Equals("go"))
{
iscomming = false;
}
string date = tb.ID.Substring(tb.ID.LastIndexOf("_") + 1);
string ntime = tb.Text;
DateTime settime = Convert.ToDateTime(date + " " + ntime);
if (!settime.ToLongTimeString().Equals("00:00:00"))
{
//Label2.Text = iscomming+ " | "+settime.ToString()+" | "+tb.ID;
List <ParameterObj> paramlist = new List <ParameterObj>();
ParameterObj timeObj = new ParameterObj();
timeObj.name = "@Time";
timeObj.type = SqlDbType.DateTime;
timeObj.value = settime;
paramlist.Add(timeObj);
string insertquery = "Insert into T_Time(KontoID,Time,iscomming)values('" + _user.TimeKontoID + "',@Time,'" + iscomming + "')";
_dbconn.Execute(insertquery, paramlist);
}
}
catch (Exception exp)
{
Label2.Text = exp.Message;
}
}
private void btnadd_Click(object sender, EventArgs e)
{
ParameterObj timeObj = new ParameterObj();
timeObj.name = "@Timer";
timeObj.type = SqlDbType.DateTime;
timeObj.value = DateTime.Now;
List <ParameterObj> paramlist = new List <ParameterObj>();
paramlist.Add(timeObj);
if (tbpay.Text != "0.00" && tbpay.Text != "0,00")
{
try
{
string topayquery = "Insert into T_ToPay(pay,Time,userid)values('" + tbpay.Text.Replace(",", ".") + "',@Timer,'" + _userid + "')";
_dbconn.Execute(topayquery, paramlist);
this.FillDGV();
tbpay.Text = "0.00";
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
}
private void btnpay_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(tbpay.Text) && tbpay.Text != "0.00")
{
string tbtext = tbpay.Text;
string opentext = labopenSum.Text;
tbtext = tbtext.Replace(".", ",");
opentext = opentext.Replace(".", ",");
decimal zahlt = Convert.ToDecimal(tbtext);
decimal open = Convert.ToDecimal(opentext);
decimal rest = 0;
decimal defaultLimit = 0;
string userquery = "Select rest, BetragsLimit from T_User where UserID='" + tbuserid.Text + "'";
SqlDataReader sqldr = _dbconn.GetResult(userquery, null);
while (sqldr.Read())
{
string strrest = sqldr.GetValue(0).ToString().Replace(".", ",");
rest = Convert.ToDecimal(strrest);
string stBetragsLimit = sqldr.GetValue(1).ToString().Replace(".", ",");
defaultLimit = Convert.ToDecimal(stBetragsLimit);
}
sqldr.Close();
//tssInfoONE.Text = "Pay: " + zahlt + " Open: " + open;
rest = rest - zahlt;
string updateRest = "Update T_User set rest='" + rest.ToString().Replace(",", ".") + "' where UserID='" + tbuserid.Text + "'";
//this.WriteInfo(restupdate);
_dbconn.Execute(updateRest, null);
ParameterObj timeObj = new ParameterObj();
timeObj.name = "@Timer";
timeObj.type = SqlDbType.DateTime;
timeObj.value = DateTime.Now;
List <ParameterObj> paramlist = new List <ParameterObj>();
paramlist.Add(timeObj);
string topayquery = "Insert into T_ToPay(pay,Time,userid)values('" + tbtext.Replace(",", ".") + "',@Timer,'" + tbuserid.Text + "')";
_dbconn.Execute(topayquery, paramlist);
this.toolStripMenuItemClear_Click(null, null);
TreeNode node = tvuser.SelectedNode;
this.ShowUserDetails(node);
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
//this.WriteLog(exp.Message);
}
}
private string CheckUser(string username, string password)
{
if (username.Equals("Testuser"))
{
return("-999");
}
string userid = null;
string userpass = null;
string logname = null;
List <ParameterObj> paramlist = new List <ParameterObj>();
ParameterObj paramuser = new ParameterObj();
paramuser.name = "@user";
paramuser.type = System.Data.SqlDbType.NVarChar;
paramuser.value = username;
paramlist.Add(paramuser);
string query = "Select UserID,Password,LoginName from T_User where UserName=@user or LoginName=@user";
if (!string.IsNullOrEmpty(password))
{
ParameterObj parampass = new ParameterObj();
parampass.name = "@pass";
parampass.type = System.Data.SqlDbType.NVarChar;
parampass.value = _crypt.EncryptMessage(password, "snack30xx");
paramlist.Add(parampass);
query = "Select UserID,Password,LoginName from T_User where (UserName=@user or LoginName=@user) and Password=@pass";
}
System.Data.SqlClient.SqlDataReader dr = _dbconn.GetResult(query, paramlist);
while (dr.Read())
{
userid = dr.GetValue(0).ToString();
userpass = dr.GetValue(1).ToString();
logname = dr.GetValue(2).ToString();
}
dr.Close();
if (string.IsNullOrEmpty(password) && (!string.IsNullOrEmpty(logname) || !string.IsNullOrEmpty(username)))
{
return("-1");
}
if (!string.IsNullOrEmpty(userid))
{
return(userid);
}
//labinfo.Text = crypt.EncryptMessage(password, "snack30xx");
//labinfo.Text += " | " + crypt.DecryptMessage(labinfo.Text, "snack30xx");
return("-1");
}
private List <ParameterObj> GetSearchParam(string year, string month, string day)
{
List <ParameterObj> paramlist = new List <ParameterObj>();
DateTime sstdate = new DateTime();
DateTime sendate = new DateTime();
sstdate = new DateTime(DateTime.Now.Year, 1, 1);
sendate = new DateTime(DateTime.Now.Year, 12, 31);
if (!year.Equals("0"))
{
sstdate = new DateTime(Convert.ToInt32(year), sstdate.Month, sstdate.Day);
sendate = new DateTime(Convert.ToInt32(year), sendate.Month, sendate.Day);
}
if (!month.Equals("0"))
{
sstdate = new DateTime(sstdate.Year, Convert.ToInt32(month), sstdate.Day);
sendate = new DateTime(sendate.Year, Convert.ToInt32(month), DateTime.DaysInMonth(sendate.Year, Convert.ToInt32(month)), 23, 59, 59);
}
if (!day.Equals("0"))
{
sstdate = new DateTime(sstdate.Year, sstdate.Month, Convert.ToInt32(day));
sendate = new DateTime(sendate.Year, sendate.Month, Convert.ToInt32(day) + 1);
}
/*
* if (year.Equals("0") && month.Equals("0") && day.Equals("0"))
* {
* sstdate = new DateTime(DateTime.Now.Year, 1, 1);
* sendate = new DateTime(DateTime.Now.Year, 12, 31);
* }*/
ParameterObj p1 = new ParameterObj();
p1.name = "@StartDate";
p1.type = SqlDbType.DateTime;
p1.value = sstdate.ToString();
ParameterObj p2 = new ParameterObj();
p2.name = "@EndDate";
p2.type = SqlDbType.DateTime;
p2.value = sendate.ToString();
paramlist.Add(p1);
paramlist.Add(p2);
return(paramlist);
}
public void ShowView(ParameterObj p_ParameterObj)
{
switch (p_ParameterObj.MethodName)
{
case "到店消费":
{
ShowView("收银");
frmCashier frmcashier = m_CurrentView as frmCashier;
BookingObjDetail detail = p_ParameterObj.Parameter[0] as BookingObjDetail;
frmcashier.SetBookingObjDetail(detail);
break;
}
}
}
/// <summary>
/// Save edit and new Right
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripMenuItem3_Click(object sender, EventArgs e)
{
try
{
ParameterObj param1 = new ParameterObj();
param1.name = "@Name";
param1.type = SqlDbType.NVarChar;
param1.value = tbname.Text;
ParameterObj param2 = new ParameterObj();
param2.name = "@Mail";
param2.type = SqlDbType.NVarChar;
param2.value = tbmail.Text;
List <ParameterObj> paramlist = new List <ParameterObj>();
paramlist.Add(param1);
paramlist.Add(param2);
if (!string.IsNullOrEmpty(tbid.Text))//Edit
{
if (!string.IsNullOrEmpty(tbname.Text))
{
string updatequery = "Update T_UserRights set UserRight=@Name,"
+ "GlobalMail='" + cbisglobalmail.Checked + "',"
+ "EMail=@Mail,"
+ "AllowPosten='" + cballowposten.Checked + "',"
+ "AllowTime='" + cballowtime.Checked + "',"
+ "AllowConfig='" + cballowconfig.Checked + "',"
+ "AllowAdministration='" + cballowadmin.Checked + "'"
+ " where UserRightID='" + tbid.Text + "'";
int result = _dbconn.Execute(updatequery, paramlist);
if (result > 0)
{
_form.SettssinfoONE("Save Right correct...");
}
this.toolStripMenuItem1_Click(sender, e);
this.FillTreeView();
}
else
{
_form.SettssinfoONE("Please set all informations...");
}
}
else//new right
{
#region newright
if (!string.IsNullOrEmpty(tbname.Text)) //has name
{
if (tVUserRights.Nodes.Find(tbname.Text, false).GetLength(0) <= 0) //if other right
{
string insertquery = "Insert into T_UserRights(UserRightID,UserRight,GlobalMail,EMail,AllowPosten,AllowTime,AllowConfig,AllowAdministration)values("
+ "'" + Guid.NewGuid() + "',@Name,"
+ "'" + cbisglobalmail.Checked + "',@Mail,"
+ "'" + cballowposten.Checked + "',"
+ "'" + cballowtime.Checked + "',"
+ "'" + cballowconfig.Checked + "',"
+ "'" + cballowadmin.Checked + "')";
int result = _dbconn.Execute(insertquery, paramlist);
if (result > 0)
{
_form.SettssinfoONE("Save new Right correct...");
}
this.toolStripMenuItem1_Click(sender, e);
this.FillTreeView();
}
else
{
_form.SettssinfoONE("UserRight exists...");
}
}
else
{
_form.SettssinfoONE("Please set all informations...");
}
#endregion
}
}
catch (Exception exp)
{
_form.SettssinfoONE("Exception: " + exp.Message);
}
}
private void WriteInfotoDB(string text)
{
try
{
text = this.InsertParameterCheck(text);
string userid = string.Empty;
string codeid = string.Empty;
string username = string.Empty;
decimal preis = 0;
bool issnackcode = true;
string kontoid = string.Empty;
bool inhouse = false;
DateTime upddate = DateTime.Now;
string query = "Select UserID,UserName,CodeID,Preis,IsSnackCode,KontoID,InHouse,UpdateTime from VW_UserCodes where UserCode='" + text + "'";
decimal rest = 0;
decimal betragsLimit = 0;
_lastCodeExists = _dbconn.DataSetExists(query, null);
if (_dbconn.DataSetExists(query, null))
{
_stopTimers();
_scanCodes(text, true);
SqlDataReader dr = _dbconn.GetResult(query, null);
while (dr.Read())
{
try
{
userid = dr.GetValue(0).ToString();
username = dr.GetValue(1).ToString();
codeid = dr.GetValue(2).ToString();
preis = Convert.ToDecimal(dr.GetValue(3).ToString());
issnackcode = Convert.ToBoolean(dr.GetValue(4));
kontoid = dr.GetValue(5).ToString();
if (!dr.IsDBNull(6))
{
inhouse = Convert.ToBoolean(dr.GetValue(6));
}
if (!dr.IsDBNull(7))
{
upddate = Convert.ToDateTime(dr.GetValue(7));
}
}
catch (SqlException exp)
{
this.WriteInfo("SQLException: " + exp.Message);
dr.Close();
}
}
dr.Close();
if (issnackcode)
{
string restquery = "Select rest, BetragsLimit from T_User where UserID='" + userid + "'";
SqlDataReader sqldr = _dbconn.GetResult(restquery, null);
while (sqldr.Read())
{
rest = Convert.ToDecimal(sqldr.GetValue(0).ToString());
betragsLimit = Convert.ToDecimal(sqldr.GetValue(1).ToString());
}
sqldr.Close();
Form.SendMailIfLimitReached(preis, rest, betragsLimit, userid);
rest = rest + preis;
string insert = string.Format("Insert into T_Posten(UserID,CodeID,Preis)values('{0}','{1}','{2}')", userid, codeid,
preis.ToString().Replace(",", "."));
_dbconn.Execute(insert, null);
string userinsert = "Update T_User set rest='" + rest.ToString().Replace(",", ".") + "' where UserID='" + userid + "'";
_dbconn.Execute(userinsert, null);
_dateTime = DateTime.Now;
this.WriteInfo("Save Posten... " + username + "; " + preis);
FlashUserImage(userid, preis);
}
else
{
bool iscomming = false;
if (!string.IsNullOrEmpty(kontoid))
{
DateTime time = DateTime.Now;
if (time.Day > upddate.Day)
{
iscomming = true; inhouse = false;
}
if (!inhouse)
{
iscomming = true;
}
inhouse = !inhouse;
ParameterObj timeObj = new ParameterObj();
timeObj.name = "@Timer";
timeObj.type = SqlDbType.DateTime;
timeObj.value = time;
List <ParameterObj> paramlist = new List <ParameterObj>();
paramlist.Add(timeObj);
string kquery = "Update T_UserTimeKonto set InHouse='" + inhouse + "',UpdateTime=@Timer where KontoID='" + kontoid + "'";
_dbconn.Execute(kquery, paramlist);
string ntime = "Insert into T_Time(KontoID,Time,iscomming)values('" + kontoid + "',@Timer,'" + iscomming + "')";
_dbconn.Execute(ntime, paramlist);
}
string inn = "Welcome";
if (!iscomming)
{
inn = "Bye";
}
this.WriteInfo("TimeCode... " + inn + " " + username + "!");
}
}
else
{
this.WriteInfo("UserCode (" + text + ") not exists...");
_startTimers();
SaveLastUnknownCode(text);
_scanCodes(text, false);
}
}
catch (Exception exp)
{
this.WriteInfo("Error: " + exp.Message);
}
}
public void ShowView(ParameterObj p_ParameterObj)
{
switch (p_ParameterObj.MethodName)
{
case "到店消费":
{
ShowView("收银");
frmCashier frmcashier = m_CurrentView as frmCashier;
BookingObjDetail detail = p_ParameterObj.Parameter[0] as BookingObjDetail;
frmcashier.SetBookingObjDetail(detail);
break;
}
}
}
private void toolStripMenuItemSave_Click(object sender, EventArgs e)
{
try
{
_saveButtonWasClicked = true;
Snackboxx.Core.User user = new Snackboxx.Core.User();
user.userid = tbuserid.Text;
user.username = this.InsertParameterCheck(tbusername.Text);
user.loginname = this.InsertParameterCheck(tbloginname.Text);
if (tb_userLimit.Text == "0.00" || tb_userLimit.Text == "")
{
user.betragsLimit = SnackboxxForm.DEFAULT_LIMIT;
user.nextBetragsLimit = SnackboxxForm.DEFAULT_LIMIT;
}
else
{
user.betragsLimit = tb_userLimit.Text;
user.nextBetragsLimit = tb_userLimit.Text;
}
string password = null;
if (!string.IsNullOrEmpty(tbpassword.Text))
{
password = _crypt.EncryptMessage(this.InsertParameterCheck(tbpassword.Text), _cryptstr);
}
user.Password = tbpassword.Text;
user.EMail = this.InsertParameterCheck(tbemail.Text);
if (cBUserRights.Items.Count > 0)
{
user.UserRightID = ((UserRight)cBUserRights.SelectedItem).userRightID;
}
ParameterObj timeObj = new ParameterObj();
timeObj.name = "@Timer";
timeObj.type = SqlDbType.DateTime;
timeObj.value = DateTime.Now;
if (string.IsNullOrEmpty(tbuserid.Text)) //newUser
{
#region newUser
if (!_dbconn.DataSetExists("Select * from T_User where UserName='******'", null))
{
string insert = "Insert into T_User(UserName,Password,EMail,UserRightID,LoginName,BetragsLimit,NextBetragsLimit)"
+ "values('" + user.username + "','" + password + "','" + user.EMail + "','" + user.UserRightID + "','" +
user.loginname + "','" + user.betragsLimit + "','" + user.nextBetragsLimit + "')";
_dbconn.Execute(insert, null);
string query = "Select UserID from T_User where UserName='******'";
SqlDataReader dr = _dbconn.GetResult(query, null);
while (dr.Read())
{
user.userid = dr.GetValue(0).ToString();
}
dr.Close();
user.usercodes = new List <UserCode>();
for (int i = 0; i < lbcodes.Items.Count; ++i)
{
UserCode Ucode = (UserCode)lbcodes.Items[i];
user.usercodes.Add(Ucode);
string insertcode = "Insert into T_UserCodes(UserID,UserCode,Preis,IsSnackCode)"
+ "values('" + user.userid + "','" + Ucode.userCode + "','" + Ucode.Preis + "','" + Ucode.Issnackcode + "')";
_dbconn.Execute(insertcode, null);
}
List <ParameterObj> paramlist = new List <ParameterObj>();
paramlist.Add(timeObj);
string insertK = "Insert into T_UserTimeKonto(UserID,InHouse,UpdateTime)values('" + user.userid + "','false',@Timer)";
_dbconn.Execute(insertK, paramlist);
TreeNode node = new TreeNode();
node.Text = user.username;
node.Tag = user;
tvuser.Nodes.Add(node);
_form.SettssinfoONE("User Add... User " + user.username + " with follow ID " + user.userid + " is inserted...");
//this.WriteLog("User Add... User " + username + " with follow ID " + user.userid + " is inserted...");
}
else
{
_form.SettssinfoONE("User exists in the Database... " + user.username);
//this.WriteLog("User exists in the Database... " + username);
}
//this.btnclear_Click(sender, e);
#endregion
}
else //olduser
{
#region olduser
string queryupd = "Update T_User set UserName='******',Password='******',LoginName='" + user.loginname
+ "',EMail='" + user.EMail
+ "',UserRightID='" + user.UserRightID
+ "',BetragsLimit ='" + user.betragsLimit
+ "' where UserID='" + user.userid + "'";
_dbconn.Execute(queryupd, null);
string query = "Select * from T_UserCodes where UserID='" + user.userid + "'";
List <Dictionary <string, string> > oldCodes = _dbconn.GetResultList(query, null);
string kquery = "Select * from T_UserTimeKonto where UserID='" + user.userid + "'";
if (!_dbconn.DataSetExists(kquery, null))
{
List <ParameterObj> paramlist = new List <ParameterObj>();
paramlist.Add(timeObj);
string insertK = "Insert into T_UserTimeKonto(UserID,InHouse,UpdateTime)values('" + user.userid + "','false',@Timer)";
_dbconn.Execute(insertK, paramlist);
}
for (int i = 0; i < oldCodes.Count; ++i)
{
bool exists = false;
string codeid = oldCodes[i]["CodeID"];
for (int j = 0; j < lbcodes.Items.Count; ++j)
{
UserCode code = (UserCode)lbcodes.Items[j];
if (codeid == code.CodeID)
{
exists = true;
}
}
if (!exists)
{
string check = "Select * from T_User where UserID='" + user.userid + "' and rest>=0";
if (!_dbconn.DataSetExists(check, null))
{
string delquery = "Delete from t_UserCodes where UserID='" + user.userid + "' and CodeID='" + codeid + "'";
_dbconn.Execute(delquery, null);
}
}
}
List <UserCode> UserCodelist = new List <UserCode>();
for (int i = 0; i < lbcodes.Items.Count; ++i)
{
UserCode code = (UserCode)lbcodes.Items[i];
if (string.IsNullOrEmpty(code.CodeID))
{
code.UserID = tbuserid.Text;
string insert = "Insert into T_UserCodes(UserID,UserCode,Preis,IsSnackCode)"
+ "values('" + code.UserID + "','" + code.userCode + "','" + code.Preis + "','" + code.Issnackcode + "')";
//this.WriteInfo(insert);
_dbconn.Execute(insert, null);
}
}
_form.SettssinfoONE("User Edit: User " + tbusername.Text + " was edit...");
//this.WriteLog("User Edit: User " + tbusername.Text + " was edit...");
tvuser.SelectedNode.ForeColor = Color.Black;
tvuser.SelectedNode.Tag = user;
#endregion
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message + "\n" + exp.StackTrace);
//this.WriteLog("UserSave ... Exception: " + exp.Message);
}
}
