protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { try { Session["ImagePath"] = ""; var fileUpload = (FileUpload)DetailsView1.FindControl("FileUpload1"); string fileToSave = String.Empty; if (fileUpload.HasFile == true) { fileToSave = Server.MapPath("~/Image/" + fileUpload.FileName); fileUpload.SaveAs(fileToSave); } else { return; } ObjectDataSource2.UpdateParameters["ImageFile"].DefaultValue = "~/Image/" + fileUpload.FileName; } catch (Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { TextBox txtClientId = DetailsView1.FindControl("txtClientID") as TextBox; TextBox txtClientName = DetailsView1.FindControl("txtClientName") as TextBox; TextBox txtClientDesc = DetailsView1.FindControl("txtClientDesc") as TextBox; int ClientID = Convert.ToInt32(txtClientId.Text.ToString()); string ClientName = txtClientName.Text.ToString(); string ClientDesc = txtClientDesc.Text.ToString(); Debug.WriteLine(""); Debug.WriteLine("Data From Grid:"); Debug.WriteLine("EnvType ID: " + ClientID); Debug.WriteLine("EnvType Title: " + ClientName); Debug.WriteLine("EnvType Desc: " + ClientDesc); DatabaseConnectivity dbcon = new DatabaseConnectivity(); int ResultQuery = dbcon.setEnvType(ClientID, ClientName, ClientDesc); //Console.WriteLine("<script>alert(" + ResultQuery + "record has been updated." + ")</script>"); //ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery + "record has been updated." + ")</script>", true); //ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery +")</script>", true); DetailsView1.Visible = false; this.Page_Load(null, null); //UpdatePanel1.Update(); //UpdatePanel1.Update(); //DetailsView1.Style.Add("display", "none"); }
protected void btnSearchOrderNumber_Click(object sender, EventArgs e) { TextBox tbOrderNumber = DetailsView1.FindControl("tbOrderNumber") as TextBox; Broker.DataAccess.Order o = Broker.DataAccess.Order.GetByOrderNumber(tbOrderNumber.Text); TextBox tbClientEMBG = DetailsView1.FindControl("tbClientEMBG") as TextBox; TextBox tbClientName = DetailsView1.FindControl("tbClientName") as TextBox; TextBox tbOwnerEMBG = DetailsView1.FindControl("tbOwnerEMBG") as TextBox; TextBox tbOwnerName = DetailsView1.FindControl("tbOwnerName") as TextBox; if (o != null) { OrderID = o.ID; ClientID = o.ClientID; OwnerID = o.OwnerID; tbClientEMBG.Text = o.Client.EMBG; tbClientEMBG.ReadOnly = true; tbClientName.Text = o.Client.Name; tbClientName.ReadOnly = true; tbOwnerEMBG.Text = o.Client1.EMBG; tbOwnerEMBG.ReadOnly = true; tbOwnerName.Text = o.Client1.Name; tbOwnerName.ReadOnly = true; } else { tbClientEMBG.Text = string.Empty; tbClientName.Text = string.Empty; tbOwnerEMBG.Text = string.Empty; tbOwnerName.Text = string.Empty; } }
protected void btnAddPolicyToList_Click(object sender, EventArgs e) { try { TextBox tbPolicyNumberToList = (TextBox)DetailsView1.FindControl("tbPolicyNumberToList"); DropDownList ddlInsuranceCompanies = (DropDownList)DetailsView1.FindControl("ddlInsuranceCompanies"); int icID = Convert.ToInt32(ddlInsuranceCompanies.SelectedValue); InsuranceCompany ic = InsuranceCompany.Get(icID); PolicyItem pi = PolicyItem.GetByNumberAndInsuranceCompany(tbPolicyNumberToList.Text, icID); if (pi != null) { GridView gvNewPolicies = (GridView)DetailsView1.FindControl("gvNewPolicies"); List <FactureInfo> lastFactureInfos = listFactureInfos; FactureInfo fi = listFactureInfos.Where(c => c.PolicyNumber == tbPolicyNumberToList.Text).SingleOrDefault(); if (fi != null) { RegisterStartupScript("myAlert", "<script>alert('Полисата постои во листата!')</script>"); return; } FactureInfo newFactureInfo = new FactureInfo(); newFactureInfo.PolicyNumber = tbPolicyNumberToList.Text; newFactureInfo.IsForFacturing = true; newFactureInfo.ID = pi.ID; lastFactureInfos.Add(newFactureInfo); listFactureInfos = lastFactureInfos; gvNewPolicies.DataSource = lastFactureInfos; gvNewPolicies.DataBind(); } else { RegisterStartupScript("myAlert", "<script>alert('Не постои полиса со избраниот број!')</script>"); } } catch { RegisterStartupScript("myAlert", "<script>alert('Грешка!')</script>"); } }
protected void dsRequestDetails_Inserting(object sender, SqlDataSourceCommandEventArgs e) { //find the upload control FileUpload screenCap = (FileUpload)DetailsView1.FindControl("screenCap"); //make sure there is a file if (screenCap.HasFile) { //get filename string fileName = screenCap.FileName; //get the extension string ext = fileName.Substring(fileName.LastIndexOf(".")); //generate a new file name string newImageName = Guid.NewGuid().ToString(); //plug the extension back in newImageName += ext; //save the photo to the images folder screenCap.SaveAs(Server.MapPath("~/screenImages/" + newImageName)); //save the photo name to the DB e.Command.Parameters["@ReqScreenCapture"].Value = newImageName; } else { e.Command.Parameters["@ReqScreenCapture"].Value = "no_image.jpg"; //no file uploaded } }
protected void ddlInsuranceCompanyIndexChanged(object sender, EventArgs e) { DropDownList ddlInsuranceSubTypes = DetailsView1.FindControl("ddlInsuranceSubTypes") as DropDownList; FakeBinder.SimulateBindingContext(this.Page, ddlInsuranceSubTypes); ddlInsuranceSubTypes.DataBind(); }
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e) { string name = ((TextBox)DetailsView1.FindControl("txtName")).Text; string image; if (((FileUpload)DetailsView1.FindControl("fuImage")).HasFile) { image = ((FileUpload)DetailsView1.FindControl("fuImage")).FileName.ToString(); ((FileUpload)DetailsView1.FindControl("fuImage")).SaveAs((Server.MapPath("Images/ProductImages/") + ((FileUpload)DetailsView1.FindControl("fuImage")).FileName)); } else { image = "NULL"; } double price = Convert.ToDouble(((TextBox)DetailsView1.FindControl("txtPrice")).Text); string description = ((TextBox)DetailsView1.FindControl("txtDescription")).Text; int idcat = Convert.ToInt32(((DropDownList)DetailsView1.FindControl("ddlCat")).SelectedIndex + 1); int idroom = Convert.ToInt32(((DropDownList)DetailsView1.FindControl("ddlRoom")).SelectedIndex + 1); int inventory = Convert.ToInt32(((TextBox)DetailsView1.FindControl("txtInventory")).Text); bool featured = Convert.ToBoolean(((CheckBox)DetailsView1.FindControl("cbFeaturedEdit")).Checked); bool taxable = Convert.ToBoolean(((CheckBox)DetailsView1.FindControl("cbTaxableEdit")).Checked); DetailsView1.DataBind(); string query = "INSERT INTO PRODUCTS (NAME, IMAGE, PRICE, DESCRIPTION, IDCAT, IDROOM, FEATURED, TAXABLE, INVENTORY) values (@name, @image, @price, @description, @idcat, @idroom, @featured, @taxable, @inventory)"; using (SqlConnection cnn = new SqlConnection(myConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@image", image); cmd.Parameters.AddWithValue("@price", price); cmd.Parameters.AddWithValue("@description", description); cmd.Parameters.AddWithValue("@idcat", idcat); cmd.Parameters.AddWithValue("@idroom", idroom); cmd.Parameters.AddWithValue("@featured", featured); cmd.Parameters.AddWithValue("@taxable", taxable); cmd.Parameters.AddWithValue("@inventory", inventory); try { cnn.Open(); cmd.ExecuteNonQuery(); Response.Write("<script language='javascript'>alert('Product added to the Database.');</script>"); } catch (SqlException ex) { //Response.Write("<script language='javascript'>alert('Error has occured.');</script>"); System.Diagnostics.Debug.WriteLine(ex.Message); } finally { cnn.Close(); UpdateGridView(); } } } }
protected void DDLRut_PreRender(object sender, EventArgs e) { TextBox txtPatente = (TextBox)DetailsView1.FindControl("txtPatente"); DropDownList DDLPatente = (DropDownList)DetailsView1.FindControl("DDLPatente"); txtPatente.Text = DDLPatente.Text; }
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { using (Entity entity = new Entity()) { var goodExperience = entity.GoodExperience.Find(Convert.ToInt32(DetailsView1.DataKey.Value)); var CheckBoxList_State = ((CheckBoxList)DetailsView1.FindControl("CheckBoxList_State")); goodExperience.State = 0; foreach (ListItem item in CheckBoxList_State.Items) { if (item.Selected) { goodExperience.State = goodExperience.State | Convert.ToInt32(item.Value); } } if (e.NewValues["OrderBy"] != null) { goodExperience.OrderBy = Convert.ToInt32(e.NewValues["OrderBy"]); } if ((goodExperience.State & 2) > 0 && (goodExperience.State & 1) > 0) { goodExperience.State--; } entity.SaveChanges(); } Response.Redirect("GoodExperienceDetail.aspx?goodExperienceID=" + DetailsView1.DataKey.Value); }
private void CurrentMode_Init() { var DropDownList_GoodGategoryID = ((DropDownList)DetailsView1.FindControl("DropDownList_GoodGategoryID")); if (DropDownList_GoodGategoryID != null) { DropDownList_GoodGategoryID.DataSource = goodGategoryBLL.GetGoodGategory(o => o.State == 1).Select(o => new { Name = o.Name, GoodGategoryID = o.GoodGategoryID }); DropDownList_GoodGategoryID.DataBind(); if (good != null) { DropDownList_GoodGategoryID.SelectedValue = good.GoodGategoryID.ToString(); } } var HiddenField1 = (HiddenField)DetailsView1.FindControl("HiddenField1"); if (HiddenField1 != null && good != null) { HiddenField1.Value = good.Detail; } var CheckBoxList_State = ((CheckBoxList)DetailsView1.FindControl("CheckBoxList_State")); if (CheckBoxList_State != null && good != null) { if ((good.State & 1) > 0) { CheckBoxList_State.Items[0].Selected = true; } if ((good.State & 2) > 0) { CheckBoxList_State.Items[1].Selected = true; } if ((good.State & 4) > 0) { CheckBoxList_State.Items[2].Selected = true; } if ((good.State & 8) > 0) { CheckBoxList_State.Items[3].Selected = true; } if ((good.State & 16) > 0) { CheckBoxList_State.Items[4].Selected = true; } if ((good.State & 32) > 0) { CheckBoxList_State.Items[5].Selected = true; } if ((good.State & 64) > 0) { CheckBoxList_State.Items[6].Selected = true; } } }
protected void AttachmentsDetailsView_ItemInserting(object sender, DetailsViewInsertEventArgs e) { // Entities ctx = new Entities(); byte[] myFileBytes = null; FileUpload myUpload = (FileUpload)DetailsView1.FindControl("FileUpload1"); // Need if not post back if (myUpload.HasFile) { try { myFileBytes = myUpload.FileBytes; e.Values["REQUEST_ID"] = Convert.ToDecimal(Session["ccREQUESTID"]); e.Values["DATA"] = myFileBytes; e.Values["FILE_NAME"] = Path.GetFileName(myUpload.PostedFile.FileName); e.Values["DATE_ATTACHED"] = DateTime.Now; Label3.Text = "Successfully Attached. You may attach another or select button below"; } catch (Exception ex) { Label3.Text = Resources.errortestImg_001 + ex.Message.ToString(); e.Cancel = true; } } else { Label3.Text = "You have not specified a file."; e.Cancel = true; } }
protected void ObjectDataSource1_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { try { Session["ImagePath"] = ""; var fileUpload1 = (FileUpload)DetailsView1.FindControl("FileUpload2"); string fileToSave = String.Empty; if (fileUpload1.HasFile == true) { fileToSave = Server.MapPath("~/Image/" + fileUpload1.FileName); fileUpload1.SaveAs(fileToSave); } else { return; } Session["ImagePath"] = "~/Image/" + fileUpload1.FileName; } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
protected void ddlDocumentTypes_selectedChanged(object sender, EventArgs e) { TextBox tbCode = DetailsView1.FindControl("tbCode") as TextBox; DropDownList ddlDocumentTypes = (DropDownList)sender; tbCode.Text = CodeGenerator.DocumentSubTypeCodeGenerator(int.Parse(ddlDocumentTypes.SelectedValue)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] != null) { Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源 sql_String.ConnectionString = sql_String.sql_char; //连接字符串 DropDownList dr1 = new DropDownList(); dr1 = (DropDownList)DetailsView1.FindControl("caName"); //AccessDataSource ads = new AccessDataSource(); //ads.DataFile = "~/date/blog_Data.mdb"; sql_String.SelectCommand = "SELECT * FROM blogCategory "; DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty); dr1.Items.Clear(); for (int i = 0; i < dv.Count; i++) { ListItem li = new ListItem(dv[i]["ca_name"].ToString(), dv[i]["ca_id"].ToString()); //li.Text = dv[i]["ca_name"].ToString(); //li.Value = dv[i]["ca_id"].ToString(); ca_id = dv[i]["ca_id"].ToString(); dr1.Items.Add(li); ca_i++; } } else { Response.Redirect("_boke.aspx"); } }
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e) { CheckBox chb = (CheckBox)DetailsView1.FindControl("Man"); e.Values["TSex"] = chb.Checked ? "男" : "女"; e.Values["TPwd"] = Common.Getmd5("123"); }
protected void DetailsView1_DataBound(object sender, EventArgs e) { HiddenField hidType = DetailsView1.FindControl("hidClientType") as HiddenField; DropDownList dropType = DetailsView1.FindControl("dropClientType") as DropDownList; dropType.SelectedValue = hidType.Value; }
protected void IBtn_Update1_Click(object sender, EventArgs e) { TextBox TB = (TextBox)DetailsView1.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 DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { FileUpload file = (FileUpload)DetailsView1.FindControl("FileUpload1"); if (file.HasFile) { Label eid = (Label)DetailsView1.FindControl("Label1"); String id = eid.Text.Trim();//trim去掉首尾空格 string filename = file.FileName; string path = Server.MapPath("~/img/") + filename; file.SaveAs(path); SqlDataSource1.UpdateParameters["Epic"].DefaultValue = "~/img/" + filename; TextBox epic = (TextBox)DetailsView1.FindControl("TextBox1"); epic.Text = SqlDataSource1.UpdateParameters["Epic"].DefaultValue; //连接数据库 String cnstr = @"Data Source=(LocalDB)\MSSQLLocalDB;" + "AttachDbFilename=|DataDirectory|Database1.mdf;" + "Integrated Security=True"; SqlConnection conn = new SqlConnection(cnstr); //打开数据库连接 conn.Open(); //传入sql语句 String sql = "update Equipment set Epic='" + epic.Text + "' where Eid='" + id + "'"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); } else { SqlDataSource1.UpdateParameters["Eid"].DefaultValue = ""; } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { //Response.Write("<script language='javascript'>confirm('Are you sure?')</script>"); string query = "DELETE FROM PRODUCTS WHERE ID = " + (((Label)DetailsView1.FindControl("lblId")).Text.ToString()); using (SqlConnection cnn = new SqlConnection(myConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = query; try { string image = Request.MapPath("Images/ProductImages/" + ((Label)DetailsView1.FindControl("lblImage")).Text); cnn.Open(); cmd.ExecuteNonQuery(); Response.Write("<script language='javascript'>alert('Product removed from Database.')</script>"); System.IO.File.Delete(image); DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); } catch (Exception er) { Response.Write("<script language='javascript'>alert('Error has occured.')</script>"); System.Diagnostics.Debug.WriteLine(er.Message); } finally { cnn.Close(); UpdateGridView(); DetailsView1.DataBind(); } } } }
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e) { FileUpload file = (FileUpload)DetailsView1.FindControl("FileUpload2"); if (file.HasFile) { string filename = file.FileName; string path = Server.MapPath("~/img/") + filename; file.SaveAs(path); SqlDataSource1.InsertParameters["Epic"].DefaultValue = "~/img/" + filename; //连接数据库 String cnstr = @"Data Source=(LocalDB)\MSSQLLocalDB;" + "AttachDbFilename=|DataDirectory|Database1.mdf;" + "Integrated Security=True"; SqlConnection conn = new SqlConnection(cnstr); //打开数据库连接 conn.Open(); //传入sql语句 String sql = "insert into Equipment(Eid,Ename,Esize,Epic,Eprice,Edate,Eplace,manager)" + "values('" + SqlDataSource1.InsertParameters["Eid"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Ename"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Esize"].DefaultValue + "'," + "'" + SqlDataSource1.InsertParameters["Epic"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Eprice"].DefaultValue + "','" + SqlDataSource1.InsertParameters["Edate"].DefaultValue + "'," + "'" + SqlDataSource1.InsertParameters["Eplace"].DefaultValue + "','" + SqlDataSource1.InsertParameters["manager"].DefaultValue + "')"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Close(); } else { SqlDataSource1.UpdateParameters["Eid"].DefaultValue = ""; } }
protected void dvDataSource_Inserted(object sender, ObjectDataSourceStatusEventArgs e) { object o = e.ReturnValue; IncomingFacture inFac = (IncomingFacture)o; if (inFac.IncomingFactureType.Code == IncomingFactureType.ZA_POLISI) { GridView gvNewPolicies = (GridView)DetailsView1.FindControl("gvNewPolicies"); List <FactureInfo> lastFactureInfos = listFactureInfos; GridViewRowCollection displayedRows = gvNewPolicies.Rows; foreach (GridViewRow gvRow in displayedRows) { CheckBox cbIsForFacturing = gvRow.FindControl("cbIsForFacturing") as CheckBox; int factureInfoID = Convert.ToInt32(gvNewPolicies.DataKeys[gvRow.RowIndex].Value); FactureInfo fi = lastFactureInfos.Where(f => f.ID == factureInfoID).SingleOrDefault(); fi.IsForFacturing = cbIsForFacturing.Checked; } listFactureInfos = lastFactureInfos; List <FactureInfo> listFactureInfo = listFactureInfos.Where(c => c.IsForFacturing == true).ToList(); foreach (FactureInfo fi in listFactureInfo) { IncomingFacturePolicyItem ifpi = new IncomingFacturePolicyItem(); ifpi.IncomingFactureID = inFac.ID; ifpi.PolicyItemID = fi.ID; ifpi.IsActive = true; ifpi.Insert(); PolicyItem pi = PolicyItem.Get(fi.ID); pi.PolicyIncomeFactureStatusID = PolicyIncomeFactureStatuse.GetByCode(PolicyIncomeFactureStatuse.CELOSNO_FAKTURIRANA).ID; PolicyItem.Table.Context.SubmitChanges(); } } }
protected void dvDataSource_Inserted(object sender, ObjectDataSourceStatusEventArgs e) { Packet p = (Packet)e.ReturnValue; List <int> new_InsuranceSubTypeID = new List <int>(); List <PacketsInsuranceSubType> new_values = new List <PacketsInsuranceSubType>(); int packetID = p.ID; CheckBoxList cbl = (CheckBoxList)DetailsView1.FindControl("InsuranceSubTypes"); foreach (ListItem item in cbl.Items) { if (item.Selected == true) { new_InsuranceSubTypeID.Add(Convert.ToInt32(item.Value)); } } foreach (int istID in new_InsuranceSubTypeID) { PacketsInsuranceSubType pist = new PacketsInsuranceSubType(); pist.InsuranceSubTypeID = istID; pist.PacketID = packetID; pist.BrokeragePecentageForPrivates = PacketsInsuranceSubType.GetDefaultBrokerageForPrivates(p.InsuranceCompanyID, istID); pist.BrokeragePecentageForLaws = PacketsInsuranceSubType.GetDefaultBrokerageForLaws(p.InsuranceCompanyID, istID); new_values.Add(pist); } PacketsInsuranceSubType.Table.InsertAllOnSubmit(new_values); PacketsInsuranceSubType.Table.Context.SubmitChanges(); }
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e) { try { var fileUpload = (FileUpload)DetailsView1.FindControl("FileUpload2"); string fileToSave = String.Empty; if (fileUpload.HasFile == true) { fileToSave = Server.MapPath("~/Image/" + fileUpload.FileName); fileUpload.SaveAs(fileToSave); } else { return; } SqlDataSource4.InsertParameters["ImageFile"].DefaultValue = "~/Image/" + fileUpload.FileName; } catch (Exception ex) { throw ex; } }
protected void DetailsView1_DataBound(object sender, EventArgs e) { int packetID; if (GXGridView1.SelectedDataKey != null) { packetID = Convert.ToInt32(GXGridView1.SelectedDataKey.Value); } else { return; } List <PacketsInsuranceSubType> my_list = PacketsInsuranceSubType.GetByPacket(packetID); CheckBoxList cbl = (CheckBoxList)DetailsView1.FindControl("InsuranceSubTypes"); foreach (ListItem item in cbl.Items) { foreach (var some in my_list) { if (item.Value == some.InsuranceSubTypeID.ToString()) { item.Selected = true; } } } }
protected void deleteItem1(object sender, DetailsViewDeleteEventArgs e) { Label id = DetailsView1.FindControl("lbl_userId") as Label; ClientHelper.deleteClientByID(int.Parse(id.Text)); Response.Redirect("logIn.aspx"); }
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { int packetID = Convert.ToInt32(e.Keys["ID"]); List <PacketsInsuranceSubType> old_values = PacketsInsuranceSubType.GetByPacket(packetID); List <int> new_InsuranceSubTypsID = new List <int>(); List <PacketsInsuranceSubType> new_values = new List <PacketsInsuranceSubType>(); CheckBoxList cbl = (CheckBoxList)DetailsView1.FindControl("InsuranceSubTypes"); foreach (ListItem item in cbl.Items) { if (item.Selected == true) { new_InsuranceSubTypsID.Add(Convert.ToInt32(item.Value)); } } foreach (int iID in new_InsuranceSubTypsID) { PacketsInsuranceSubType pist = new PacketsInsuranceSubType(); pist.PacketID = packetID; pist.InsuranceSubTypeID = iID; new_values.Add(pist); } PacketsInsuranceSubType.Table.DeleteAllOnSubmit(old_values); PacketsInsuranceSubType.Table.Context.SubmitChanges(); PacketsInsuranceSubType.Table.InsertAllOnSubmit(new_values); PacketsInsuranceSubType.Table.Context.SubmitChanges(); }
protected void EmailCustomValidation_ServerValidate(object source, ServerValidateEventArgs args) { string CS = ConfigurationManager.ConnectionStrings["TuteDB"].ConnectionString; try { string newemail = ((TextBox)DetailsView1.FindControl("txtEmail")).Text; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("spValidateEmail", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Email", newemail); con.Open(); bool validemail = Convert.ToBoolean(cmd.ExecuteScalar()); if (!validemail) { args.IsValid = false; } else { args.IsValid = true; } } } catch (Exception exc) { lblError.Text = "Email Error " + exc.Message; } }
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { e.NewValues.Add("CreatedOn", Convert.ToString(DateTime.Now)); e.NewValues.Add("IsDeleted", false); FileUpload fu = (FileUpload)DetailsView1.FindControl("FileUpload1"); if (fu.HasFile) { string UploadFolderRelativePath = "~/Uploads/"; string UploadFolderAbsolutePath = Server.MapPath(UploadFolderRelativePath); string FullFilePath = string.Format("{0}/{1}", UploadFolderAbsolutePath, fu.FileName); string FileRelativePath = string.Format("{0}/{1}", UploadFolderRelativePath, fu.FileName); fu.SaveAs(FullFilePath); e.NewValues.Add("ImagePath", FileRelativePath); } else if (!fu.HasFile) { HiddenField link = (HiddenField)DetailsView1.FindControl("TmageReload"); e.NewValues.Add("ImagePath", link.Value); } }
protected void DetailsView1_ItemCreated(object sender, EventArgs e) { TimeSpan startTime = new TimeSpan(7, 0, 0); TimeSpan increment = new TimeSpan(1, 0, 0); TimeSpan[] timeList = new TimeSpan[14]; //populate array with times incremented by an hour for (int i = 0; i <= 13; i++) { timeList[i] = startTime; startTime = startTime.Add(increment); } DropDownList ddl = DetailsView1.FindControl("ddlStart") as DropDownList; if (ddl != null) { ddl.DataSource = timeList; } DropDownList ddl2 = DetailsView1.FindControl("ddlEnd") as DropDownList; if (ddl2 != null) { ddl2.DataSource = timeList; } }
protected void btnSave_Click(object sender, EventArgs e) { TextBox txtUserID = DetailsView1.FindControl("txtUserID") as TextBox; TextBox txtUserName = DetailsView1.FindControl("txtUserName") as TextBox; DropDownList dropUserRole = DetailsView1.FindControl("dropUserRole") as DropDownList; TextBox txtUserStatus = DetailsView1.FindControl("txtUserStatus") as TextBox; TextBox txtUserLoginDate = DetailsView1.FindControl("txtUserLoginDate") as TextBox; TextBox txtWrongAttempts = DetailsView1.FindControl("txtWrongAttempts") as TextBox; int userID = Convert.ToInt32(txtUserID.Text.ToString()); string userName = txtUserName.Text.ToString(); string userRole = dropUserRole.SelectedValue.ToString(); string userStatus = txtUserStatus.Text.ToString(); string userLoginDate = txtUserLoginDate.Text.ToString(); string wrongAttempts = txtWrongAttempts.Text.ToString(); Debug.WriteLine(""); Debug.WriteLine("Data From Grid:"); Debug.WriteLine("User ID: " + userID); Debug.WriteLine("User Name: " + userName); Debug.WriteLine("User Type: " + userRole); Debug.WriteLine("User Status: " + userStatus); Debug.WriteLine("User Login Date: " + userLoginDate); Debug.WriteLine("User Wrong Attempts: " + wrongAttempts); DatabaseConnectivity dbcon = new DatabaseConnectivity(); int res = dbcon.setAUser(userID, userName, userRole, userStatus, userLoginDate, wrongAttempts); //nt ResultQuery = dbcon.setAClient(userID, userName, userRole, userStatus, userLoginDate, wrongAttempts); //Console.WriteLine("<script>alert(" + ResultQuery + "record has been updated." + ")</script>"); //ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery + "record has been updated." + ")</script>", true); //ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery +")</script>", true); DetailsView1.Visible = false; //DetailsView1.Style.Add("display", "none"); _BindService(); }