/// <summary>
/// Probably better use method with parameter has type Partner
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool Delete(PartnerSpecialization item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("PartnerSpecialization_DeleteByPartner"))
{
sp.Params.Add("@PartnerID", System.Data.SqlDbType.Int).Value = item.PartnerID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public int Add(PartnerSpecialization item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("PartnerSpecialization_AddSpecialization"))
{
sp.Params.Add("@PartnerID", System.Data.SqlDbType.NChar).Value = item.PartnerID;
sp.Params.Add("@SpecializationID", System.Data.SqlDbType.NVarChar).Value = item.SpecializationID;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public bool Update(PartnerSpecialization item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("PartnerSpecializations_UpdateItem"))
{
//sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
//sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
//sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar).Value = item.Name;
//sp.Params.Add("@Description", System.Data.SqlDbType.NVarChar).Value = item.Description;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
private void Save()
{
foreach (RepeaterItem item in RepeaterLang.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
PartnerEditor editor = (PartnerEditor)item.FindControl("editor");
editor.CityID = Int32.Parse(ddlCity.SelectedValue);
editor.RegionID = Int32.Parse(ddlRegion.SelectedValue);
editor.PartnerStatus = Int32.Parse(ddlStatus.SelectedValue);
editor.Telephone = txtTelephone.Text;
editor.Url = txtUrl.Text;
editor.SaveItem();
}
}
PartnerSpecializations ps = new PartnerSpecializations();
ps.Delete(this.GroupID);
for (int i = 0; i < chbSpecialization.Items.Count; i++)
{
if(chbSpecialization.Items[i].Selected)
{
PartnerSpecialization p = new PartnerSpecialization();
p.PartnerID = this.GroupID;
p.SpecializationID = Int32.Parse(chbSpecialization.Items[i].Value);
ps.Add(p);
}
}
GridViewItemsList.DataBind();
}