public static List <SP_GetBatchNo_Result> GetBatchNO(string SkuCode)
        {
            try
            {
                using (var context = new SalesReturndbEntities())
                {
                    List <SP_GetBatchNo_Result> objList = context.SP_GetBatchNo(SkuCode).ToList();

                    objList.Add(new SP_GetBatchNo_Result
                    {
                        Product_ID     = null,
                        SKUCode        = "Other",
                        SKUDescription = "Other",
                        Batch_No       = "Other"
                    });


                    return(objList);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }