public void Save(object o)
{
db db1 = new db();
character t = (character)o;
if (t.IsDirty)
{
// save dirt to database
db1 = new MMO.db();
db1.SetCommand("s_SaveCharacter", CommandType.StoredProcedure);
db1.AddParam<int>("id", SqlDbType.Int, 4, t.id);
db1.AddParam<int>("login", SqlDbType.Int, 4, owner.loginID);
db1.AddParam<string>("charactername", SqlDbType.VarChar, 50, t.name);
db1.AddParam<int>("charactertype", SqlDbType.Int, 4, 0);
db1.AddParam<int>("hp", SqlDbType.Int, 4, t.hp);
db1.AddParam<int>("stamina", SqlDbType.Int, 4, t.stamina);
db1.AddParam<int>("mana", SqlDbType.Int, 4, t.mana);
db1.AddParam<int>("x", SqlDbType.Int, 4, t.x);
db1.AddParam<int>("y", SqlDbType.Int, 4, t.y);
// return value of runscalar is the new or old id of tile
t.id = Int32.Parse(db1.RunScalar().ToString());
// no dirt to save
t.IsDirty = false;
}
}
protected void regDBImage(string[] info)
{
string name = info[0];
string fn = info[1];
string description = info[2];
string email = info[3];
string path = info[4];
DateTime date = DateTime.Now;
int UserID = util.getID(email);
db dbc = new db();
try
{
dbc.cmd.CommandText = "INSERT INTO pictures (name,filename,description,userID,date,path) VALUES(@Name,@FileName,@Description,@UserID,@Date,@Path)";
dbc.cmd.Parameters.Add(new SqlParameter("Name", name));
dbc.cmd.Parameters.Add(new SqlParameter("FileName", fn));
dbc.cmd.Parameters.Add(new SqlParameter("Description", description));
dbc.cmd.Parameters.Add(new SqlParameter("UserID", UserID));
dbc.cmd.Parameters.Add(new SqlParameter("Date", date));
dbc.cmd.Parameters.Add(new SqlParameter("Path", path));
dbc.cmd.ExecuteNonQuery();
}
catch
{
Gavan.Global.error = "ההעלה נכשלה נסה שוב.";
}
}
//get the order
protected int getquestionorder()
{
int temporder = 0;
SqlDataReader dreader;
SqlCommand findorder = new SqlCommand("select Top 1* from " + quizquestionstable + " where quizid=@quizid order by 'questionorder' Desc");
findorder.Parameters.AddWithValue("quizid", quizId);
db getorder = new db();
dreader = getorder.returnDataReader(findorder);
if (!dreader.HasRows)
{
temporder = 1;
}
else
{
while (dreader.Read())
{
string temporderstr = dreader["questionorder"].ToString();
int itempos = Convert.ToInt32(temporderstr);
temporder = itempos + 1;
}
}
return temporder;
}
public List<character> GetCharacters()
{
db db1 = new db();
db1.SetCommand("s_CharactersGet", CommandType.StoredProcedure);
db1.AddParam<int>("LoginID", SqlDbType.Int, 4, owner.loginID);
db1.Read();
// access the datareader within the class
while (db1.dr.Read())
{
character chr1 = new character();
chr1.id = Int32.Parse(db1.dr["id"].ToString());
chr1.hp = Int32.Parse(db1.dr["hp"].ToString());
chr1.mana = Int32.Parse(db1.dr["mana"].ToString());
chr1.owner = owner.loginName;
chr1.stamina = Int32.Parse(db1.dr["stamina"].ToString());
//chr1.tile_on = Int32.Parse(db1.dr["tile_on"].ToString());
chr1.x = Int32.Parse(db1.dr["x"].ToString());
chr1.y = Int32.Parse(db1.dr["y"].ToString());
chr1.name = db1.dr["charactername"].ToString();
list.Add(
chr1
);
}
return list;
}
protected void bindentries()
{
DataTable dTable = new DataTable();
SqlCommand getresponses = new SqlCommand("select id, email, name, correctanswers, wronganswers from " + quizresponsestable + " where quizid=@quizid");
getresponses.Parameters.AddWithValue("quizid", quizId);
db getresponseslist = new db();
dTable = getresponseslist.returnDataTable(getresponses);
if (dTable.Rows.Count > 0)
{
responsesdiv.Visible = true;
responsesrpt.Visible = true;
exportdiv.Visible = true;
lblmessage.Visible = false;
responsesrpt.DataSource = dTable;
responsesrpt.DataBind();
lblmessage.Visible = true;
lblmessage.Text = "Total Entries: " + dTable.Rows.Count.ToString() + "<br />";
}
else
{
responsesdiv.Visible = false;
responsesrpt.Visible = false;
exportdiv.Visible = false;
lblmessage.Visible = true;
lblmessage.Text = "Nothing available at the moment" + "<br /><br />";
}
}
protected void LoadData()
{
db dbc = new db();
string query = "SELECT * FROM pages ORDER BY id DESC";
dbc.cmd.CommandText = query;
SqlDataAdapter da = new SqlDataAdapter(dbc.cmd);
DataTable dt = new DataTable();
da.Fill(dt);
PagedDataSource pgitems = new PagedDataSource();
DataView dv = new DataView(dt);
pgitems.DataSource = dv;
pgitems.AllowPaging = true;
pgitems.PageSize = 9;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPages.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i < pgitems.PageCount; i++)
pages.Add((i + 1).ToString());
rptPages.DataSource = pages;
rptPages.DataBind();
}
else
rptPages.Visible = false;
rptContent.DataSource = pgitems;
rptContent.DataBind();
}
protected void deleteUserPicturesFromDB(int id)
{
db dbc = new db();
string query = "DELETE FROM pictures WHERE userID = @Id";
dbc.cmd.Parameters.Add(new SqlParameter("Id", id));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
public AuthWindow()
{
InitializeComponent();
DataContext = new db();
// InitAuth();
}
protected void DeleteInfo(int id)
{
db dbc = new db();
string query = "DELETE FROM Info WHERE id=@Id";
dbc.cmd.Parameters.Add(new SqlParameter("Id", id));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
//
// GET: /Product/Edit/5
public ActionResult Edit(int id)
{
var db = new db();
var product = db.Products.SingleOrDefault(x => x.Id == id);
return View(product);
}
protected void UpdatePicture(int PictureID, string picname, string description)
{
db dbc = new db();
dbc.cmd.Parameters.Add(new SqlParameter("Name", picname));
dbc.cmd.Parameters.Add(new SqlParameter("Description", description));
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", PictureID));
dbc.cmd.CommandText = "UPDATE pictures SET name = @Name, description = @Description WHERE id = @PictureID";
dbc.cmd.ExecuteNonQuery();
}
private int GetLoginID(string username)
{
MMO.db db1 = new db();
/* if not exist, create and then return id */
db1.SetCommand("s_LoginIDGet", CommandType.StoredProcedure);
db1.AddParam<string>("Login", SqlDbType.NVarChar, 50, username);
return Int32.Parse(db1.RunScalar().ToString());
}
protected void SendInfo(string name, string content, string url)
{
db dbc = new db();
string query = "INSERT INTO pages(title, content,url) VALUES(@Name, @Content, @URL)";
dbc.cmd.Parameters.Add(new SqlParameter("Name", name));
dbc.cmd.Parameters.Add(new SqlParameter("Content",content));
dbc.cmd.Parameters.Add(new SqlParameter("URL",url));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
protected void UpdateInfo(string name, string content,int id)
{
db dbc = new db();
string query = "UPDATE Info SET name=@Name, content=@Content WHERE id=@Id";
dbc.cmd.Parameters.Add(new SqlParameter("Name", name));
dbc.cmd.Parameters.Add(new SqlParameter("Content",content));
dbc.cmd.Parameters.Add(new SqlParameter("Id", id));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
protected void bindquestion()
{
SqlDataReader dreader;
SqlCommand getquestioncmd = new SqlCommand("select id, quizid, type, title from " + quizquestionstable + " where id=@questionid");
getquestioncmd.Parameters.AddWithValue("questionid", qId);
db getquestion = new db();
dreader = getquestion.returnDataReader(getquestioncmd);
if (!dreader.HasRows)
{
editquestiondiv.InnerHtml = "<br /><span style='color:#FF0000; font-size:15px;'>Sorry! we could not complete your request at this time. please try again later.</span><br />";
}
else
{
while (dreader.Read())
{
//set the home link
string quizidstr = dreader["quizid"].ToString();
HyperLink homelink = (HyperLink)Master.FindControl("homelnk");
if (homelink != null)
{
homelink.NavigateUrl = "setquestions?q=" + quizidstr;
}
//detect question type and set the template
qtype = dreader["type"].ToString();
if (qtype == "single")
{
singleoptiondiv.Visible = true;
textoptiondiv.Visible = false;
questionstr = dreader["title"].ToString();
txtsingleoption.Text = questionstr;
populateoptions(qId);
}
else if (qtype == "text")
{
singleoptiondiv.Visible = false;
textoptiondiv.Visible = true;
questionstr = dreader["title"].ToString();
txttextoption.Text = questionstr;
txttextoptionanswer.Text = textoptionstr;
}
else
{
//do nothing for time being
}
}
}
}
public FaceSetBrowser(String faceSetName, Manager fm, db.TrainingRunInfo modelInfo)
{
InitializeComponent();
faceGridControl1.initColumns(2);
faceGridControl1._fm = fm;
_faces = fm.GetFaceSet(faceSetName);
this.Text = "Face Set: " + faceSetName + ", " + _faces.Count + " faces.";
faceGridControl1.Init(_faces);
_modelInfo = modelInfo;
_fm = fm;
_faceSetName = faceSetName;
}
private db dba; //-> Persistent database handler objecct in form memory
#endregion Fields
#region Constructors
public form1()
{
InitializeComponent();
try
{
dba = new db();
}
catch(Exception e)
{
MetroFramework.MetroMessageBox.Show(this, "Database Connection Failure: " + e.Message.ToString() , "MySQL Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
protected void deleteFromPics(int pictureID)
{
db dbc = new db();
try
{
string query = "DELETE FROM pictures WHERE id = @PictureID";
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", pictureID));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
catch
{
Response.Write("ישנה בעיה.");
}
}
protected void deleteComment(int commentID)
{
try
{
db dbc = new db();
string query = "DELETE FROM comments WHERE id = @CommentID";
dbc.cmd.Parameters.Add(new SqlParameter("CommentID", commentID));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
catch
{
Response.Write("ישנה בעיה..");
}
}
protected bool existComment(int commentID)
{
int counter = 0;
db dbc = new db();
string query = "SELECT * FROM comments WHERE id = @CommentID";
dbc.cmd.Parameters.Add(new SqlParameter("CommentID", commentID));
dbc.cmd.CommandText = query;
SqlDataReader reader = dbc.cmd.ExecuteReader();
if (reader.Read())
{
counter++;
}
if (counter == 1)
return true;
return false;
}
protected void UpdateUser(string[] data)
{
db dbc = new db();
string query = "UPDATE users SET name = @Name, email = @Email, password = @Password, status = @Status, grade = @Grade WHERE id = @ID";
if(String.IsNullOrEmpty(data[2]) && data[2] == data[3])
query = "UPDATE users SET name = @Name, email=@Email, status = @Status, grade = @Grade WHERE id = @ID";
dbc.cmd.Parameters.Add(new SqlParameter("Name", data[0]));
dbc.cmd.Parameters.Add(new SqlParameter("Email", data[1]));
dbc.cmd.Parameters.Add(new SqlParameter("Password", util.hashSalt(data[2])));
dbc.cmd.Parameters.Add(new SqlParameter("Status", data[4]));
dbc.cmd.Parameters.Add(new SqlParameter("Grade", data[5]));
dbc.cmd.Parameters.Add(new SqlParameter("ID", data[6]));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
protected internal string[] getDetails(int id)
{
db dbc = new db();
dbc.cmd.CommandText = "SELECT name,content FROM Info WHERE id = @Id";
dbc.cmd.Parameters.Add(new SqlParameter("Id", id));
SqlDataAdapter adapter = new SqlDataAdapter(dbc.cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
string[] info = new string[2];
DataTable dataTable = ds.Tables["info"];
foreach (DataRow dr in ds.Tables[0].Rows)
{
info[0] = Convert.ToString(dr["name"]);
info[1] = Convert.ToString(dr["content"]);
}
return info;
}
protected void insertRank(int rank, int userID, int pictureID)
{
db dbc = new db();
dbc.cmd.Parameters.Add(new SqlParameter("UserID", userID));
dbc.cmd.Parameters.Add(new SqlParameter("Rank", rank));
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", pictureID));
string query = "INSERT INTO rank(userID,rank,pictureID) VALUES(@UserID, @Rank, @PictureID)";
try
{
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
catch
{
Gavan.Global.error = "משהו השתבש...";
}
}
protected void sendComment(int pictureID,int userID, string message)
{
try
{
db dbc = new db();
string query = "INSERT INTO comments(userID ,pictureID, message) VALUES(@UserID, @PictureID, @Message)";
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", pictureID));
dbc.cmd.Parameters.Add(new SqlParameter("UserID", userID));
dbc.cmd.Parameters.Add(new SqlParameter("Message", message));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
catch
{
Response.Write("יש פה בעיה..");
}
}
protected internal string[] getDataFromDB(int id)
{
db dbc = new db();
string query = "SELECT * FROM users WHERE id = @ID";
dbc.cmd.Parameters.Add(new SqlParameter("ID", id));
dbc.cmd.CommandText = query;
SqlDataReader reader = dbc.cmd.ExecuteReader();
string[] Data = new string[4];
while (reader.Read())
{
Data[0] = reader[1].ToString(); // Name
Data[1] = reader[2].ToString(); // Email
Data[2] = reader[4].ToString(); // Status
Data[3] = reader[5].ToString(); // Grade
}
return Data;
}
protected void updateRankPics(int rank, int userID, int pictureID)
{
db dbc = new db();
dbc.cmd.Parameters.Add(new SqlParameter("UserID", userID));
dbc.cmd.Parameters.Add(new SqlParameter("Rank", rank));
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", pictureID));
try
{
string query = "UPDATE pictures SET rank = rank+1 WHERE id = @PictureID";
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
catch
{
Gavan.Global.error = "משהו פה לא בסדר.";
}
}
protected internal string[] getDetails(int id)
{
db dbc = new db();
dbc.cmd.CommandText = "SELECT title,content,url FROM pages WHERE id = @Id";
dbc.cmd.Parameters.Add(new SqlParameter("Id", id));
SqlDataAdapter adapter = new SqlDataAdapter(dbc.cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
string[] pgData = new string[3];
DataTable dataTable = ds.Tables["pgData"];
foreach (DataRow dr in ds.Tables[0].Rows)
{
pgData[0] = Convert.ToString(dr["title"]);
pgData[1] = Convert.ToString(dr["content"]);
pgData[2] = Convert.ToString(dr["url"]);
}
return pgData;
}
protected void deleteFromComments(int pictureID)
{
db dbc = new db();
try
{
if (existComment(pictureID))
{
string query = "DELETE FROM comments WHERE pictureID = @PictureID";
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", pictureID));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
}
catch
{
Gavan.Global.error = "ישנה בעיה.";
}
}
protected void delteFromRanks(int pictureID)
{
db dbc = new db();
try
{
if (existRank(pictureID))
{
string query = "DELETE FROM ranks WHERE pictureID = @PictureID";
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", pictureID));
dbc.cmd.CommandText = query;
dbc.cmd.ExecuteNonQuery();
}
}
catch
{
Response.Write("ישנה בעיה. ");
}
}
protected internal string[] getDetails(int PictureID)
{
db dbc = new db();
dbc.cmd.CommandText = "SELECT name,description FROM pictures WHERE id = @PictureID";
dbc.cmd.Parameters.Add(new SqlParameter("PictureID", PictureID));
SqlDataAdapter adapter = new SqlDataAdapter(dbc.cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
string[] pic = new string[2];
DataTable dataTable = ds.Tables["pictures"];
foreach (DataRow dr in ds.Tables[0].Rows)
{
pic[0] = Convert.ToString(dr["name"]);
pic[1] = Convert.ToString(dr["description"]);
}
return pic;
}
private void btnDeleteTask_Click(object sender)
{
if (project_taskViewSource.View != null)
{
project_taskViewSource.View.Filter = null;
List <project_task> _project_task = treeProject.ItemsSource.Cast <project_task>().ToList();
ProjectTaskDB.NumberOfRecords = 0;
foreach (project_task task in _project_task.Where(x => x.IsSelected == true))
{
if (task.status == Status.Project.Pending)
{
using (db db = new db())
{
if (task.id_project_task != 0)
{
db.project_task.Remove(db.project_task.Where(x => x.id_project_task == task.id_project_task).FirstOrDefault());
db.SaveChanges();
}
else
{
ProjectTaskDB.Entry(task).State = EntityState.Detached;
}
}
ProjectTaskDB.NumberOfRecords += 1;
}
else
{
//ProjectTaskDB.SaveChanges();
toolBar_btnAnull_Click(sender);
}
}
ProjectTaskDB = new entity.ProjectTaskDB();
ProjectTaskDB.projects.Where(a => a.is_active == true && a.id_company == CurrentSession.Id_Company).Load();//.Include(x => x.project_task).Load();
projectViewSource.Source = ProjectTaskDB.projects.Local;
project_taskViewSource.View.Filter = null;
project_taskViewSource.View.Refresh();
filter_task();
//treeProject.UpdateLayout();
}
}
protected void btnNext_Clicksingle(object sender, EventArgs e)
{
answer = Page.Session["answer"].ToString();
question = Page.Session["question"].ToString();
quizId = Convert.ToInt32(Page.Session["quizid"]);
selectedanswer = Page.Session["selectedanswer"].ToString();
quizname = Page.Session["quizname"].ToString();
string accurateanswer = "";
if (selectedanswer.ToLower().Trim().Replace(" ", "") == answer.ToLower().Trim().Replace(" ", ""))
{
accurateanswer = "Y";
}
else
{
accurateanswer = "N";
}
SqlCommand insertnew = new SqlCommand("insert into " + quizresponsestable + " (quizid, userid, question, user_answer, correct_answer, accurate_answer, quiz_name, lastupdated) values (@quizid, '*****@*****.**', @question, @user_answer, @correct_answer, @accurate_answer, @quiz_name, @lastupdated);SELECT CAST(scope_identity() AS int)");
insertnew.Parameters.AddWithValue("quizid", quizId);
//insertnew.Parameters.AddWithValue("userid", userid);
insertnew.Parameters.AddWithValue("question", question);
insertnew.Parameters.AddWithValue("user_answer", selectedanswer);
insertnew.Parameters.AddWithValue("correct_answer", answer);
insertnew.Parameters.AddWithValue("accurate_answer", accurateanswer);
insertnew.Parameters.AddWithValue("quiz_name", quizname);
insertnew.Parameters.AddWithValue("lastupdated", updatedate);
db insertnewquestion = new db();
insertnewquestion.ExecuteQuery(insertnew);
lberror.Visible = false;
Image.Visible = false;
txtanswer.Text = null;
questcounter = Convert.ToInt32(Page.Session["questcounter"]);
numques = Convert.ToInt32(Page.Session["numques"]);
LoadQuestion();
}
public AdminMenu(User user)
{
db = new db();
this.user = user;
InitializeComponent();
for (int i = 0; i < 24; i++)
{
cbTimeH.Items.Add($"{i}");
}
for (int i = 0; i < 60; i++)
{
cbTimeM.Items.Add($"{i}");
cbTimeS.Items.Add($"{i}");
}
cbTimeH.SelectedIndex = 0;
cbTimeM.SelectedIndex = 0;
cbTimeS.SelectedIndex = 0;
MessageBox.Show($"{helper.WelcomeTime(DateTime.Now)}, {helper.WelcomeText(user.getsex())} {user.getname()}!");
lWelcome.Content = $"Привет, {user.getname()}";
MySqlConnection conn = db.newConnection();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Event LIMIT 1", conn);
try
{
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
@event = new Event(reader.GetValue(0).ToString(), reader.GetValue(1).ToString(), reader.GetDateTime(2));
}
}
lAdHeader.Content = @event.getname();
lAdBody.Text = "Мероприятие: " + @event.getdescription();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
timer.Tick += new EventHandler(timerTick);
timer.Interval = new TimeSpan(0, 0, 1);
timer.Start();
}
public List <ListHistorial> GetLista(int id)
{
using (var ctx = new db())
{
var query = from servicios in ctx.Servicios
join historial in ctx.Historial on servicios.IDservicio equals historial.IDservicio
where servicios.IDservicio == id
select new ListHistorial
{
IDservicio = servicios.IDservicio,
IDhistoria = historial.IDhistoria,
IDequipo = servicios.IDequipo,
Fecha = historial.Fecha,
Comentario = historial.Comentario,
IDusuario = historial.IDusuario
};
return(query.ToList());
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (TextBox1.Text.Trim() == "")
{
Label1.Text = "You entered an empty caption, please fill the caption field";
}
if (Session["picid"] == null)
{
Response.Redirect("pictures.aspx");
}
string s = TextBox1.Text.Trim();
db d = new db();
d.update("UPDATE [familyPhoto].[dbo].[photo] SET [pCaption] = '" + s + "' WHERE pid=" + Session["picid"].ToString());
d.updatenews(Convert.ToInt32(Session["id"]), Session["name"].ToString(), "updated", "the caption of an image");
Label1.Text = "The caption is updated successfully";
}
public void config()
{
db d1 = new db();
string path = d1.accessdb();
OleDbConnection conn = new OleDbConnection(path);
conn.Open();
string sql = "select * from config";
OleDbCommand comm = new OleDbCommand(sql, conn);
OleDbDataReader odr = comm.ExecuteReader();
while (odr.Read())
{
title = odr[0].ToString();
}
odr.Close();
conn.Close();
}
private void show()
{
db d1 = new db();
string path = d1.accessdb();
conn = new OleDbConnection(path);
string sql = "select * from page where page_id=3";
conn.Open();
OleDbCommand comm = new OleDbCommand(sql, conn);
OleDbDataReader odr = comm.ExecuteReader();
while (odr.Read())
{
Label1.Text = odr[2].ToString();
}
odr.Close();
conn.Close();
}
//get the recent quizes
protected void Bindquizes()
{
SqlDataReader dReader;
SqlCommand getquizescmd = new SqlCommand("select id, name, description, startdate, enddate, termsandconditions from " + quizdetailstable);
db getquizeslist = new db();
dReader = getquizeslist.returnDataReader(getquizescmd);
if (!dReader.HasRows)
{
lblmessage.Visible = true;
lblmessage.Text = "Nothing available at the moment" + "<br /><br />";
}
else
{
while (dReader.Read())
{
//get and store quizid
quizfield.Value = dReader["id"].ToString();
quizId = Convert.ToInt32(quizfield.Value);
//quiz details
quizname = dReader["name"].ToString();
description = dReader["description"].ToString();
start = Convert.ToDateTime(dReader["startdate"].ToString());
end = Convert.ToDateTime(dReader["enddate"].ToString());
terms = dReader["termsandconditions"].ToString();
//show quiz if start/end date is valid
if ((updatedate < start) && (updatedate > end))
{
lblmessage.Visible = true;
lblmessage.Text = "Sorry! We could not process your request. please try later.";
}
else
{
lblquizname.Text = quizname;
lbldescription.Text = description;
}
}
}
}
public void show()
{
db d1 = new db();
string path = d1.accessdb3();
OleDbConnection conn = new OleDbConnection(path);
conn.Open();
string sql = "select * from type where type_type=2";
OleDbCommand comm = new OleDbCommand(sql, conn);
OleDbDataReader odr = comm.ExecuteReader();
while (odr.Read())
{
DropDownList1.Items.Add(odr[1].ToString());
}
odr.Close();
conn.Close();
}
public void dataview(int id)
{
db d1 = new db();
string path = d1.accessdb3();
conn = new OleDbConnection(path);
conn.Open();
string sql = "select * from edit where edit_id=" + id;
OleDbCommand ocm = new OleDbCommand(sql, conn);
OleDbDataReader odr = ocm.ExecuteReader();
while (odr.Read())
{
TextBox1.Text = string.Format("{0}", odr[1]);
FreeTextBox1.Text = string.Format("{0}", odr[3]);
}
odr.Close();
conn.Close();
}
private int save_Rate(int id_currency)
{
using (db db = new db())
{
if (db.app_currency.Where(x => x.id_currency == id_currency).FirstOrDefault() != null)
{
app_currencyfx app_currencyfx = new app_currencyfx();
app_currencyfx.id_currency = id_currency;
app_currencyfx.app_currency = db.app_currency.Where(x => x.id_currency == id_currency).FirstOrDefault();
app_currencyfx.buy_value = Rate_Current;
app_currencyfx.sell_value = Rate_Current;
app_currencyfx.is_active = false;
db.app_currencyfx.Add(app_currencyfx);
db.SaveChanges();
return(app_currencyfx.id_currencyfx);
}
return(0);
}
}
public static decimal get_activeRate(int id_currency, App.Names application)
{
decimal r = 0;
using (db db = new db())
{
if (application == App.Names.SalesOrder ||
application == App.Names.SalesInvoice)
{
r = db.app_currencyfx.Where(x => x.id_currency == id_currency && x.is_active == true).FirstOrDefault().buy_value;
}
else if (application == App.Names.PurchaseOrder ||
application == App.Names.PurchaseInvoice)
{
r = db.app_currencyfx.Where(x => x.id_currency == id_currency && x.is_active == true).FirstOrDefault().sell_value;
}
}
return(r);
}
protected void Page_Load(object sender, EventArgs e)
{
vConexion = new db();
if (!Page.IsPostBack)
{
if (Convert.ToBoolean(Session["AUTH"]))
{
generales vGenerales = new generales();
DataTable vDatos = (DataTable)Session["AUTHCLASS"];
if (!vGenerales.PermisosRecursosHumanos(vDatos))
{
Response.Redirect("/default.aspx");
}
Cargar();
}
}
DDLEmpleado.CssClass = "fstdropdown-select form-control";
}
public ActionResult AddMaskForm(AdminAddMaskModel model)
{
db db = new db();
//string FileMask = db.singleItemSelect("maskFile", maskTable, "bakeryId='" + bakeryId + "' AND maskFile='" + model.Mask + "'").ToString();
if (model.bakeryId != null)
{
int bakeryId = int.Parse(model.bakeryId.ToString());
db.singleItemInsertAsync(maskTable, "bakeryId,maskFile,maskName,maskRole", bakeryId + ",'" + model.Mask + "','" + model.maskName + "','" + model.maskRole + "'");
Session["success"] = "Mask: " + model.Mask + " has been successfully added to bakery: " + model.bakeryId + ".";
}
else
{
db.singleItemInsertAsync(maskTable, "bakeryId,maskFile,maskName,maskRole", Session["id"].ToString() + ",'" + model.Mask + "','" + model.maskName + "','" + model.maskRole + "'");
Session["success"] = "Mask: " + model.Mask + " has been successfully added to bakery: " + Session["id"].ToString() + ".";
}
return(RedirectToAction("AddMask", "Admin"));
}
protected void StartQuiz()
{
SqlDataReader dreader;
SqlCommand question = new SqlCommand("select title, type, data from " + quizquestionstable + " where id=@qID ");
question.Parameters.AddWithValue("qID", questionID[questcounter]);
db getorder = new db();
dreader = getorder.returnDataReader(question);
while (dreader.Read())
{
lbQuestion.Text = dreader["title"].ToString();
Page.Session["question"] = dreader["title"].ToString();
Byte[] tempdata = dreader["data"] as byte[];
type = dreader["type"].ToString();
Page.Session["type"] = type;
if (tempdata != null)
{
string base64String = Convert.ToBase64String(tempdata, 0, tempdata.Length);
Image.ImageUrl = "data:image/jpeg;base64," + base64String;
Image.Visible = true;
}
if (type == "multiple")
{
multipleoptiondiv.Visible = true;
BindQuestionsMultipleOption();
}
else
{
singleoptiondiv.Visible = true;
BindQuestionsSingleOption();
}
questcounter++;
Page.Session["questcounter"] = questcounter;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Label1.Visible = false;
// get the variables
String caption = TextBox1.Text.Trim();
try
{
string imgContentType = FileUpload1.PostedFile.ContentType;
//check if an image
if (imgContentType.ToLower().StartsWith("image"))
{
//get the image from upload stream
System.Drawing.Bitmap b = (System.Drawing.Bitmap)System.Drawing.Image.FromStream(FileUpload1.PostedFile.InputStream);
int img_pk = 0;
//store the image in database, and also ccheck to see if it was successful, and if so create
//a thumnail here of the stored image
img_pk = dbAccess.SaveImageToDB(BmpToBytes(b), caption, Convert.ToInt32(Session["albumid"]));
db d = new db();
d.updatenews(Convert.ToInt32(Session["id"]), Session["name"].ToString(), "inserted new", "picture");
Label1.Visible = true;
Label1.Text = "Your image is added to album successfully";
TextBox1.Text = "";
}
else
{
Label1.Visible = true;
Label1.Text = ("The file is not an image");
}
}
catch (Exception ex)
{
Label1.Visible = true;
Label1.Text = "ERROR: " + ex.Message.ToString();
}
}
public async Task <JsonResult> getData()
{
string json = null;
GraphReportResponse response = new GraphReportResponse();
StreamReader stream = new StreamReader(Request.InputStream);
if (json == null)
{
json = stream.ReadToEnd();
}
if (json != "")
{
//ReportModel RVM = new ReportModel();
GraphReport.Models.DataRequest dataRequest = JsonConvert.DeserializeObject <GraphReport.Models.DataRequest>(json);
switch (dataRequest.requestType)
{
case RequestType.batches:
db conn = new db("InternDelights", 12);
break;
case RequestType.frequency:
break;
case RequestType.differences:
break;
case RequestType.absoulteScale:
GraphReportHelper graphReportHelper = new GraphReportHelper();
response = await graphReportHelper.GetAbsoulteScale(dataRequest);
break;
}
}
else
{
return(null);
}
return(Json(response, "application/json", JsonRequestBehavior.AllowGet));
}
public ActionResult Login(LoginViewModel model)
{
string OldHASHValue = string.Empty;
try
{
using (db db = new db())
{
// Ensure we have a valid viewModel to work with
if (!ModelState.IsValid)
{
return(View(model));
}
//Retrive Stored HASH Value From Database According To Username (one unique field)
var userInfo = pocoDb.Fetch <tblUser>(" WHERE userName = @0 and userPassword=@1", model.UserName, model.UserPassword).FirstOrDefault();
if (userInfo != null)
{
//Login Success
//For Set Authentication in Cookie (Remeber ME Option)
SignInRemember(model.UserName);
//Set A Unique ID in session
Session["userId"] = userInfo.userID;
// If we got this far, something failed, redisplay form
// return RedirectToAction("Index", "Dashboard");
return(RedirectToAction("Index", "Issues"));
}
else
{
//Login Fail
TempData["ErrorMSG"] = "Access Denied! Wrong Credential";
return(RedirectToAction("Login", "Home"));
}
}
}
catch
{
throw;
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
String subject, com;
txtComment.ReadOnly = false;
txtSubject.ReadOnly = false;
subject = txtSubject.Text;
com = txtComment.Text;
if ((subject.Length == 0) || (com.Trim().Length == 0))
{
Label1.Text = "Enter a subject and comment Please";
txtSubject.Text = "";
txtComment.Text = "";
txtSubject.Focus();
}
else
{
Label1.Text = "";
int id = 0;
if (Session["id"] != null)
{
id = int.Parse(Session["id"].ToString());
}
//add to db
db d = new db();
d.update("INSERT INTO [familyPhoto].[dbo].[contact] ([subject],[comment],[memid])VALUES ('" + subject + "' , '" + com + "' ," + id + ")");
if (Session["id"] == null)
{
d.updatenews(0, "Guest", "inserted new", "comment");
}
else
{
d.updatenews(Convert.ToInt32(Session["id"]), Session["name"].ToString(), "inserted new", "comment");
}
txtComment.ReadOnly = true;
txtSubject.ReadOnly = true;
Label1.Text = "Your comment is sent successfully move to another page please.";
btnSend.Enabled = false;
}
}
public void photo()
{
db d1 = new db();
string path = d1.accessdb();
conn = new OleDbConnection(path);
string sql = "select top 1 type_id from type where type_type=2";
conn.Open();
OleDbCommand com = new OleDbCommand(sql, conn);
OleDbDataReader odr = com.ExecuteReader();
while (odr.Read())
{
HyperLink2.NavigateUrl = "photo.aspx?type=" + odr[0];
}
odr.Close();
conn.Close();
}
public void dataview(int id)
{
db d1 = new db();
string path = d1.accessdb();
conn = new OleDbConnection(path);
string sql = "select * from edit where edit_id=" + id;
OleDbDataAdapter oda = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
oda.Fill(ds, "title");
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.CurrentPageIndex = 0;
pds.AllowPaging = true;
pds.PageSize = 8;//设置每个页面显示的数量
DataList1.DataSource = pds;
DataList1.DataBind();
}
public void show()
{
db d1 = new db();
string path = d1.accessdb2();
OleDbConnection conn = new OleDbConnection(path);
conn.Open();
string sql = "select * from admin";
OleDbCommand comm = new OleDbCommand(sql, conn);
OleDbDataReader odr = comm.ExecuteReader();
while (odr.Read())
{
TextBox1.Text = odr[1].ToString();
TextBox2.Text = odr[0].ToString();
}
odr.Close();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
vConexion = new db();
if (!Page.IsPostBack)
{
if (Convert.ToBoolean(Session["AUTH"]))
{
generales vGenerales = new generales();
DataTable vDatos = (DataTable)Session["AUTHCLASS"];
if (!vGenerales.PermisosRecursosHumanos(vDatos))
{
Response.Redirect("/default.aspx");
}
CargarEmpleados();
CargarGrupos();
CargarRelojes();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
db d1 = new db();
string path = d1.accessdb();
OleDbConnection conn = new OleDbConnection(path);
conn.Open();
string sql = "select * from config";
OleDbCommand comm = new OleDbCommand(sql, conn);
OleDbDataReader odr = comm.ExecuteReader();
while (odr.Read())
{
footer1 = odr[1].ToString();
}
odr.Close();
conn.Close();
}
}
private void toolBar_btnNew_Click(object sender)
{
item item = ItemDB.New();
item.id_item_type = entity.item.item_type.FixedAssets;
using (db db = new db())
{ item.id_vat_group = db.app_vat_group.Where(x => x.is_default && x.id_company == CurrentSession.Id_Company).FirstOrDefault().id_vat_group; }
item_asset item_asset = new item_asset();
item.item_asset.Add(item_asset);
ItemDB.items.Add(item);
itemViewSource.View.Refresh();
itemViewSource.View.MoveCurrentTo(item);
itemitem_capitalViewSource.View.Refresh();
itemitem_capitalViewSource.View.MoveCurrentTo(item_asset);
}
public static void Show(db s)
{
List <homework> howeworkdata = new List <homework>();
howeworkdata = s.Readhomework();
int j = 1;
howeworkdata.ForEach(x =>
{
Console.WriteLine("第" + j + "筆資料");
Console.WriteLine("書店名:\t" + x.name);
Console.WriteLine("地址:\t" + x.address);
Console.WriteLine("開店時間:\t" + x.openTime);
Console.WriteLine("連絡電話:\t" + x.phone);
Console.WriteLine("\n");
Console.WriteLine("----------");
j++;
});
}
public static decimal return_ValueWithVAT(int id_vat_group, decimal ValueWithoutVAT)
{
decimal VAT_Value = 0;
if (id_vat_group != 0)
{
using (db db = new db())
{
List <app_vat_group_details> app_vat_group_details = new List <entity.app_vat_group_details>();
app_vat_group_details = db.app_vat_group_details.Where(x => x.id_vat_group == id_vat_group).ToList();
foreach (app_vat_group_details app_vat_group in app_vat_group_details)
{
VAT_Value = VAT_Value + calculate_Vat(ValueWithoutVAT, app_vat_group.app_vat.coefficient);
}
}
}
return(ValueWithoutVAT + VAT_Value);
}
public void dataview(int id)
{
db d1 = new db();
string path = d1.accessdb3();
conn = new OleDbConnection(path);
conn.Open();
string sql = "select * from photo where photo_id=" + id;
OleDbCommand ocm = new OleDbCommand(sql, conn);
OleDbDataReader odr = ocm.ExecuteReader();
while (odr.Read())
{
TextBox1.Text = string.Format("{0}", odr[0]);
TextBox2.Text = string.Format("{0}", odr[5]);
Image1.ImageUrl = "../../updata/small/" + string.Format("{0}", odr[2]);
}
odr.Close();
conn.Close();
}
public IActionResult GetPayments(string userid)
{
using (var db = new db())
{
var payments = (from payment in db.payments
where payment.UserId == userid
select payment).ToList();
if (payments != null || payments.Count > 0)
{
PaymentsHelper helper = new PaymentsHelper(payments);
double balance = helper.Balance;
PaymentsResponseDto response = new PaymentsResponseDto();
response.AccountBalance = balance;
response.Payments = payments;
return(Ok(response));
}
}
return(NotFound());
}
public int get_Location(item_product item_product, app_branch app_branch)
{
try
{
return(get_ProductLocation(item_product, app_branch));
}
catch
{
app_location app_location = new app_location();
app_location.id_branch = app_branch.id_branch;
app_location.name = "Default of " + app_branch.name;
app_location.is_default = true;
using (db db = new db())
{
db.app_location.Add(app_location);
db.SaveChangesAsync();
return(app_location.id_location);
}
}
}