How to convert Bytes to Size in Javascript

 Javascript

function readableBytes(bytes) {

    if(typeof(bytes) == "undefined" || bytes == 0 || bytes == '') return '0 Bytes';

    var i = Math.floor(Math.log(bytes) / Math.log(1024)),

    sizes = ['B', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB'];

    return (bytes / Math.pow(1024, i)).toFixed(2) * 1 + ' ' + sizes[i];

}

How to convert Json String Value to object

using Newtonsoft.Json.Linq;

Method 1

JArray jArray = JArray.Parse(jsonStringValue);
JObject jObject = (JObject)jArray[0];
var jSonValue = jObject.ToString();

Method 2

var object = JsonConvert.DeserializeObject<dynamic>(jsonDataStringValue);

Linq Conditional check in where clause

In Linq where clause, include parameter when a value is not NULL, else return the query result.

var qryList = from T1 in Tabel1
              join T2 in Tabel2
              on T1.Id equals T2.Id into grp
              from x in grp
              where T1.Id == ParameterID
              && (!string.IsNullOrEmpty(ParameterName) ? 

                  T1.Name == ParameterName : true)
              select T1.Name;

How to pass parameter to partial view and capture the value(s) in partial view

Main View

Html.RenderPartial("_PartialViewName", new ViewDataDictionary(ViewData){ { "one", Model.One }, { "two", Model.Two } });

-------------------------- 

Controller

public ActionResult _PartialViewName()

{

return PartialView();

}

--------------------------

How to get parameter values in partial view

@{

    var one = (string)ViewData["one"];

    var two = (string)ViewData["two"];

}

Add new Column in Existing Table

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS         

WHERE TABLE_NAME = 'tblName' AND COLUMN_NAME = 'ColumnName')         

BEGIN         

  ALTER TABLE tblName ADD ColumnName nvarchar(60)        

END

Generic Repository Pattern & Unit of Work Repository Pattern Using (DI)

HomeController:-

public class HomeController : Controller

{

   private IUnitOfWork _unitOfWork;

   public HomeController(IUnitOfWork unitOfWork)

   {

       _unitOfWork = unitOfWork;

   }

   public ActionResult Index()

   {

Category modelList = _unitOfWork.RepositoryFor<Category>().GetById(5);

var objResult = _unitOfWork.RepositoryFor<Category>().GetAll();

return View(modelList);

   }

}

IUnitOfWork:-

public interface IUnitOfWork

{        

    IGenericRepository<T> RepositoryFor<T>() where T : class;

    void SaveChanges();

}

UnitOfWork:-

public class UnitOfWork : IUnitOfWork, System.IDisposable

{

     private readonly NORTHWNDEntities _context;

     public UnitOfWork(NORTHWNDEntities context)

     {

         _context = context;

     }

     public IGenericRepository<T> RepositoryFor<T>() where T : class

     {

         return new GenericRepository<T>(_context);

     }

     public void SaveChanges()

     {

         _context.SaveChanges();

     }

     private bool disposed = false;

     protected virtual void Dispose(bool disposing)
     {
         if (!this.disposed)
         {
            if (disposing)
            {
                _context.Dispose();
            }
         }
         this.disposed = true;
     }
     public void Dispose()
     {
         Dispose(true);
         System.GC.SuppressFinalize(this);
     }
 }



IGenericRepository:-
public interface IGenericRepository<TEntity>
{
   TEntity GetById(object id);
   TEntity GetFirstOrDefault(
   void Insert(TEntity entity);
   void Update(TEntity entity);
   void Delete(object id);
   List<TEntity> GetAll();
}



GenericRepository:-
public class GenericRepository<TEntity> : IGenericRepository<TEntity> where 
TEntity : class
{
    private DbContext context;
    private DbSet<TEntity> dbSet;
    public GenericRepository(DbContext context)
    {
        this.context = context;
        this.dbSet = context.Set<TEntity>();
    }  
    public virtual TEntity GetById(object id)
    {
        return dbSet.Find(id);
    }

    public virtual TEntity GetFirstOrDefault(Expression<Func<TEntity, bool>>   
filter = null, params Expression<Func<TEntity, object>>[] includes)
    {
        IQueryable<TEntity> query = dbSet;
        foreach (Expression<Func<TEntity, object>> include in includes)
               query = query.Include(include);
        return query.FirstOrDefault(filter);
    }

    public virtual void Insert(TEntity entity)
    {
        dbSet.Add(entity);
    }

    public virtual void Update(TEntity entity)
    {
        dbSet.Attach(entity);
        context.Entry(entity).State = EntityState.Modified;
    }
    public virtual void Delete(object id)
    {
        TEntity entityToDelete = dbSet.Find(id);
        if (context.Entry(entityToDelete).State == EntityState.Detached)
        {
            dbSet.Attach(entityToDelete);
        }
        dbSet.Remove(entityToDelete);
    }
    public virtual List<TEntity> GetAll()
    {
       return dbSet.ToList<TEntity>();
    }
 }

How to add multiple css values into Style in MVC

@{

string color = "black";

if (Model[i].RevenueRecovered.HasValue && Model[i].RevenueRecovered.Value < 0)

{

color = "red";

       }

}

new { @style = string.Format("width:100%; color:{0}", @color) }