private static string UpdateSales_Tax(Sales_Tax _Sales_Tax)
        {
            DbCommand command = Catalog_Access.CreateCommand();
            //Have to wite the stored procedure
            command.CommandText = "sp_update_Sales_Tax";

            DbParameter param;

            #region
            param = command.CreateParameter();
            param.ParameterName = "@ID";
            param.Value = _Sales_Tax.ID;
            param.DbType = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@Custom_Invoice_ID";
            param.Value = _Sales_Tax.Custom_Invoice_ID;
            param.DbType = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@SerialNo";
            param.Value = _Sales_Tax.SerialNo;
            param.DbType = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@Date";
            param.Value = _Sales_Tax.Date;
            param.DbType = DbType.DateTime;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@PaymentTerm";
            param.Value = _Sales_Tax.PaymentTerm;
            param.DbType = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@SupplierId";
            param.Value = _Sales_Tax.SupplierId;
            param.DbType = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@Buyer";
            param.Value = _Sales_Tax.Buyer;
            param.DbType = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@Address";
            param.Value = _Sales_Tax.Address;
            param.DbType = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@StReg";
            param.Value = _Sales_Tax.StReg;
            param.DbType = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@UpdatedBy";
            param.Value = _Sales_Tax.UpdatedBy;
            param.DbType = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@Return";
            param.DbType = DbType.Int32;
            param.Direction = ParameterDirection.Output;
            command.Parameters.Add(param);
            #endregion

            Catalog_Access.ExecuteNonQuery(command);

            string Return = command.Parameters["@Return"].Value.ToString();

            return Return;
        }
 // update
 public static string Update(Sales_Tax _Sales_Tax, List<Sales_Tax_B> _Sales_Tax_B)
 {
     if (UpdateSales_Tax(_Sales_Tax) == "4")
     {
         UpdateCollection(_Sales_Tax_B, _Sales_Tax.ID, _Sales_Tax.UpdatedBy);
         return "4";
     }
     else
     {
         return "1";
     }
 }
        public Sales_Tax Get(int ID)
        {
            // Customer Detail
            Sales_Tax _Sales_Tax = new Sales_Tax();

            DataTable dt = Sales_Tax_DA.Get(ID);
            //_Sales_Tax.Customer_ID = int.Parse(dt.Rows[0]["Customer_ID"].ToString());
            _Sales_Tax.Custom_Invoice_ID = int.Parse(dt.Rows[0]["Custom_Invoice_ID"].ToString());
            _Sales_Tax.SerialNo = dt.Rows[0]["SerialNo"].ToString();
            _Sales_Tax.SupplierId = int.Parse(dt.Rows[0]["SupplierId"].ToString());
            _Sales_Tax.DateString = Convert.ToDateTime(dt.Rows[0]["Date"].ToString()).ToString("MM/dd/yyyy");
            _Sales_Tax.PaymentTerm = dt.Rows[0]["PaymentTerm"].ToString();
            _Sales_Tax.Buyer = dt.Rows[0]["Buyer"].ToString();
            _Sales_Tax.Address = dt.Rows[0]["Address"].ToString();
            _Sales_Tax.StReg = dt.Rows[0]["StReg"].ToString();

            return _Sales_Tax;
        }
        //insert
        public static string Insert(Sales_Tax _Sales_Tax, List<Sales_Tax_B> _Sales_Tax_B)
        {
            int ID = InsertSales_Tax(_Sales_Tax);

            if (ID > 0)
            {
                InsertPackingWeightCollection(_Sales_Tax_B, ID, _Sales_Tax.CreatedBy);
                return "0";
            }
            else
            {
                return "1";
            }
        }
        public string Submit(Sales_Tax _Sales_Tax, List<Sales_Tax_B> _Sales_Tax_B)
        {
            string msg = "";

            if (_Sales_Tax.ID == null)
            {
                _Sales_Tax.CreatedBy = Session["User"].ToString();
                msg = Sales_Tax_DA.Insert(_Sales_Tax, _Sales_Tax_B);

            }
            else
            {
                _Sales_Tax.UpdatedBy = Session["User"].ToString();
                msg = Sales_Tax_DA.Update(_Sales_Tax, _Sales_Tax_B);
            }

            return msg;
        }