protected void lnkbtnRelatedLinks_Click(object sender, EventArgs e)
{
LinkButton btn = (sender as LinkButton);
Label ID = btn.FindControl("Label8") as Label;
Label Time_Slot = btn.FindControl("Label7") as Label;
int i;
////lbl.Text = DateTime.Now.ToLongTimeString();
i = Convert.ToInt32(ID.Text.ToString());
//Label9.Text = i.ToString();
SqlConnection cn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SP_POS_Reservation_update", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
cmd.Parameters.AddWithValue("@ID", i);
cmd.Parameters.AddWithValue("@Time_Slot", Time_Slot.Text);
cmd.Parameters.AddWithValue("@Table_Number", btn.Text);
cmd.ExecuteNonQuery();
cn.Close();
Response.Redirect("~/Accounts/Booked.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton grd = (LinkButton)sender;
var lblID = (Label)grd.FindControl("Label1");
int EID = int.Parse(lblID.Text.ToString());
var frenchise = (Label)grd.FindControl("Label2");
String franchiseid = (frenchise.Text.ToString());
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
SqlCommand cmd = new SqlCommand("", con);
cmd.CommandText = "select [dbo].[Orderdate]('" + EID + "')";
con.Open();
int count = int.Parse(cmd.ExecuteScalar().ToString());
con.Close();
if (count == 1)
{
Response.Redirect("AdminGstInvoice.aspx?ID=" + EID + "&franchiseid=" + franchiseid);
}
else
{
Response.Redirect("Orderdetails2.aspx?ID=" + EID + "&franchiseid=" + franchiseid);
}
}
protected void LinkButton6_Click(object sender, EventArgs e)
{
LinkButton tk = (LinkButton)sender;
string user = ((TextBox)tk.FindControl("txt_user")).Text;
string pass = ((TextBox)tk.FindControl("txt_pass")).Text;
string sqladmin = "select * from TaiKhoan where userName='******' and MatKhau = '" + pass + "'and MaQSH = '1'";
string sql = "select * from TaiKhoan where userName='******' and MatKhau = '" + pass + "'and MaQSH = '2'";
DataTable table = new DataTable();
DataTable table1 = new DataTable();
try
{
SqlDataAdapter da = new SqlDataAdapter(sqladmin, stcn);
da.Fill(table);
SqlDataAdapter da1 = new SqlDataAdapter(sql, stcn);
da1.Fill(table1);
}
catch (SqlException err)
{
Response.Write("<b>Error</b>" + err.Message + "<p/>");
}
if (table.Rows.Count != 0)
{
Server.Transfer("QLTK.aspx");
}
else if (table1.Rows.Count != 0)
{
Server.Transfer("QLDH.aspx");
}
else
{
Response.Write("<script>alert('Tên Đăng Nhập Hoặc Mật Khẩu Không Đúng');</script>");
}
}
protected void BtnSelect_Click(object sender, EventArgs e)
{
try
{
if (ddlSRNO.SelectedIndex != 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Already sales returned do not modify ");
return;
}
LinkButton BtnLnk = (LinkButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk.Parent.Parent;
int rowGvIndex = rowGv.RowIndex;
Label LbItemCode = (Label)BtnLnk.FindControl("LbItemCode");
ddlParts.SelectedValue = LbItemCode.Text;
HiddenField hdUnit = (HiddenField)BtnLnk.FindControl("hdUnitCode");
txtUnitCode.Text = hdUnit.Value;
DisplayItem();
LbErr.Text = "";
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton grd = (LinkButton)sender;
var lblID = (Label)grd.FindControl("LblId");
int EID = int.Parse(lblID.Text.ToString());
var InvoiceType = (Label)grd.FindControl("InvoiceType");
string Invoice = InvoiceType.Text.ToString();
if (Invoice == "DP")
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
SqlCommand cmd = new SqlCommand("", con);
cmd.CommandText = "select [dbo].[Orderdate]('" + EID + "')";
con.Open();
int count = int.Parse(cmd.ExecuteScalar().ToString());
con.Close();
if (count == 1)
{
Response.Redirect("~/User/GSTInvoice.aspx?ID=" + EID);
}
else
{
Response.Redirect("~/User/OrderDetails2.aspx?ID=" + EID);
}
}
else
{
Response.Redirect("~/User/Redemption_Invoice.aspx?ID=" + EID);
}
}
protected void LinkButtonOrder_Click(object sender, EventArgs e)
{
try
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenField1"); //get hidden field control from gridview
TextBox tb = (TextBox)lb.FindControl("qty"); //get textbox control from gridview
if (tb == null || int.Parse(tb.Text) == 0 || tb.Text == "") //check textbox
{
//text box value is zero and null
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Zero and characters are not allowed')", true);
}
else
{
ReqBO rb = new ReqBO();
rlst = (List <ReqBO>)Session["cart"];
int id = Convert.ToInt32(hd.Value);
rb.ItemID = id;
rb.Description = rl.getDescription(id); //get item description
rb.ItemNumber = rl.getItemNumber(id); //get item number
int qty = Convert.ToInt32(tb.Text);
rb.RequestedQty = qty;
rb.Status = "Pending";
int index = isExiting(id);
if (index == -1)
{
rlst.Add(rb);
Session["cart"] = rlst;
}
else
{
rlst[index].RequestedQty += rb.RequestedQty;
Session["cart"] = rlst;
}
cartView.DataSource = Session["cart"];
cartView.DataBind();
if (cartView.Rows.Count >= 1)
{
btnSave.Visible = true;
btnCancel.Visible = true;
}
else //ask to jane
{
btnSave.Visible = false;
btnCancel.Visible = false;
}
tb.Text = "";//after add show nothing in textbox
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
protected void LinkButtonUpdateResult_Click(object sender, EventArgs e)
{
LinkButton button = (LinkButton)sender;
if (Session["LabId"] != null)
{
DataTable dttestresult = new DataTable();
dttestresult.Columns.AddRange(new DataColumn[2] {
new DataColumn("ReportID", typeof(string)),
new DataColumn("Result", typeof(string))
});
Label LabelOrderId = (Label)button.FindControl("LabelOrderId");
TextBox TextBoxReportNotes = (TextBox)button.FindControl("TextBoxReportNotes");
foreach (RepeaterItem TestResult in RepeaterTestResult.Items)
{
HiddenField HiddenFieldReportId = TestResult.FindControl("HiddenFieldReportId") as HiddenField;
TextBox TextBoxResult = TestResult.FindControl("TextBoxResult") as TextBox;
if (TextBoxResult.Text == "")
{
messagediv.Visible = true;
messagediv.Attributes["class"] = "fixed-message rounded alert bg-danger alert-dismissible animated fadeIn text-center text-white";
mesaagetxt.InnerHtml = "Error! Result field cannot be blank.";
}
else
{
dttestresult.Rows.Add(HiddenFieldReportId.Value, TextBoxResult.Text);
}
}
if (dttestresult.Rows.Count > 0)
{
string response = operation.UpdateTestResult(dttestresult);
if (response == "SUCCESS")
{
messagediv.Visible = true;
messagediv.Attributes["class"] = "fixed-message rounded alert bg-success alert-dismissible animated fadeIn text-center text-white";
mesaagetxt.InnerHtml = "Success! Result saved.";
dttestresult = null;
}
else if (response == "ERROR")
{
dttestresult = null;
messagediv.Visible = true;
messagediv.Attributes["class"] = "fixed-message rounded alert bg-danger alert-dismissible animated fadeIn text-center text-white";
mesaagetxt.InnerHtml = "Error! Test result not saved.";
}
}
}
}
protected void linkbtn1_Click1(object sender, EventArgs e)
{
LinkButton linkbtn1 = (LinkButton)sender;
var lblID = (Label)linkbtn1.FindControl("Label1");
Response.Redirect("UpdateAchieverList.aspx?RID=" + lblID.Text + "");
}
protected void link_Click(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
string videoName = btn.CommandArgument.ToString();
string sql = "select * from VideoInfo where VideoName=" + "'" + videoName + "'";
SqlDataReader sdr1 = DataOperate.GetRow(sql);
sdr1.Read();
video.Src = sdr1["VideoPath"].ToString();
currentVideo.Text = sdr1["VideoId"].ToString();
Label lb = (Label)btn.FindControl("title");
lb.Style["color"] = "red";
string stuId = Session["userId"].ToString();
string videoId = sdr1["VideoId"].ToString();
string courseId = Session["courseId"].ToString();
string updatedAt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string timeSql = "select count(*) from LearnRecord where stuId='" + stuId + "' and videoId=" + videoId;
if (DataOperate.SeleSQL(timeSql) == 0)
{
string insertSql = "insert into LearnRecord(stuId,courseId,videoId,updatedAt) values('" + stuId + "','" + courseId + "'," + videoId + ",'" + updatedAt + "')";
DataOperate.ExecSQL(insertSql);
}
string selectSql = "select * from LearnRecord where stuId='" + stuId + "' and videoId=" + videoId;
SqlDataReader sdr2 = DataOperate.GetRow(selectSql);
sdr2.Read();
getTime.Text = sdr2["currentTime"].ToString();
QABindData(videoId);
NBindData();
RBindData();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton tk = (LinkButton)sender;
string tim = ((TextBox)tk.FindControl("TextBox1")).Text;
Context.Items["mtimm"] = tim; Server.Transfer("timkiem.aspx");
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
//LinkButton ldispatch = (LinkButton)sender;
//var id = (Label)ldispatch.FindControl("lblOid");
//int oid = int.Parse(id.Text.ToString());
LinkButton grd = (LinkButton)sender;
var lblID = (Label)grd.FindControl("lblOid");
int EID = int.Parse(lblID.Text.ToString());
LinkButton grd1 = (LinkButton)sender;
var lblID1 = (Label)grd1.FindControl("lblOid");
int EID1 = int.Parse(lblID1.Text.ToString());
//SqlCommand cmd = new SqlCommand("update ordermaster set status =1 where orderid='" + oid + "'", con);
//con.Open();
//int i = cmd.ExecuteNonQuery();
//con.Close();
//if (i > 0)
//{
// //getorder(0);
// //msgBox("Order Dispached successfully");
// Response.Redirect("DispatchDetails.aspx?oId="+oid+"");
//}
//Response.Redirect("AddDispatchDetails.aspx?oId=" + oid + "");
Response.Redirect("EditDispatchDetails.aspx?oId=" + EID1);
}
protected void LinkBtnEdit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
LinkButton grd = (LinkButton)sender;
var lblID = (Label)grd.FindControl("lblAmount");
Session["Amount"] = lblID.Text.ToString();
cmd = new SqlCommand("Select * From JoiningPackages where Amount = '" + Session["Amount"].ToString() + "'", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
TextBox1.Text = dr["Code"].ToString();
TextBox2.Text = dr["Amount"].ToString();
TextBox3.Text = dr["Discription"].ToString();
TextBox4.Text = dr["JoiningPV"].ToString();
TextBox5.Text = dr["Caplimit"].ToString();
TextBox6.Text = dr["DirectIncome"].ToString();
}
dr.Close();
}
con.Close();
TextBox2.Enabled = false;
TextBox4.Enabled = false;
btnUpdate.Visible = true;
Button1.Visible = false;
lblerror.Visible = false;
}
protected void LinkButtonDelete_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenFieldStudID");
int studentID = int.Parse(hd.Value);
var ac = new AttendanceControl();
var studentToRemove = studentsControl.GetAllStudents().Where(x => x.Id == studentID).FirstOrDefault();
if (studentToRemove.Attendance.Count > 0)
{
ac.RemoveAttendanceByStudentID(studentID);
}
if (studentToRemove != null)
{
studentsControl.RemoveStudent(studentID);
var pc = new PeopleControl();
pc.RemovePeople(studentToRemove.PersonId);
}
BindGrid();
}
protected void btnSaveClick(object sender, EventArgs e)
{
// Get the value
LinkButton gvTemp = (LinkButton)sender;
LinkButton btnSave = (LinkButton)gvTemp.FindControl("lnkedit");
HiddenField hdnorgid = (HiddenField)gvTemp.FindControl("hdnorgid");
try
{
bindControls(btnSave.CommandArgument.ToString());
}
catch (Exception es)
{
}
}
protected void lbDetail_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenField1");
string title = hd.Value;
Session["booktitle"] = title;
Response.Redirect("BookDetails.aspx?BookDetail=" + title);
}
protected void uxThumbBtn_Click(object sender, EventArgs e)
{
LinkButton linkBtn = (LinkButton)sender;
Image img = (Image)linkBtn.FindControl("uxThumbImage");
uxCatalogImage.ImageUrl = img.ImageUrl.Replace("Thumbnail/", "");
SmallImage = img.ImageUrl.Replace("Thumbnail/", "");
}
protected void lnkestimateid_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
HiddenField HiddenFieldEstimate = (HiddenField)lnk.FindControl("HiddenFieldEstimate");
HiddenField HidCustomerId = lnk.FindControl("HidCustomerId") as HiddenField;
HiddenField HidProductTypeId = lnk.FindControl("HidProductTypeId") as HiddenField;
HiddenField HidProductTypeIdFrom = lnk.FindControl("HidProductTypeIdFrom") as HiddenField;
if (Convert.ToInt32(HidProductTypeId.Value) == 1)
{
Response.Redirect("Shutters.aspx?ProductId=" + HiddenFieldEstimate.Value + "&CustomerId=" + HidCustomerId.Value + "&ProductTypeId=" + HidProductTypeId.Value);
}
else
{
Response.RedirectPermanent("Custom.aspx?ProductId=" + HiddenFieldEstimate.Value + "&CustomerId=" + HidCustomerId.Value + "&ProductTypeId=" + HidProductTypeId.Value + "&ProductTypeIdFrom=" + HidProductTypeIdFrom.Value);
}
}
protected void uxThumbBtn_Click(object sender, EventArgs e)
{
LinkButton linkBtn = (LinkButton)sender;
Image img = (Image)linkBtn.FindControl("uxThumbImage");
uxQuickViewButton.CommandArgument = "show";
uxCatalogImage.ImageUrl = img.ImageUrl.Replace("Thumbnail/", "");
}
protected void linkbtnBorrar_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenFieldNombre");
FincaDal finca = new FincaDal();
finca.eliminar(hd.Value);
listar();
}
protected void lblView_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
int mid = Convert.ToInt32(((Label)lnk.FindControl("lblmarkid")).Text);
GridView1.DataSource = Market_Review.Get_Mark_ReviewDetails("", mid.ToString());
GridView1.DataBind();
mdpextender.Show();
}
protected void lb_edit_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenFieldStudID");
int studentID = int.Parse(hd.Value);
Response.Redirect($"EditStudent.aspx?StudentID={studentID}");
}
/* Module Name: LinkButtonSelect_Click;
* Student: Mayank Yadav
* Modification Date: 23-April-2018
* Description: Loads all the details related to a ticket
* Input/Outputs: Checks staff username and ticket id
* Globals: No global changes.
*/
protected void LinkButtonSelect_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenFieldTicketID");
Console.WriteLine(hd.Value);
Session["TicketID"] = hd.Value;
Server.Transfer("SpecficTicket.aspx", true);
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
str = Session["user"].ToString();
LinkButton asp = sender as LinkButton;
Label lb = (Label)asp.FindControl("label2");
Session["wishlist"] = lb.Text;
Response.Redirect("addwish.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
if (Session["user"] != null)
{
LinkButton asp = sender as LinkButton;
Label lb = (Label)asp.FindControl("Label1");
Session["pro"] = lb.Text;
Response.Redirect("view.aspx");
}
}
protected void LinkButtonDelete_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenField1");
Doctor doctor = db.Doctors.Single(a => a.Name == hd.Value);
db.Doctors.Remove(doctor);
db.SaveChanges();
FillData();
}
protected void LinkButtonDelete_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenFieldUsername");
Account acc = entities.Account.Single(ac => ac.username.Equals(hd.Value));
entities.Account.Remove(acc);
entities.SaveChanges();
FillData();
}
protected void linkButtonAnswer_Click(object sender, EventArgs e)
{
Session.Contents.Remove("QuestionId");
LinkButton lb = (LinkButton)sender;
HiddenField hd = (HiddenField)lb.FindControl("HiddenQuestionId");
int id = Convert.ToInt16(hd.Value);
Response.Redirect("Answer.aspx?Parameter=" + id);
}
/// <summary>
/// Method for deleting customers from database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DeleteButton_Click(object sender, EventArgs e)
{
LinkButton linkButton = (LinkButton)sender;
HiddenField hiddenId = (HiddenField)linkButton.FindControl("HiddenFieldCustomerId");
Guid guid = new Guid(hiddenId.Value);
Customer customer = DatabaseConnector.GetInstance().Database.Customers.Single(cu => cu.CustomerId.Equals(guid));
DatabaseConnector.GetInstance().Database.Customers.Remove(customer);
DatabaseConnector.GetInstance().Database.SaveChanges();
FillData();
}
protected void ToggleOrderDetailButton_Click(object sender, EventArgs e)
{
LinkButton link = (LinkButton)sender;
Panel panel = link.FindControl("OrderHistoryDetailPanel") as Panel;
if (panel != null)
{
panel.Visible = (!panel.Visible);
link.Text = panel.Visible ? "[-] hide order details" : "[+] show order details";
}
}
protected void txt_Naslov_Click(object sender, EventArgs e)
{
LinkButton _sender = (LinkButton)sender;
HiddenField hid = (HiddenField)_sender.FindControl("hf");
using (TriglavBL temp = new TriglavBL())
{
txt_odobreni.Visible = true;
txt_odobreni.Text = temp.getPostByID(Convert.ToInt32(hid.Value)).Sadrzaj;
_sender.BackColor = Color.AliceBlue;
}
}