public IEnumerable <IdNameViewModel> GetModelByBrandIdName(int brandId) { var parameters = new List <SqlParameter>(); parameters.Add(sqlHelper.CreateParameter("@BrandId", brandId, DbType.Int32)); var dataReader = sqlHelper.GetDataReader("SELECT Id, Name From Models WHERE BrandId=@BrandId", CommandType.Text, parameters.ToArray(), out connection); try { var banTypes = new List <IdNameViewModel>(); while (dataReader.Read()) { var banType = new IdNameViewModel(); banType.Id = Convert.ToInt32(dataReader["Id"].ToString()); banType.Name = dataReader["Name"].ToString(); banTypes.Add(banType); } return(banTypes); } catch (Exception exp) { throw; } finally { dataReader.Close(); CloseConnection(); } }
public ActionResult DestroyGoverningStatuteAsync(int id) { IdNameViewModel obj = mainRepository.GetGoverningStatuteById(id); mainRepository.DeleteGoverningStatutes(obj); return(Json("")); }
public ActionResult DestroyRetainerAsync(int id) { IdNameViewModel obj = mainRepository.GetRetainerById(id); mainRepository.DeleteRetainer(obj); return(Json("")); }
public IEnumerable <IdNameViewModel> GetEngineCapacitiesByIdName() { var parameters = new List <SqlParameter>(); var dataReader = sqlHelper.GetDataReader("SELECT Id,Capacity From EngineCapacities ", CommandType.Text, null, out connection); try { var engineCapacities = new List <IdNameViewModel>(); while (dataReader.Read()) { var engineCapacitie = new IdNameViewModel(); engineCapacitie.Id = Convert.ToInt32(dataReader["Id"].ToString()); engineCapacitie.Name = dataReader["Capacity"].ToString(); engineCapacities.Add(engineCapacitie); } return(engineCapacities); } catch (Exception ex) { throw; } finally { dataReader.Close(); CloseConnection(); } }
public IEnumerable <IdNameViewModel> GetBanTypesByIdName() { var parameters = new List <SqlParameter>(); var dataReader = sqlHelper.GetDataReader("SELECT Id, Name From BanTypes ", CommandType.Text, null, out connection); try { var banTypes = new List <IdNameViewModel>(); while (dataReader.Read()) { var banType = new IdNameViewModel(); banType.Id = Convert.ToInt32(dataReader["Id"].ToString()); banType.Name = dataReader["Name"].ToString(); banTypes.Add(banType); } return(banTypes); } catch (Exception exp) { ; throw; } finally { dataReader.Close(); CloseConnection(); } }
public void InsertRetainer(IdNameViewModel ovm) { Retainer newRecord = new Retainer { RET_Id = ovm.Id, RET_Name = ovm.Name }; context.Retainers.Add(newRecord); context.SaveChanges(); }
public void InsertGoverningStatutes(IdNameViewModel ovm) { GoverningStatute newRecord = new GoverningStatute { GST_Id = ovm.Id, GST_Name = ovm.Name }; context.GoverningStatutes.Add(newRecord); context.SaveChanges(); }
public void InsertGoverningRegulation(IdNameViewModel ovm) { GoverningRegulation newRecord = new GoverningRegulation { GRE_Id = ovm.Id, GRE_Name = ovm.Name }; context.GoverningRegulations.Add(newRecord); context.SaveChanges(); }
public void InsertGoverningPolicy(IdNameViewModel ovm) { GoverningPolicy newRecord = new GoverningPolicy { GPO_Id = ovm.Id, GPO_Name = ovm.Name }; context.GoverningPolicies.Add(newRecord); context.SaveChanges(); }
public void DeleteRetainer(IdNameViewModel ovm) { Retainer newRecord = new Retainer { RET_Id = ovm.Id, RET_Name = ovm.Name }; context.Retainers.Attach(newRecord); context.Retainers.Remove(newRecord); context.SaveChanges(); }
public void UpdateGoverningStatutes(IdNameViewModel ovm) { GoverningStatute newRecord = new GoverningStatute { GST_Id = ovm.Id, GST_Name = ovm.Name }; context.GoverningStatutes.Attach(newRecord); context.Entry(newRecord).State = EntityState.Modified; context.SaveChanges(); }
public void DeleteGoverningStatutes(IdNameViewModel ovm) { GoverningStatute newRecord = new GoverningStatute { GST_Id = ovm.Id, GST_Name = ovm.Name }; context.GoverningStatutes.Attach(newRecord); context.GoverningStatutes.Remove(newRecord); context.SaveChanges(); }
public void DeleteGoverningRegulation(IdNameViewModel ovm) { GoverningRegulation newRecord = new GoverningRegulation { GRE_Id = ovm.Id, GRE_Name = ovm.Name }; context.GoverningRegulations.Attach(newRecord); context.GoverningRegulations.Remove(newRecord); context.SaveChanges(); }
public void UpdateGoverningPolicy(IdNameViewModel ovm) { GoverningPolicy newRecord = new GoverningPolicy { GPO_Id = ovm.Id, GPO_Name = ovm.Name }; context.GoverningPolicies.Attach(newRecord); context.Entry(newRecord).State = EntityState.Modified; context.SaveChanges(); }
public void DeleteGoverningPolicy(IdNameViewModel ovm) { GoverningPolicy newRecord = new GoverningPolicy { GPO_Id = ovm.Id, GPO_Name = ovm.Name }; context.GoverningPolicies.Attach(newRecord); context.GoverningPolicies.Remove(newRecord); context.SaveChanges(); }
public void UpdateRetainer(IdNameViewModel ovm) { Retainer newRecord = new Retainer { RET_Id = ovm.Id, RET_Name = ovm.Name }; context.Retainers.Attach(newRecord); context.Entry(newRecord).State = EntityState.Modified; context.SaveChanges(); }
public void UpdateGoverningRegulation(IdNameViewModel ovm) { GoverningRegulation newRecord = new GoverningRegulation { GRE_Id = ovm.Id, GRE_Name = ovm.Name }; context.GoverningRegulations.Attach(newRecord); context.Entry(newRecord).State = EntityState.Modified; context.SaveChanges(); }
public ActionResult DestroyRetainer([DataSourceRequest] DataSourceRequest request, IdNameViewModel obj) { mainRepository.DeleteRetainer(obj); return(Json(new[] { obj }.ToDataSourceResult(request, ModelState))); }
public ActionResult CreateGoverningStatute([DataSourceRequest] DataSourceRequest request, IdNameViewModel obj) { if (ModelState.IsValid) { mainRepository.InsertGoverningStatutes(obj); } return(Json(new[] { obj }.ToDataSourceResult(request, ModelState))); }
public ActionResult UpdateRetainer([DataSourceRequest] DataSourceRequest request, IdNameViewModel obj) { if (ModelState.IsValid) { mainRepository.UpdateRetainer(obj); } return(Json(new[] { obj }.ToDataSourceResult(request, ModelState))); }