protected void FetchGCInvoice(string OrderNo, string EmpID, DateTime sdate, DateTime edate)
{
GiftCardsDAL giftCardsDAL = new GiftCardsDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
List <GiftCardInvoice> giftCardsList = giftCardsDAL.GetGiftCardsInvoice(OrderNo, EmpID, sdate, edate);
GVGiftCardOrders.DataSource = giftCardsList;
GVGiftCardOrders.DataBind();
}