public List <SqlParameter> SetValuesInFacilityType(FacilityTypeInfo facilitytype) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (facilitytype.FacilityTypeId != 0) { sqlParam.Add(new SqlParameter("FacilityTypeId", facilitytype.FacilityTypeId)); } else { sqlParam.Add(new SqlParameter("CreatedDate", facilitytype.CreatedDate)); sqlParam.Add(new SqlParameter("CreatedBy", facilitytype.CreatedBy)); } sqlParam.Add(new SqlParameter("FacilityTypeName", facilitytype.FacilityTypeName)); Logger.Debug("FacilityType Controller FacilityTypeName:" + facilitytype.FacilityTypeName); sqlParam.Add(new SqlParameter("@IsActive", facilitytype.IsActive)); Logger.Debug("FacilityType Controller IsActive:" + facilitytype.IsActive); sqlParam.Add(new SqlParameter("UpdatedBy", facilitytype.UpdatedBy)); sqlParam.Add(new SqlParameter("UpdatedDate", facilitytype.UpdatedDate)); return(sqlParam); }
public FacilityTypeInfo GetFacilityTypeValues(DataRow dr) { FacilityTypeInfo retVal = new FacilityTypeInfo(); retVal.FacilityTypeId = Convert.ToInt32(dr["FacilityTypeId"]); retVal.FacilityTypeName = Convert.ToString(dr["FacilityTypeName"]); return(retVal); }
public FacilityTypeViewModel() { FriendlyMessage = new List <FriendlyMessage>(); Pager = new PaginationInfo(); FacilityType = new FacilityTypeInfo(); FacilityTypes = new List <FacilityTypeInfo>(); Filter = new FacilityTypeFilter(); }
public void Update(FacilityTypeInfo facilitytype) { _sqlHelper.ExecuteNonQuery(SetValuesInFacilityType(facilitytype), Storeprocedures.spUpdateFacilityType.ToString(), CommandType.StoredProcedure); }
public int Insert(FacilityTypeInfo facilitytype) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInFacilityType(facilitytype), Storeprocedures.spInsertFacilityType.ToString(), CommandType.StoredProcedure))); }