public void DeleteById(SeminarRegistration s)
{
if (s != null)
{
using (
StoredProcedure sp =
new StoredProcedure("DELETE FROM SeminarsRegistration WHERE ID=" + s.ID.ToString()))
{
sp.command.CommandType = CommandType.Text;
sp.ExecuteNonQuery();
}
}
}
public int Add(SeminarRegistration item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("SeminarsRegistration_AddItem"))
{
sp.Params.Add("@CompanyName", System.Data.SqlDbType.NVarChar, 255).Value = item.CompanyName;
sp.Params.Add("@FIO", System.Data.SqlDbType.NVarChar, 255).Value = item.FIO;
sp.Params.Add("@JobTitle", System.Data.SqlDbType.NVarChar, 255).Value = item.JobTitle;
sp.Params.Add("@JobAction", System.Data.SqlDbType.VarChar, 20).Value = item.JobAction;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
sp.Params.Add("@Site", System.Data.SqlDbType.NVarChar, 255).Value = item.Site;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public List<SeminarRegistration> GetAll()
{
List<SeminarRegistration> all = new List<SeminarRegistration>();
using (StoredProcedure sp = new StoredProcedure("SeminarsRegistration_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SeminarRegistration item = new SeminarRegistration(r);
all.Add(item);
}
}
}
}
return all;
}
public List<SeminarRegistration> GetByIds(string[] IDs)
{
List<SeminarRegistration> all = new List<SeminarRegistration>();
string s = string.Join(", ", IDs);
using (StoredProcedure sp = new StoredProcedure(string.Format("SELECT * FROM SeminarsRegistration WHERE ID in ({0})", s)))
{
sp.command.CommandType = CommandType.Text;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SeminarRegistration item = new SeminarRegistration(r);
all.Add(item);
}
}
}
}
return all;
}
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();
IsFormSubmitted = true;
}
catch (Exception exc)
{
IsFormSubmitted = false;
Logger.LogException(exc, "SeminarRegistrationControl.ascx");
lbError.Visible = true;
lbError.ForeColor = Color.Red;
lbError.Text = "Произошла внутрення ошибка. Обратитесь к администратору.";
}
}else
{
lbError.Visible = true;
lbError.ForeColor = Color.Red;
lbError.Text = "Просьба заполните все поля";
}
}
public List<SeminarRegistration> GetByType(int typeID, int emailType, string email)
{
List<SeminarRegistration> result = new List<SeminarRegistration>();
List<SeminarRegistration> all = new List<SeminarRegistration>();
using (StoredProcedure sp = new StoredProcedure("SeminarsRegistration_GetAll"))
{
sp.Params.Add("TypeID", SqlDbType.Int).Value = typeID;
sp.Params.Add("emailType", SqlDbType.Int).Value = emailType;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SeminarRegistration item = new SeminarRegistration(r);
all.Add(item);
}
}
}
}
if (!string.IsNullOrEmpty(email))
result = new List<SeminarRegistration>(all.Where(p => p.Email.ToLower() == email).ToArray());
else
{
result.AddRange(all);
}
return result;
}