public static int CHALLAN_NO_MaxId()
        {
            int     result = 0;
            DataSet ds     = new Challan_MASTERDataService().Challan_MASTER_GetCHALLAN_NO();

            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                result = int.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString());
            }
            return(result);
        }
        public static int MaxIdbyhotel(int HOtel_ID, DateTime DATE)
        {
            int     result = 0;
            DataSet ds     = new Challan_MASTERDataService().Challan_MASTER_GetMAXIdbyhotel(HOtel_ID, DATE);

            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                result = int.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString());
            }
            return(result);
        }
        public static int minchallan(DateTime From_DATE, DateTime ToDate, int HOtel_ID)
        {
            int     result = 0;
            DataSet ds     = new Challan_MASTERDataService().Challan_MASTER_GetByMinChallan(From_DATE, ToDate, HOtel_ID);

            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                result = int.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString());
            }
            return(result);
        }