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)));
}
