protected void UpdateStatusControl_after_Cancel()
{
var Button1 = DetailsView2.FindControl("Button1") as Button;
Button1.Text = "Выбор";
GridView2.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptManager1.RegisterPostBackControl(Button1);
if (!IsPostBack)
{
var mode = Request.Params["Mode"];
switch (mode)
{
case "View":
DetailsView2.ChangeMode(DetailsViewMode.ReadOnly);
break;
case "Entry":
DetailsView2.ChangeMode(DetailsViewMode.Edit);
break;
default:
DetailsView2.ChangeMode(DetailsViewMode.Insert);
DetailsView2.FooterRow.Visible = false;
break;
}
DetailsView2Databinding();
}
lblEmailSuccess.Visible = lblSaveError.Visible = false;
}
private void DetailsView2Databinding()
{
string ProjectID = Request.Params["ProjectID"];
if (!string.IsNullOrEmpty(ProjectID))
{
Project.ProjectDataTable p = projectBLL.GetDataByID(ProjectID);
DetailsView2.DataSource = p;
GenerateJobSheet(p);
var fieldCount = DetailsView2.Fields.Count;
// Assumes there is one field after these four fields
var FieldColumns = new Dictionary <string, int>();
FieldColumns.Add("AddedAt", fieldCount - 5);
FieldColumns.Add("JobSheetSubmitted", fieldCount - 4);
FieldColumns.Add("FeeProposalSubmitted", fieldCount - 3);
FieldColumns.Add("AcceptanceOfServiceSubmitted", fieldCount - 2);
foreach (KeyValuePair <string, int> item in FieldColumns)
{
DetailsView2.Fields[item.Value].Visible = p.Rows[0][item.Key] != DBNull.Value;
}
DetailsView2.DataBind();
HasJobSheet = p.Rows[0]["JobSheetSubmitted"] != DBNull.Value;
JobSheetMandatoryMarker.Visible = !HasJobSheet;
}
DetailsView2.CssClass = DetailsView2.CurrentMode.ToString().ToLower();
}
protected void DeleteProject_Click(object sender, EventArgs e)
{
String projectId = ((Label)DetailsView2.FindControl("LBLProjectID")).Text;
projectBLL.DeleteProject(Int32.Parse(projectId));
Response.Redirect("map.aspx?delete=1");
}
//http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridviewrow.dataitem(v=vs.90).aspx
protected void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (GridView2.Rows.Count == 0)
{
DetailsView2.ChangeMode(DetailsViewMode.Insert);
}
// Check for a row in edit mode.
if (e.Row.RowState == DataControlRowState.Edit)
{
// Preselect the DropDownList control with the state value
// for the current row.
// Retrieve the underlying data item. In this example
// the underlying data item is a DataRowView object.
DataRowView rowView = (DataRowView)e.Row.DataItem;
// Retrieve the topic value for the current row.
String topic = rowView["Topic"].ToString();
// Retrieve the DropDownList control from the current row.
ListBox list = (ListBox)e.Row.FindControl("ListBox1");
// Find the ListItem object in the DropDownList control with the
// topic value and select the item.
ListItem item = list.Items.FindByText(topic);
list.SelectedIndex = list.Items.IndexOf(item);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["FULLNAME"] == null)
{
Response.Redirect("../userLogin.aspx");
}
DataSet ds;
string i = Request.QueryString["id"].ToString();
ds = new DataSet();
ds = ado.Get_DataSet("select o.OId BillNumber ,u.FirstName CustomerName ,o.OderDate from Users u join order_detail o on u.UId=o.UId where o.Oid=" + i);
DetailsView1.DataSource = ds;
DetailsView1.DataBind();
ds.Dispose();
ds = new DataSet();
ds = ado.Get_DataSet("select PName as Products,Quantity,Total Price from oderdetail where OId=" + i);
GridView1.DataSource = ds;
GridView1.DataBind();
ds.Dispose();
ds = new DataSet();
ds = ado.Get_DataSet("select p.Pmode PaymentMode,p.Cardnumber ,p.Xdate CardExpiredDate,s.shippingaddress ShippingAddress from paymentdetail p join shippingdetail s on p.OId=s.OId where p.OId=" + i);
DetailsView2.DataSource = ds;
DetailsView2.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
if (Request.QueryString["menu"] == "5")
{
DetailsView5.Focus();
this.DetailsView5.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "4")
{
DetailsView2.Focus();
this.DetailsView2.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "3")
{
DetailsView1.Focus();
this.DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "2")
{
DetailsView3.Focus();
this.DetailsView3.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "1")
{
DetailsView4.Focus();
this.DetailsView4.ChangeMode(DetailsViewMode.ReadOnly);
}
}
protected void DetailsView2_ChangeMode(object sender, GridViewEditEventArgs e)
{
// Get the selected row.
GridViewRow row = GridView2.SelectedRow;
// Check the row state. If the row is not in edit mode and is selected,
// exit edit mode. This ensures that the GridView control exits edit mode
// when a user selects a different row while the GridView control is in
// edit mode. Notice that the DataControlRowState enumeration is a flag
// enumeration, which means that you can combine values using bitwise
// operations.
if (row != null)
{
if (row.RowState != (DataControlRowState.Edit | DataControlRowState.Selected))
{
GridView2.EditIndex = -1;
DetailsView2.ChangeMode(DetailsViewMode.ReadOnly);
}
//if (row.RowState == DataControlRowState.Edit)
//{
//}
//else
//{
//DetailsView2.ChangeMode(DetailsViewMode.Insert);
//}
}
}
protected void IBtn_Add1_Click(object sender, ImageClickEventArgs e)
{
TextBox TB = (TextBox)DetailsView2.FindControl("TextBox3");
string Tagstr = "<Script> window.open('Calendar.aspx?ClientID=" + TB.ClientID.ToString() + "','SelectDate','resizable=yes,scrollbars=no,top=200,left=240,height=350,width=400,status=no,toolbar=no,menubar=no,location=no','');</script>";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", Tagstr, false);
}
protected void FillUserCardInfo(string username)
{
//bh = new BussinessHandler();
try
{
DataTable cd = bh.GetCardInfo(username);
cd.Columns.Add("username", typeof(System.String));
cd.Columns.Add("creditused", typeof(System.Decimal));
foreach (DataRow row in cd.Rows)
{
row["creditused"] = (decimal)row["creditlimit"] - (decimal)row["creditbalance"];
row["username"] = username;
}
percentage = (decimal)cd.Rows[0]["creditbalance"] / (decimal)cd.Rows[0]["creditlimit"] * 100;
Session["validity"] = cd.Rows[0]["validity"].ToString();
DetailsView1.DataSource = cd;
DetailsView1.DataBind();
DetailsView2.DataSource = cd;
DetailsView2.DataBind();
}
catch (Exception ex)
{
string errormessage = ex.Message;
Response.Write("<script>alert('Error Signing In :" + errormessage + "');</script>");
}
}
public void ReloadDDL()
{
DropDownList myDDL = (DropDownList)DetailsView2.FindControl("DropDownList2");
myDDL.Items.Clear();
SqlConnection Conn1 = new SqlConnection(Utility.DBconnection.connect_string(Session["DatabaseName"].ToString()));
Conn1.Close();
Conn1.Open();
SqlDataAdapter MyAdapter1 = new SqlDataAdapter();
SqlCommand MyCommand1 = new SqlCommand();
DataSet MyDataset1 = new DataSet();
MyCommand1.CommandText = "SELECT DISTINCT PriceID, PriceName, Unit FROM PriceAnalysis";
MyCommand1.Connection = Conn1;
MyAdapter1.SelectCommand = MyCommand1;
MyAdapter1.Fill(MyDataset1, "DDL");
MyDataset1.Tables["DDL"].Columns.Add("SUM");
foreach (DataRow i in MyDataset1.Tables["DDL"].Rows)
{
i["SUM"] = i["PriceName"] + "(" + i["Unit"].ToString().Trim() + ")";
}
myDDL.DataTextField = MyDataset1.Tables["DDL"].Columns[3].ToString();
myDDL.DataValueField = MyDataset1.Tables["DDL"].Columns[3].ToString();
myDDL.DataSource = MyDataset1.Tables["DDL"].DefaultView;
myDDL.DataBind();
myDDL.AppendDataBoundItems = true;
myDDL.Items.Insert(0, "請選擇");
}
void LinqDataSource1_Complete(object sender, SimpleDynamicDataSourceCompleteEventArgs e)
{
var newObject = (MyTestClass)e.NewObject;
DetailsView2.DataSource = new object[] { newObject };
DetailsView2.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int id;
int.TryParse(GridView1.SelectedRow.Cells[2].Text, out id);
myid = id;
Session["ID"] = id;
GridView2.DataSource = funcs.GetCoursesByInstructor(id);
GridView2.DataBind();
GridView2.EmptyDataText = "No Courses assigned to this Instructor";
DetailsView1.DataSource = funcs.GetAll(id);
DetailsView1.DataBind();
DetailsView1.EmptyDataText = "No Personal Details";
DetailsView2.DataSource = funcs.GetQouta(id);
DetailsView2.DataBind();
DetailsView2.EmptyDataText = "No Information Available";
st = funcs.InstructorStatus(id);
if (st == true)
{
lblStatus.Text = "This account is Active";
btnActivate.Text = "Deactivate Instructor Account";
btnActivate.CssClass = "btn btn-medium btn-red";
}
else
{
lblStatus.Text = "This account is Inactive";
btnActivate.Text = "Activate Instructor Account";
btnActivate.CssClass = "btn btn-medium btn-blue";
}
}
protected void DetailsView2_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
GridView2.Visible = true;
this.setGriview2(GridView1.SelectedValue.ToString());
DetailsView2.DataBind();
UpdatePanel3.Update();
}
protected void Button1_Click1(object sender, EventArgs e)
{
SqlDataSourceQuest.SelectParameters["IdQuest"].DefaultValue = ((Button)sender).CommandArgument.ToString();
SqlDataSourceQuest.DataBind();
DetailsView2.DataBind();
MultiView1.ActiveViewIndex = 2;
}
protected void GridView1_PageIndexChanged(object sender, EventArgs e)
{
XmlDataSource3.DataFile = DropDownList1.SelectedValue;
XmlDataSource1.DataFile = DropDownList1.SelectedValue;
GridView1.DataBind();
DetailsView2.DataBind();
GridView1.PageIndex = GridView1.PageIndex;
}
public void DropDownList2SelectedIndexChanged(object sender, EventArgs e)
{
using (var dc = new DataClasses1DataContext())
{
DetailsView2.DataSource = dc.Contacts.Where(c => c.ContactID.Equals(DropDownList2.SelectedValue)).ToList();
DetailsView2.DataBind();
}
}
private void RedirectToMap()
{
string lat = ((Label)DetailsView2.FindControl("LblLat")).Text;
string lng = ((Label)DetailsView2.FindControl("LblLng")).Text;
string projectcode = ((Label)DetailsView2.FindControl("LblCode")).Text;
Response.Redirect(string.Format("map.aspx?lat={0}&lng={1}&code={2}", lat, lng, projectcode), false);
}
protected void Button2_Click(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
canteen_master canteen = db.canteen_masters.Single(canteen_master => canteen_master.canteen_id == (int)Session["id"]);
canteen.wallet -= Int32.Parse(TextBox2.Text);
db.SubmitChanges();
DetailsView2.DataBind();
}
void LinqDataSource1_Complete(object sender, SimpleDynamicDataSourceCompleteEventArgs e)
{
var newObject = e.NewObject;
//var someInt = DataBinder.GetPropertyValue(newObject, "SomeInt");
DetailsView2.DataSource = new object[] { newObject };
DetailsView2.DataBind();
}
protected void Btn_AddNewMID_Click(object sender, EventArgs e)
{
Button myBtn = (Button)DetailsView2.FindControl("Button2");
TextBox myTB = (TextBox)DetailsView2.FindControl("TextBox4");
myBtn.Visible = true;
string Tagstr = "<Script> window.open('AddNewMItem.aspx','新增工料項目','resizable=yes,scrollbars=no,top=200,left=240,height=350,width=400,status=no,toolbar=no,menubar=no,location=no','');</script>";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", Tagstr, false);
}
protected void DetailsView2_DataBound(object sender, EventArgs e)
{
if (DetailsView2.CurrentMode == DetailsViewMode.Insert)
{
var lblLat = (Label)DetailsView2.FindControl("LblLat");
var lblLng = (Label)DetailsView2.FindControl("LblLng");
lblLat.Text = Request.Params["lat"];
lblLng.Text = Request.Params["lng"];
}
}
protected void SqlDataSourceQuest_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
if (e.Command.Parameters["@LastID"].Value.ToString() != "")
{
SqlDataSourceQuest.SelectParameters["IdQuest"].DefaultValue = e.Command.Parameters["@LastID"].Value.ToString();
SqlDataSourceQuest.DataBind();
DetailsView2.DataBind();
MultiView1.ActiveViewIndex = 2;
}
GridView1.DataBind();
}
protected void newResponseButton_Click(object sender, EventArgs e)
{
if (DetailsView2.CurrentMode == DetailsViewMode.Insert)
{
DetailsView2.ChangeMode(DetailsViewMode.ReadOnly);
}
else
{
DetailsView2.ChangeMode(DetailsViewMode.Insert);
}
}
protected void DetailsView2_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
XmlDocument xdoc = XmlDataSource4.GetXmlDocument();
XmlElement oFeed = xdoc.SelectSingleNode("/feeds/feed[@name='" + e.CommandArgument + "']") as XmlElement;
oFeed.Attributes["url"].Value = e.NewValues["url"].ToString();;
XmlDataSource4.Save();
e.Cancel = true;
DetailsView2.ChangeMode(DetailsViewMode.ReadOnly);
Response.Redirect(Request.RawUrl);
}
protected void BindSecretary(int clubId)
{
DBconnection obj = new DBconnection();
DataTable ds = new DataTable();
obj.SetCommandQry = "select * from View_BodMembers where designation='Secretary' and DistrictClubID='" + clubId + "' and year ='2016 - 2017'";
ds = obj.ExecuteTable();
imgSec = ds.Rows[0]["MemberImage"].ToString();
imgSecSpouse = ds.Rows[0]["SImage"].ToString();
DetailsView2.DataSource = ds;
DetailsView2.DataBind();
}
protected void UploadJobSheet_Click(object sender, EventArgs e)
{
Boolean jobSheetIncluded = FileJobSheet.PostedFile.ContentLength > 0;
String submittedBy = SubmittedBy.Text.Trim();
if ((!HasJobSheet && !jobSheetIncluded) || String.IsNullOrEmpty(submittedBy))
{
return;
}
Boolean originalFeeProposalIncluded = FileOriginalFeeProposal.PostedFile.ContentLength > 0;
Boolean acceptanceOfServiceIncluded = FileAcceptanceOfService.PostedFile.ContentLength > 0;
System.Collections.Generic.List <Attachment> attachments = new System.Collections.Generic.List <Attachment>();
if (jobSheetIncluded)
{
attachments.Add(new Attachment(FileJobSheet.PostedFile.InputStream, FileJobSheet.PostedFile.FileName));
}
if (originalFeeProposalIncluded)
{
attachments.Add(new Attachment(FileOriginalFeeProposal.PostedFile.InputStream, FileOriginalFeeProposal.PostedFile.FileName));
}
if (acceptanceOfServiceIncluded)
{
attachments.Add(new Attachment(FileAcceptanceOfService.PostedFile.InputStream, FileAcceptanceOfService.PostedFile.FileName));
}
String comments = ProjectDetailsComments.Text.Trim();
// Don't send email if no information has been provided
if (attachments.Count == 0 && String.IsNullOrEmpty(comments))
{
return;
}
String[] bodyParameters = { submittedBy, comments };
EmailService.SendEmail("jobSheet", null, bodyParameters, attachments);
// Update database with submission dates
String projectId = ((Label)DetailsView2.FindControl("LBLProjectID")).Text;
DateTime?now = DateTime.Now;
projectBLL.UpdateProjectSubmissions(Int32.Parse(projectId), jobSheetIncluded ? now : null, originalFeeProposalIncluded ? now : null, acceptanceOfServiceIncluded ? now : null);
DetailsView2Databinding();
lblEmailSuccess.Visible = true;
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
//выбор клиента
var DropDownList1 = DetailsView2.FindControl("DropDownList1") as DropDownList;
DropDownList1.SelectedValue = GridView2.SelectedDataKey.Value.ToString();
var Button1 = DetailsView2.FindControl("Button1") as Button;
Button1.Text = "Выбор";
GridView2.Visible = !GridView2.Visible;
}
protected void DDLRepuesto_PreRender(object sender, EventArgs e)
{
try
{
TextBox txtStock = (TextBox)DetailsView2.FindControl("txtStock");
DropDownList DDLRepuesto = (DropDownList)DetailsView2.FindControl("DDLRepuesto");
string repuesto = DDLRepuesto.SelectedValue;
txtStock.Text = r.stockRepuesto(int.Parse(repuesto));
}
catch (Exception ex)
{
}
}
protected void GridView4_SelectedIndexChanged(object sender, EventArgs e)
{
//выбор помещения
var DropDownList2 = DetailsView2.FindControl("DropDownList2") as DropDownList;
DropDownList2.SelectedValue = GridView4.SelectedDataKey.Value.ToString();
var Button3 = DetailsView2.FindControl("Button3") as Button;
Button3.Text = "Выбор";
GridView4.Visible = !GridView4.Visible;
}
