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