private List <Mobile_DataTemp> MapMobile_DataTemp(DataTable dt)
        {
            List <Mobile_DataTemp> rs = new List <Mobile_DataTemp>();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Mobile_DataTemp obj = new Mobile_DataTemp();
                if (dt.Columns.Contains("ID"))
                {
                    obj.ID = new Guid(dt.Rows[i]["ID"].ToString());
                }
                if (dt.Columns.Contains("IP_Address"))
                {
                    obj.IP_Address = dt.Rows[i]["IP_Address"].ToString();
                }
                if (dt.Columns.Contains("MobiName"))
                {
                    obj.MobiName = (dt.Rows[i]["MobiName"].ToString());
                }
                if (dt.Columns.Contains("SeriNumber"))
                {
                    obj.SeriNumber = (dt.Rows[i]["SeriNumber"].ToString());
                }
                if (dt.Columns.Contains("StoreName"))
                {
                    obj.StoreName = dt.Rows[i]["StoreName"].ToString();
                }
                if (dt.Columns.Contains("Barcode"))
                {
                    obj.Barcode = (dt.Rows[i]["Barcode"].ToString());
                }
                if (dt.Columns.Contains("ProductName"))
                {
                    obj.ProductName = (dt.Rows[i]["ProductName"].ToString());
                }
                if (dt.Columns.Contains("Sale_Price"))
                {
                    obj.Sale_Price = double.Parse(dt.Rows[i]["Sale_Price"].ToString());
                }
                if (dt.Columns.Contains("CurrentQty"))
                {
                    obj.CurrentQty = double.Parse(dt.Rows[i]["CurrentQty"].ToString());
                }
                if (dt.Columns.Contains("CreateDate"))
                {
                    obj.CreateDate = DateTime.Parse(dt.Rows[i]["CreateDate"].ToString());
                }

                rs.Add(obj);
            }
            return(rs);
        }
 public int Mobile_Temp_Data_Insert(Mobile_DataTemp obj)
 {
     try
     {
         return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "Mobile_Temp_Data_Insert",
                                             obj.ID
                                             , obj.IP_Address
                                             , obj.MobiName
                                             , obj.SeriNumber
                                             , obj.StoreName
                                             , obj.Barcode
                                             , obj.ProductName
                                             , obj.Sale_Price
                                             , obj.CurrentQty
                                             , obj.CreateDate
                                             ));
     }
     catch
     {
         //throw ex;
         return(-1);
     }
 }