public static void DeleteData(int Id)
        {
            AmountTransferBy obj = new AmountTransferBy();

            obj.Id = Id;
            int Result = obj.DeleteData(obj);
        }
        public static void SaveData(double minValue, double maxValue, int transferBy)
        {
            AmountTransferBy obj = new AmountTransferBy();

            obj.MinValue   = minValue;
            obj.MaxValue   = maxValue;
            obj.TransferBy = transferBy;
            int Result = obj.SaveData(obj);
        }
        public static void UpdateData(double minValue, double maxValue, int transferBy, int transferId)
        {
            AmountTransferBy obj = new AmountTransferBy();

            obj.MinValue   = minValue;
            obj.MaxValue   = maxValue;
            obj.TransferBy = transferBy;
            obj.Id         = transferId;
            int Result = obj.UpdateData(obj);
        }
        public static List <AmountTransferBy> bindUserName()
        {
            List <AmountTransferBy> list = new List <AmountTransferBy>();
            AmountTransferBy        obj  = new AmountTransferBy(0, "");
            DataTable dt = new DataTable();

            dt = obj.bindData();
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    obj = new AmountTransferBy(Convert.ToInt32(dt.Rows[i]["Id"].ToString()), dt.Rows[i]["User_Name"].ToString(), Convert.ToInt32(dt.Rows[i]["MinimumValue"].ToString()), Convert.ToInt32(dt.Rows[i]["MaximumValue"].ToString()), Convert.ToInt32(dt.Rows[i]["User_id"].ToString()));
                    list.Add(obj);
                }
            }
            return(list);
        }
        public void bindUserName()
        {
            AmountTransferBy obj = new AmountTransferBy(0, "");
            DataTable        dt  = new DataTable();

            try
            {
                dt = obj.bindData();

                Lbl_reccnt.Text = dt.Rows.Count.ToString();
            }
            catch (Exception ex)
            {
                Lbl_reccnt.Text  = ex.Message;
                Lbl_reccnt.Text += ">>>>>>>" + ex.InnerException;
            }
        }
        public static List <AmountTransferBy> getAccountList()
        {
            List <AmountTransferBy> list = new List <AmountTransferBy>();
            AmountTransferBy        obj  = new AmountTransferBy(0, "");
            DataTable dt = new DataTable();

            dt = obj.getAccountUsers();
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    obj = new AmountTransferBy(Convert.ToInt32(dt.Rows[i]["User_id"].ToString()), dt.Rows[i]["User_Name"].ToString());
                    list.Add(obj);
                }
            }

            return(list);
        }
        public static string fetchAccountList()
        {
            StringBuilder           json = new StringBuilder();
            List <AmountTransferBy> list = new List <AmountTransferBy>();
            AmountTransferBy        obj  = new AmountTransferBy(0, "");
            DataTable dt = new DataTable();

            dt = obj.getAccountUsers();
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    obj = new AmountTransferBy(Convert.ToInt32(dt.Rows[i]["User_id"].ToString()), dt.Rows[i]["User_Name"].ToString());
                    list.Add(obj);
                }
            }
            //string ss= list.ToString();
            System.Web.Script.Serialization.JavaScriptSerializer jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
            var jsondata = jsonSerialiser.Serialize(list);

            return(jsondata.ToString());
        }