public List<DownloadUserForm> GetByFileID(int id) { List<DownloadUserForm> res = new List<DownloadUserForm>(); using (StoredProcedure sp = new StoredProcedure(string.Format("SELECT * FROM DownloadUserForms WHERE FileID = @FileID"))) { sp.command.CommandType = CommandType.Text; sp.Params.Add("FileID", SqlDbType.NVarChar).Value = id; using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader()) { if (r != null) { while (r.Read()) { DownloadUserForm d = new DownloadUserForm(); d.Url = r.GetString(r.GetOrdinal("Url")); d.FileID = r.GetInt32(r.GetOrdinal("FileID")); d.ID = r.GetInt32(r.GetOrdinal("ID")); d.Email = r.GetString(r.GetOrdinal("Email")); d.FirstName = r.GetString(r.GetOrdinal("FirstName")); d.LastName = r.GetString(r.GetOrdinal("LastName")); res.Add(d); } } } } return res; }
public DownloadUserForm GetByIds(int id) { DownloadUserForm res = new DownloadUserForm(); using (StoredProcedure sp = new StoredProcedure(string.Format("SELECT * FROM DownloadUserForms WHERE ID = ", id))) { sp.command.CommandType = CommandType.Text; using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader()) { if (r != null) { while (r.Read()) { } } } } return res; }
public DownloadUserForm GetByGuid(string url) { DownloadUserForm res = new DownloadUserForm(); using (StoredProcedure sp = new StoredProcedure(string.Format("SELECT * FROM DownloadUserForms WHERE Url = @Url"))) { sp.command.CommandType = CommandType.Text; sp.Params.Add("Url", SqlDbType.NVarChar).Value = url; using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader()) { if (r != null) { while (r.Read()) { res.Url = r.GetString(r.GetOrdinal("Url")); res.FileID = r.GetInt32(r.GetOrdinal("FileID")); } } } } return res; }
protected void imgSubmit_Click(object sender, EventArgs e) { if (IsValid()) { //IsFormSubmitted = true; try { //SeminarRegistration sr = new SeminarRegistration //{ // CompanyName = txtCompanyName.Text, // Email = txtEmail.Text, // FIO = txtFio.Text, // JobAction = Convert.ToInt32(ddlFirmAction.SelectedValue), // JobTitle = txtJobTitle.Text, // TypeID = 1, // Site = txtSite.Text.ToLower().StartsWith("http://") ? txtSite.Text : "http://" + txtSite.Text //}; //SeminarRegistrations.Add(sr); // SendMail(); try { Session["email"] = txtEmail.Text; Session["firstname"] = txtFirstName.Text; Session["lastname"] = txtLastName.Text; } catch (Exception) { throw; } int id = 0; if (Session["id"] != null && !string.IsNullOrEmpty(Session["id"].ToString())) { try { id = Int32.Parse(Session["id"].ToString()); } catch (Exception) { id = -1; } } DownloadUserForm duf = new DownloadUserForm{Email=txtEmail.Text, FirstName = txtFirstName.Text, LastName = txtLastName.Text, FileID = id}; DownloadUserForms manager = new DownloadUserForms(); string urlGuid = manager.InsertForm(duf); IsFormSubmitted = true; hlLink.NavigateUrl = "~/DownloadFile.aspx?guid=" + urlGuid; phForm.Visible = false; phLink.Visible = true; Session.Remove("id"); } catch (Exception exc) { IsFormSubmitted = false; Logger.LogException(exc, "DownloadFileForm.ascx"); lbError.Visible = true; lbError.ForeColor = Color.Red; lbError.Text = "Произошла внутрення ошибка. Обратитесь к администратору."; } } else { lbError.Visible = true; lbError.ForeColor = Color.Red; lbError.Text = "Просьба заполните все поля"; } }
public string InsertForm(DownloadUserForm duf) { bool ifExists = false; using (StoredProcedure sp = new StoredProcedure("SELECT * FROM DownloadUserForms WHERE FileID=@FileID AND Email = @Email AND CreateDate > @CreateDate")) { sp.command.CommandType = CommandType.Text; sp.Params.Add("Email", SqlDbType.NVarChar).Value = duf.Email.ToLower(); sp.Params.Add("FileID", SqlDbType.Int).Value = duf.FileID; sp.Params.Add("CreateDate", SqlDbType.DateTime).Value = DateTime.Now.AddHours(-1); var reader = sp.ExecuteReader(); if (reader != null && reader.Read()) { ifExists = true; duf.Url = reader.GetString(reader.GetOrdinal("Url")); } } if (ifExists) return duf.Url; using ( StoredProcedure sp = new StoredProcedure(@"INSERT INTO DownloadUserForms(FirstName, LastName, Email, FileID, Url) VALUES(@FirstName, @LastName, @Email, @FileID, @Url)")) { sp.command.CommandType = CommandType.Text; sp.Params.Add("FirstName", SqlDbType.NVarChar).Value = duf.FirstName; sp.Params.Add("LastName", SqlDbType.NVarChar).Value = duf.LastName; sp.Params.Add("Email", SqlDbType.NVarChar).Value = duf.Email.ToLower(); sp.Params.Add("FileID", SqlDbType.Int).Value = duf.FileID; duf.Url = Guid.NewGuid().ToString(); sp.Params.Add("Url", SqlDbType.NVarChar).Value = duf.Url; sp.ExecuteNonQuery(); } return duf.Url; }